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.
| 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. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-28 : 00:06:59
|
| I could not either.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
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. |
|
|
|
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. |
|
|
|
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? |
|
|
|
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. |
|
|
|
|
|
|
|
|
SSIS doesn't import TXT file