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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -