SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS doesn't import TXT file
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

senglory
Starting Member

8 Posts

Posted - 01/27/2013 :  11:51:32  Show Profile  Reply with Quote
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?

Edited by - senglory on 01/27/2013 11:53:08

James K
Flowing Fount of Yak Knowledge

3589 Posts

Posted - 01/27/2013 :  16:58:24  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 01/28/2013 :  00:06:59  Show Profile  Reply with Quote
I could not either.

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

Go to Top of Page

senglory
Starting Member

8 Posts

Posted - 01/28/2013 :  01:41:13  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3589 Posts

Posted - 01/28/2013 :  07:57:51  Show Profile  Reply with Quote
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 - 01/28/2013 :  09:57:36  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3589 Posts

Posted - 01/28/2013 :  11:22:48  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000