soba
soba

Reputation: 1

Loading text file using SSIS

I am a SQL Developer.I was assigned to load a txt file using SSIS.

The text file has records like :

INS*Y*~DMG*20141211~DTP*348*20150401~DTP*349*20150430~INS*Y*~DMG*19611116~DTP*348*20150401~DTP*349*20150130~

The row delimeter is INS, the column delimiter is ~ (tilde).

The destination table has to be like this:

STATUS   DOB       STATING_DATE ENDING_DATE
Y       20141211   20150401     20150430
Y       19611116   20150401     20150130

I created a destination table in SSMS with the four columns. Then created a SSIS package with flat file source and SQL server destination.

But the result I am getting is only one column. I couldn't seperate the columns.

Can anyone please help me to solve this issue?

Upvotes: 0

Views: 358

Answers (1)

Pedram
Pedram

Reputation: 6508

Have your tried something like this,

Try this

Upvotes: 1

Related Questions