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 |
|
warrentyler
Starting Member
6 Posts |
 Posted - 2011-07-25 : 14:01:04
|
Hi,
I have been using a SQL Server job Step to connect to a regular FTP site. Basically I create a job step with this info:
1) Operating system (CmdExec) Step: FTP -s:K:\FTP\ftpauto1.txt
Which:
1) Opens a DOS prompt at c:\documents and settings....
2) reads FTP from the job step, then -s: (driveletter):\path\script file containing the FTP commands to connect get a files etc.
My issue with creating the job step using SQL Server job is:
When the DOS prompt opens at: c:\documents and settings....
I don't know how to tell it to:
CD to D:\ drive, cd to a directory FTP to find the PSFTP.exe and run my script file.
I need the SQL job step to do this: C:\, cd d:, d:\ cd ftp,
to end here D:\FTP.
Anyone know if I can do this in the SQL job step?
Thanks,
Chris
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-25 : 14:03:52
|
seems like what you need is a batch file which you need to call it from your sql job using xp_cmdshell
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
warrentyler
Starting Member
6 Posts |
Posted - 2011-07-25 : 14:19:57
|
HI,
I have created a batch file with the PSFTP commands. I would like a way to call it from a SQL Server job step.
Any ideas?
Thanks,
Chris |
|
|
|
|
|
|
Connecting SQL Server to PSFTP