Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export data into a test file using DTS

Status
Not open for further replies.

Indika

Programmer
Jul 31, 2000
13
US
I have two NT servers in a small domain with one running IIS and the other SQL 2000. I logged into both server using a domain user account. Account is part of the local administrator group in both servers. I want to create a DTS job and schedule it to run at night. I am trying to export some data and put it into a text file. I want to save the file on a share on IIS server.

Problem I am having, I can create a DTS job and schedule it on the database server and it runs fine (job creates the text file), but if I try to save the job on the IIS server it fails.

Does anyone have any suggestions? Thanks.
 
Indika ... First of all, please do not cross post in multiple forums. Secondly, this is a DTS question which should be posted in the DTS forum.

PLease refer to posting ... thread962-773328

Thanks

J. Kusch
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top