alm5586a
asked on
Automating a DTS Package that accesses text files in a SharePoint Document library
I am working with SQL Server 2000. I have a DTS package that needs to acces text files in a SharePoint document library on another server. If I am logged on, I can run the DTS packages and the job will use my credentials to access the SharePoint library. The problem is, I need to set this up to automatically run the job on a daily basis. How can I get the DTS package to pass login credentials when the SQL Server Job agent invikes the job? Alternatively, is there another way that this can be handled so that I am not required to be logged on to allow access to these text files?
from the dts designer - schedule the package to run ..
this will create a job in the sql agent job section ..
look at the steps in the job that is created .. there will be a step to run the dts ..
eg dts run skdhf983983196198401874017 4102 ' lost of ms numbers :)'
you can copy this cope into your own scheduled jobs .. and set your job to run under what ever account you want
this will create a job in the sql agent job section ..
look at the steps in the job that is created .. there will be a step to run the dts ..
eg dts run skdhf983983196198401874017
you can copy this cope into your own scheduled jobs .. and set your job to run under what ever account you want
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
dtsrun /S[server] /U[username] /P[password] /N[dtspackage]