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 |
|
jatrix32
Starting Member
49 Posts |
 Posted - 2010-09-03 : 10:06:31
|
| I am trying to create a DTS package that allows me to grab a .csv file and dump it into a DB. Sounds easy, but here is my problem. The .csv file is located in an sftp account.The 2nd issue I am having is the sftp account is on the same server as my database. I am not sure how to go about setting up this DTS package.> grab file from sftp account which is set up on the same server as my database table that I want to import the file too.Any help would be great, as I have never used DTS before. |
|
|
ramecepa
Starting Member
43 Posts |
Posted - 2010-09-14 : 23:44:34
|
| Write the dos command |
 |
|
|
|
|
|
DTS (need to grab file already on server)