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 |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2007-02-09 : 03:24:36
|
I have asked everyone I know about this but noone has a clue so I turn to the high-end segment of my network which has yet to fail me  I have some ascii files on a unix-box that are quite large (4GB total)that I need to transfer to my windows-server to be bulk-imported in to a database on a daily basis. I use basic dos-prompt ftp and when I transfer the ascii-files using ASC transfer mode everything works fine. However, when I compress the files in tar-format I have to transfer usin BIN to be able to uncompress the file on the recieving end. When I uncompress the tar-file and open up the ascii-files they are "corrupted" in the same way as if I transferred them usin BIN mode directly without the compression. Any clues on what I can do to work around this...?--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-09 : 11:51:58
|
| untar the files using winzip. winzip has a feature that will convert unix ascii files to windows ascii formatted files. I think it is enabled by default, but if not check around in the preferences.there are many other utilities that can convert unix ascii to windows, but I find winzip to be the easiest. -ec |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-09 : 11:55:22
|
also, TAR doesn't really compress. it is just an archive that holds a bunch of files. you would normally combine TAR with GZIP to compress the archive.a command like the following on your unix/linux environment should do the tricktar cf - target | gzip -c > target.tgz I pulled this example from http://www.tech-recipes.com/unix_tips64.html-ec |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2007-02-14 : 04:38:03
|
Sorry for not getting back to you sooner but I have been in the mountains snowboarding since friday  The files are as you say archived using tar and compressed with gzip. I have not yet tried uncompressing with WinZip but I did try with the command line version of 7zip and this is when I got the problems. I'll try winzip and see what happens...thanx --Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
|
|
FTP problems - bin/asc