I have a table which has a column containing Active Directory timestamp. I have added a column in this table and trying to update it with datetime. I was trying the DATEADD in SSIS as well but that doesn't work either.
I am trying to use the following update command but it gives me the following error.
Ex: AD timestamp : 130153066505493000 converted timestamp: 2013-06-09 21:57:30.547
Thank you Kristen and bitsmed for your response. I tried both the options but I am still getting the same error. Did you try recreating this scenario and did it work for you?