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 2012 Forums
 SSIS and Import/Export (2012)
 Date --> SSIS -->Datetime

Author  Topic 

blodzoom
Starting Member

28 Posts

Posted - 2014-09-25 : 16:17:32
I inherited a process where I run a query on one server, save the results as Text(Tab Delimited) and then run an SSIS package that imports it to a table in a different server.

I have now been tasked to adding a couple of fields to this query/SSIS process. The Query is done but the SSIS package is not cooperating.

The fields are DATE type in SQL server (ex: 2013-04-11). I've tried date and datestamp types. No luck. It tells me that the value could not be converted due to potential data loss error code 0xC020907F.

Any suggestions?

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-09-25 : 16:34:29
are you trying to convert it in the OLEDB input connection or in a separate Data Conversion transformation. if the former fails, try the latter.
Go to Top of Page

blodzoom
Starting Member

28 Posts

Posted - 2014-09-25 : 16:38:53
The existing process already had a Data Conversion transformation, so I'm trying to just add it to that. The existing date fields came in as datetime and used Database Timestamp, so I tried that first, but these new fields are just date and it doesn't like it.
Go to Top of Page

blodzoom
Starting Member

28 Posts

Posted - 2014-09-25 : 16:41:37
Also to add, I tried CASTing them to Datetime in the query, that did not help.
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-09-25 : 18:13:42
Can you successfully preview the data in the OLEDB Source transformation?
Go to Top of Page

blodzoom
Starting Member

28 Posts

Posted - 2014-09-25 : 18:20:35
Yes, I can preview it.

I managed a temporary fix by changing the error handling to ignore the errors. I tested the resulting data and it does not appear that I'm missing anything but I don't know if I should leave it like this as a permanent solution. I don't know if there could be some effect down the line.
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-09-26 : 08:01:01
What is the data type of the new column coming out of the oledb input?

PS. Ignoring all errors will come back to bite you!
Go to Top of Page
   

- Advertisement -