question

rajesh9345 avatar image
rajesh9345 asked

How to read a Flat File with data delimited by any wild card character like ‘#’, ‘$’ (SSIS)

How to read a Flat File with data delimited by any wild card character like ‘#’, ‘$’ (SSIS)? Thanks, Raj
ssisflat-file
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tom Staab avatar image
Tom Staab answered
If you mean the columns are delimited by 1 particular character, you can set that when you configure your flat file connection manager. You can also set any row delimiter there. The "Columns" tab of the connection editor gives you both options. You can put any character or set of characters for each delimiter. If you do not know the delimiter in advance (but can determine it during runtime), you could try reading all data in each row as a single large string column. Then you can parse the data using a script transformation component to split it into columns. That is a pretty simple task using the C# string Split method. Once the string is split, you can perform whatever validation or other operations you want on each element and then return them as columns in the output to be stored as columns in your destination.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

rajesh9345 avatar image
rajesh9345 answered
Could you share sample screen shot.. Thanks, raj
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

StanKulp avatar image
StanKulp answered
Add $ as the column delimiter in the columns tab and click the refresh button. ![alt text][2] [2]: http://i.imgur.com/M8gAa8l.png
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.