convert string to datetime - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

convert string to datetime

Author

Topic

maihabib
Starting Member

22 Posts

Posted - 2013-12-17 : 06:48:29

I have a string formatted as 2011-11-10 14:30:30.000 and I want to insert it in sql table datetime column.
I’m using derived column in ssis 2005
How shall I write the expression please

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-12-17 : 07:42:12

you can use Derived Column / Script Transformation for that..
Look into the following link for Script task
http://www.gadgetweb.de/integration-services/string-to-date-on-ssis.html

--
Chandu

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-12-17 : 07:45:24

duplicate of
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=190312

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources