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.
| 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. |
 |
|
|
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. |
|
|
|
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. |
|
|
|
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? |
|
|
|
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. |
|
|
|
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! |
|
|
|
|
|
|
Date --> SSIS -->Datetime