Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mattisimo
Starting Member
3 Posts |
 Posted - 2010-03-10 : 06:35:52
|
| Hi,I am currently developing completely on a local machine and have a DTS package that on completion should run a local exe file that compresses the csv files that were just imported.If I run the package in the designer or directly then all is fine and the files are compressed. If I run the file from SQL Agent as a scheduled task or manually start the task then the DTS runs fine and completes successfully but the files are not compressed. I also tried pointing the step at a basic bat file that deletes the csv files. This doesn't run either.I don't think there are any network access issues as everything is running from local disks and the data is imported from the same directory as where I want to run the exe.I have tried running my SQLSERVERAGENT service as .\Administrator and also as Local Service Account without success.Any pointers on how to achieve running a simple exe or bat file would be greatly appreciated. Thanks,Matt |
|
|
|
|
|
Execute process task - doesn't run exe