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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-18 : 12:54:11
|
| Bernard writes "I am scheduling a DTS package to Export some Tables from Machine A to Machine B.When I run the package normally it works just fine and sends all the tables accross. However, when I schedule the package to run through JOBS it fails with the following error:DTSRun: Loading...Error: -2147287038 (80030002); Provider Error: 0 (0) Error string: The system cannot find the file specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713The account that I use to create the package is a admin on the machine and also a System Admin in SQL. The scheduled job is set to run with this Admin Account as it's OWNER too. SQL Server Agent is started.It looks like a security issue but I am really stuck on this one!" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-18 : 16:37:49
|
| These might be relaventFIX: Error "The System Cannot Find the File Specified"[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274716[/url]INF: How to Run a DTS Package as a Scheduled Job [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269074[/url]HTHJasper Smith |
 |
|
|
|
|
|
DTS Package Scheduling Error