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 - 2000-12-15 : 15:21:49
|
Michael writes "I'm fairly new to SQL and really could use some guidance.
I'm attempting to automate a daily process of importing a series of 3 .txt files from a remote FTP site into SQL Server 7 through a DTS package. The package currently deletes the destination tables, appends the filtered data, and sends E Mail notification.
We would like to automate the FTP portion into the existing package. I've done some searching on the WEB for this information and come up with very little. Is there a way to incorporate an FTP transfer in a DTS package?
Can a .bat or .exe file be called from within a package? If so, I could write something in VB to do this. (Doesn't seem very eloquent, though..)
Thanks for any help or direction that you can provide...." |
|
|
|
|
|
Include FTP in a DTS package