Hi there, I have a text timestamp I am trying to insert into sql from an xml file via SSIS. The time stamp looks like this. 2006-12-16T10:00:00+11:00 1. What format/technology is that timestamp? 2. How would I go about converting it into a valid mssql timestamp? Cheers

I think you will have to create an expression with for example a SUBSTRING to create a valid format. This msdn article http://msdn.microsoft.com/en-us/library/ms141036.aspx tells something about converting: See the chapter named Converting Between Strings and Date/Time Data Types An alternative could be some scripting in a Script Task/Component. http://www.codeproject.com/KB/cs/String2DateTime.aspx Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Hi, I believe you input have three different values in it 1) Date 2) Time 3) Time Convertion hours Example : 2006-12-16 -- Date & 10:00:00 Time & +11:00 Time Differ For this you can do one think Split the Value in T then You will Have Date & Time + Time Differ Then spilt the Second part by + -(based condition) then you can get date + time and insert into sql Thanks NaveenNaveen Kumar