SSIS doesn't import TXT file

Last Post 28 Jan 2013 11:41 AM by gunneyk. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
senglory
New Member
New Member

--
27 Jan 2013 08:05 AM
I'm trying to do import of that TXT file
http://sdrv.ms/SVhAnp
into that table
http://sdrv.ms/SViksM
via this DTSX
http://sdrv.ms/SViyAa.

Surprisingly, it gives me no error at all as well as 0 rows of import. I wonder what it doesn't like in my file or in my DTSX package?
gunneyk
New Member
New Member

--
27 Jan 2013 09:24 AM
I am not going to click on links that I don't know anything about but have you tried just using the Import / Export wizard in SSMS? You can walk thru the screens and see what the tool will see to give you a better idea of what may be happening.
senglory
New Member
New Member

--
28 Jan 2013 01:40 AM
I started from SSMS, but it produced package that couldn't export even a single line. That's why I had to edit its package in VS.
gunneyk
New Member
New Member

--
28 Jan 2013 11:41 AM
The import wizard lets you walk thru each step. It gives you a prieview of what it expects to see and import. I suspect you are choosing the wrong type of delimiter or terminators. Try the wizard again and play with it until you see it parse the file like you would expect it to be.


Acceptable Use Policy
---