February 2, 2007 at 11:26 am
Hello ,
I created a package in SQLserver2005 and then I created a job to call this pacakge using Filesystem and then the job failed . I checked the history and the log stated that it can not find the package.
Any idea or advice would be appreciated.
Thanks
February 2, 2007 at 4:00 pm
First move this thread to correct topic so that you can get fast and accurate answer...
Did you check in the job step at the bottom of general properties tab...package location is correct...you should see similar to the following...and when you click the button (...) you should see the package in a seperate window...
\File system\packagesname
And also in the command tab package location is the same as in general tab...
Is Job owner has the rights?
MohammedU
Microsoft SQL Server MVP
February 2, 2007 at 4:09 pm
Thank, everything looks fine.
This is command line
/FILE "\\Primed.com\SAN\Home\fma01709\My Documents\Visual Studio 2005\Projects\DeveloperEditionProejct\DeveloperEditionProejct\OracleToFMDDeveloperedition.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF
This is the link from job step
\Primed.com\SAN\Home\fma01709\My Documents\Visual Studio 2005\Projects\DeveloperEditionProejct\DeveloperEditionProejct\OracleToFMDDeveloperedition.dtsx
February 2, 2007 at 5:46 pm
Does SQL agent has the access to this network folder?
Why don't you save the dtsx file locally on the server?
MohammedU
Microsoft SQL Server MVP
February 2, 2007 at 6:03 pm
The sqlserver agent runs under local machine and the folder is located in the same machine, so it should be fine.
Is there a trace that can be run not profiler that would help to trace issues such as this ?
Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply