January 3, 2011 at 3:03 pm
Looking at Advanced Editor/Input and Output Columns for the flat file: The external source is a flat file (.csv) and output destination is SQL Server table. The external and output column in question do not match.
When I try to correct this situation in Advanced Editor->Input and Output Properties, by selecting same datatype for external and source columns, and hit ok,the datatype reverts.
There are no other errors.
I often have problems with datatype's reverting! What's the key?
January 4, 2011 at 12:49 am
hxkresl (1/3/2011)
Looking at Advanced Editor/Input and Output Columns for the flat file: The external source is a flat file (.csv) and output destination is SQL Server table. The external and output column in question do not match.When I try to correct this situation in Advanced Editor->Input and Output Properties, by selecting same datatype for external and source columns, and hit ok,the datatype reverts.
There are no other errors.
I often have problems with datatype's reverting! What's the key?
The external data type is the data type of the data in the file. You cannot change the file through SSIS, so it's normal that you cannot change the data type, as SSIS will detect the original data type each time you open the editor. You can however change the data type of the output column. It's OK if they don't match.
If you still keep experiencing issues, try using the data conversion component.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 4, 2011 at 1:13 am
Got it. About the data conversion tool, will try it. Thanks again Koen.
July 26, 2018 at 7:56 am
You need to change the datatype within the connection manager under Advanced pane
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply