SQL Server DTSDiscussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Server DTS section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
I have the flat file with the data
01.08.2008,xyz,yyy
01.08.2008,xyz,yyy
which i need to import the data into the column with the datatype - datetime into sql 2005 table. I tried all possiblility in changing the datatype which matches the destination. In the OLEDB Destination the datatype for the column is "database timestamp [DT_DBTIMESTAMP]". I tried the same by changing the DT_STR to DT_DBTIMESTAMP in the Flat file source through Show Advanced Editor page, nothing working as expectation.
SSIS - Flat file to OLEDB Destination
Linear Mode
