Flat File Source Problem...

[victordba]

I have a weird thing happening.
I have an .csv file. When I try to load it into a table, I can do it easily in DTS 2000. But when I am trying to do it in SSIS 2005 with exactly the same settings (like Text qualifier, row delimiter etc.), I am getting an error: "The last row in the sampled data is incomplete. The column or the row delimiter may be missing or the text is qualified incorrectly." I looked at the file and it looks complete to me.

What could be the problem ?

P.S. DTS 2000 is on 32-bit Windows, and SSIS 2005 is on 64-bit Windows 2003. Could that we a problem ?

 

[victordba]

Guys ? Anyone ?
I can't believe that nobody had this problem with delimited text source file.

 

[IBACFII]

I would open the file and take a look. Then I would compare your SSIS data flow to that of your DTS. Then look at the SSIS settings for that file.