October 14, 2013 at 2:57 pm
I have a tab-separated-value (TSV) input file for my SSIS package. When I point to the file to create the Flat File Source, SSIS uses a string data type (OK, I can deal with that...) and a length of 50. Well, some of the columns are bigger than 50 characters. In my data conversion step, I ignore truncation, but I'd rather the input file allow up to 255 characters.
I went to the advanced edit for the flat file source component of the Data Flow step and changed the properties of one field I know violates the 50-character limit to 255 characters. It worked, but I got a warning that the metadata didn't match the properties sheet. Did I do this wrong? I don't want silly warnings....
Jim
October 14, 2013 at 3:25 pm
You need to change this in the flat file connection manager (in the advanced properties), not in the flat file source.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 3:40 pm
Perfect. Worked like a charm. Thanks
Jim
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply