Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS doesn't import TXT file

Author  Topic 

senglory
Starting Member

8 Posts

Posted - 2013-01-27 : 11:51:32
I'm trying to do import of that TXT file
[url]http://sdrv.ms/SVhAnp[/url]
into that table [url]http://sdrv.ms/SViksM[/url]
via this DTSX
[url]http://sdrv.ms/SViyAa[/url].

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?

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-27 : 16:58:24
I could not see the screen shots in the link thats you posted - could be me, but I suspect not. I am not behind any firewall or on any corporate network, so it should have been visible.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-28 : 00:06:59
I could not either.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

senglory
Starting Member

8 Posts

Posted - 2013-01-28 : 01:41:13
quote:
Originally posted by James K

I could not see the screen shots in the link thats you posted - could be me, but I suspect not. I am not behind any firewall or on any corporate network, so it should have been visible.



There're no screenshots, I put on SkyDrive SQL file with table definition, TXT file to be imported, and DTSX package for doing that import.
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-28 : 07:57:51
I could not access the skydrive - I just saw an icon, perhaps because I don't have skydrive installed on my computer. Even if I had, I (and probably others on the forum) would be weary of downloading a script or dts package to their computers for obvious reasons.
Go to Top of Page

senglory
Starting Member

8 Posts

Posted - 2013-01-28 : 09:57:36
quote:
Originally posted by James K

I could not access the skydrive - I just saw an icon, perhaps because I don't have skydrive installed on my computer. Even if I had, I (and probably others on the forum) would be weary of downloading a script or dts package to their computers for obvious reasons.



Ok, how I could show an DTSX file in that case?
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-28 : 11:22:48
I don't know of a way other than uploading the screen shots to some image sharing site such as imageshack and then posting the URLs.

Couple of easy thing you could do to test - and these should take only a few minutes - is use the Import/Export wizard (right click on the database name in SSMS object explorer and select tasks -> Import data) and see if you are able to import the text file. You can choose to import to a new table (which will be automatically created for you). If that succeeds, see if you can import into your existing table that you really want to import to. If you are able to do that, then Import/Export wizard allows you to save the package.

Another option would be to run the package from BIDS - which gives you a lot more options to debug and trace; but before you go to that trouble, the steps I listed earlier are probably simpler and easier to do.
Go to Top of Page
   

- Advertisement -