Hi all, I have a script component in my package that creates an EST datetime, which I need converted to GMT. The script doesn't appear to recognize System.TimeZoneInfo. Does SSIS run an old version of .net framework? In any case, what's a decent way to convert my script's EST datetime into GMT, taking into account daylight savings? thanks, sff

DateTime.ToUniversalTime Method needs to be used Examples: http://msdn.microsoft.com/en-us/library/system.datetime.touniversaltime.aspxArthur My Blog

DateTime.ToUniversalTime Method needs to be used Examples: http://msdn.microsoft.com/en-us/library/system.datetime.touniversaltime.aspxArthur My Blog

Thanks for the reply. Ok - now the time data I'm getting is Eastern time. The server that actually HAS the data is Pacific time. Is there a way to tell the program that the specific datetime piece is going from EASTERN -> UTC, and not pacific -> UTC? Thanks, sff

Hi sff, I guess you must use the FindSystemTimeZoneById method. The link I gave you happens indeed to have a sample piece of code for it. Arthur My Blog