August 26, 2008 at 11:35 am
This might be because of several issues. First what is your datatypes?. and Also, I belive there are some null values or values at least looks null, but have some empty strings.
For rt now you can gohead in advance page and select the option On truncation Ignore, But this might end up loosing some data. make sure there is nothing get truncates. ALso, work with some bulit in functions in the SSIS like null functions and types in the derieved expressions.
thanks
August 26, 2008 at 11:51 am
Thanks so much for your response. I turned the truncate to ignore and the error went away. My next issue is when trying to concatenate a date and a time coming in from the flat file to a datetime column in my table. The date and time are both coming in as DT_STR datatypes. Any suggestions?
August 26, 2008 at 12:07 pm
You can try using data conversion transformation in between to the data type you wanted, in your case DT-Date.
-VG
August 26, 2008 at 1:28 pm
VG is right. First combine the two columns as one as string. and then convert that combined column into data type of your choice. You will get an issue if there is any null value or empty string in your combined column.
thanks,
August 26, 2008 at 2:02 pm
Awesome, thanks all. I got it working.
January 30, 2010 at 10:34 am
Check DTS xChange. It will not convert your DTS logic to SSIS but also adds many best practies for SSIS.
http://www.pragmaticworks.com/Products/Business-Intelligence/DTSxChange/
January 30, 2010 at 10:36 am
SSIS Guy (1/30/2010)
Check DTS xChange. It will not convert your DTS logic to SSIS but also adds many best practies for SSIS.http://www.pragmaticworks.com/Products/Business-Intelligence/DTSxChange/
Do you work for this company?
Viewing 7 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply