Re: DTS Package
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 10 May 2008 14:49:19 -0500
What do you mean by "it doesn't work?" Do you get any error messages? You might try specifying a DTS package log for troubleshooting.
In addition to security, be aware that a package runs on the machine it is invoked from. If you run the package remotely from Enterprise Manager it runs on the machine with EM rather than on the server. Use UNC paths rather than drive letters to ensure the correct path is used regardless of where the package runs.
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Henry" <henry@mobile> wrote in message news:OhZUqxrsIHA.1236@xxxxxxxxxxxxxxxxxxxxxxx
A DTS package is created to select and convert data by SQL Query command to a .csv file.
Error:
When i schedule the package, it doesn't work. When i excute the package itself, it works.
Checked that the job schedule was already assigned a user with domain admins right.
Any body got an idea?
.
- References:
- DTS Package
- From: Henry
- DTS Package
- Prev by Date: DTS Package
- Next by Date: Reporing service failure
- Previous by thread: DTS Package
- Next by thread: Reporing service failure
- Index(es):
Relevant Pages
|
|
