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 |
|
milkmanwes
Starting Member
1 Post |
 Posted - 2007-04-30 : 13:52:54
|
| I want to transfer a csv file from one sql server to another on opposite sides of a very resrictive firewall. In fact the only open port between the two is the sql port. The reason I want to transfer this as a csv file is that a turn key app on the recieving end uses a custom DTS widget for import that likes CSV files - so much so that they are the only thing it understands.I have already come up with a few ways to skin this cat, but here is one which isn't necessarily the best option that I was really curious if it would work.The receiving server - WATSQL3The origin server - LMSCreate a linked server on WATSQL3 to c:\incomming using the Jet ODBC with a schema.ini file residing in c:\incomming defining the layout. We will call this IncommingCreate a linked server on LMS to WATSQL3.From LMS run a select into into WATSQL3.Incomming.newfile#csvStart the import DTS package on WATSQL3 and voila it loads c:\incomming\newfile.csvI know this is a long way around a simple problem - but I was curious if anyone could tell me if it would work. Specifically can a linked server be referenced on a linked server? |
|
|
|
|
|
Transfer