SSIS - How you delimit end of file ?

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

isuckatsql SSChampion Points: 10381 More actions · Answer 1

Is deactivating the delimiter the solution ?

Thanks

JamieX Hall of Fame Points: 3763 More actions · Answer 2

So is this what you mean? Your file looks something like this:

Field1,Field2,Field3,Field4,Field5,Field6

1,2,3,4,5,6

6,5,4,3,2,1

And you want to pull it out something like this:

FIELD1 FIELD2 FIELD3 TheREST

1 2 3 4,5,6

6 5 4 3,2,1

isuckatsql SSChampion Points: 10381 More actions · Answer 3

I got it working by deactivating the delimiter but thanks anyway!

I have a new issue with the Foreach loop function.

I have no idea why it is failing and i get the dreaded red box.

It loads one file fine but fails on loading multiples.

isuckatsql SSChampion Points: 10381 More actions · Answer 4

It loads the first file in the folder, then goes to the sixth file in the folder then stops ?

Any suggestions ?

Cookies on SQLServerCentral