September 22, 2011 at 6:00 am
Hi ,
I need to import Flat file having format "~" delimiter.
I want to use SSIS.
Please explain me in detail which data source do I need to use for that.
Thanks,
Pravin
September 22, 2011 at 7:46 am
Flat File Data source connection will be able to do this, you will just need to change the column delimitter to match your delimitter
September 22, 2011 at 9:08 am
No you can't. Flat File doesn't support the tilda character ("~") as a delimiter.
You have two solutions. You can use the raw file import, and thus have no text delimiter. This will cause all your data to come in exactly as it is in your text file. Then, you can use the script task, split the string using the string.split function in .NET, and store the values in the appropriate columns.
The other solution is to do the same thing, except using a flat file connection, and a delimiter which your text file doesn't contain, like say, the pipe ("|").
Raw file is probably the better solution, but it can be a bit finicky sometimes.
The final alternative is to just use BCP instead of SSIS - but I haven't used BCP before so I can't help you on that one.
September 22, 2011 at 9:58 am
kramaswamy (9/22/2011)
No you can't. Flat File doesn't support the tilda character ("~") as a delimiter.
This is incorrect, SSIS does support the tilda character and pretty much most characters that you could can realisticly expext to use. Sure its not in the preset drop-down box but you can simply type any character you want in there
You have two solutions. You can use the raw file import, and thus have no text delimiter. This will cause all your data to come in exactly as it is in your text file. Then, you can use the script task, split the string using the string.split function in .NET, and store the values in the appropriate columns.
The other solution is to do the same thing, except using a flat file connection, and a delimiter which your text file doesn't contain, like say, the pipe ("|").
Raw file is probably the better solution, but it can be a bit finicky sometimes.
The final alternative is to just use BCP instead of SSIS - but I haven't used BCP before so I can't help you on that one.
Ignore this, use SSIS it is much easier..
September 22, 2011 at 10:01 am
steveb is correct. Ignore Kramaswamy's post.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
September 22, 2011 at 10:24 am
What? seriously? Okay ... learned something new then. thanks!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply