CODEWITHSUNDEEP
sqlsql-serverssis
ns12345
ns12345

Reputation: 3105

SSIS flat file with string larger than 50

SSIS by default makes the datatype to be String with length 50, what if the string in a certain column is larger than 50 and also I can't use suggest types (it sucks!).

Is there a way to fix this, rather than manually increasing the sizes ie. manually editing the column lengths/datatypes in the flat file manager's advanced tab, ideally changing datatypes based on the destination (sql server) mapping columns' datatypes?

Upvotes: 1

Views: 2834

Answers (3)

ns12345
ns12345

Reputation: 3105

The best way I could do this was write C# code that modifies the ssis package xml file and increases the string length values by looking at the lengths of the destination table (using information_schema query)

Upvotes: 0

Hart CO
Hart CO

Reputation: 34784

I've heard good things about BIDS Helper, but haven't used it myself.

I haven't found a way to change default length, or to stop it from resetting when changing the connection manager. I was pleased that you can select all columns at once in the advanced editor and change them simultaneously, that's something...

Upvotes: 1

Sam
Sam

Reputation: 7678

You can set datatypes in the flat file connection manager. In the advanced section.

Upvotes: 3

Related Questions