sql server dts: Scheduling DTS packadge -- sql server dts

Scheduling DTS packadge

Daniel Berezniak
7/29/2004 9:22:06 AM

sql server dts:

Hi,

I've created a DTS package which after opening a
connection uses a "Transform Data Task" to select data
from a table and then creates a .csv file using the "Text
File (Destination)" connection. On success I execute
a "SQL Task" which simply updates a FileIsCreated column
on a table. Here is my problem, when I execute the
package with in the Data Transformation Services folder
everything works perfect. The .csv file is created with
the correct data and the table is updated. But when I
try to schedule the DTS package with the SQL Server
Agent, the package does execute but the .csv file is NOT
created. Also the FileIsCreated column is updated
meaning the package does go through its steps. Does any
one have an idea why the file in not created.

Thanks in advance.

Daniel B

Re: Scheduling DTS packadge

Allan Mitchell
7/29/2004 6:13:03 PM

Remember this file will be created relative to the server when run as a job
so it may be you are looking for it in the wrong place.

Have a peek at this article though as it never hurts when beginning to
schedule DTS packages

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

[quoted text, click to view]