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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-24 : 01:20:29
|
| John Overton writes "I am currently in the planning stages of importing textfiles from mainframes into SQL Server. However, I am unable to use DTS packages because the servers with the text files are not on the network. I am able to FTP into the server to get them, but I would like to keep it automated with a DTS package. I read the article on FTP through SQL, however, I would perfer to run DTS. Any help would be great. Are there any dll's or protocols I need to be able to connect with a DTS by using an IP address.Please Help.John Overton" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-24 : 08:05:56
|
| You can certainly use DTS in combination with FTP. You'd first FTP the file to a local (or network accessibly) drive and then use DTS to import it. SQL Server 2000's DTS has a built in FTP task, it is documented in Books Online and the DTS Help file.If you don't have SQL Server 2000 you can incoporate FTP functions with this:http://www.sqlteam.com/item.asp?ItemID=6002Once you get this procedure set up, add an Execute SQL Task to your DTS package and call the stored procedure. Then link this step to following steps using an On Success arrow. You need to ensure that the FTP operation completes before the data import begins, so it might make more sense to have 2 separate packages; the first performs all of the necessary FTP transfers, and the second does all of the DTS. |
 |
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2002-06-24 : 08:37:46
|
| Rob's wrapped it up in a nutshell but which version of SQL are u running? If it is V7, there is a issue with testing the success of workflow components pre SP3. Flow success or failure is ignored. I will dig out the MS article on this...Dan |
|
|
|
|
|
|
Import from non-network server