DTS Scheduling Problem (DTS newbie)

[RikHess]

I have created a DTS package using the DTS Wizard. It was set up as a scheduled job to run daily. All it does is transfer a SQL statement to a CSV file.

I can run it fine from Enterprise Manager by right-clicking on the Local Package and selecting Execute Package, but the scheduled execution never happens.

In looking at the SQL Server Agent in EM's Management, the View Job History show it Failed every day.

Can someone help me figure out what is happening?

TIA!

 

[unclerico]

where is this .csv file being created/populated?? Is it on the local file system or on a remote system??

 

[RikHess]

I am creating the cvs file on my local C: drive, not the SQL Server.

 

[mrdenny]

RikHess,
To make the DTS package export to your workstations hard drive you'll need to be sure that the SQL Server is running under a domain account, and that account will need rights to access the network share that it will be using to write to your machine.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com