Calling a SSIS package via SQL ServerAgent

Hi,

I was looking at a previos thread in this very queston and the answers given to it, I tried a SSIS package that works fine on its own but on creating a new job and invoke it, the JOB fails ,it says its not able to locate the file specified,

I tried copying the package to the server machine wher am creating the job,but again the same error; and when i try to alter the protection level of the SSIS package to Server Storage its throwing an error like '' This protection level cant be applied to this destination,The system can't verify that the destination supports storage capacity. this error occurs when saving to XML."

I am using OLE DB Destination in the dataflow task of the SSIS package I ve created. Please guide whr am going wrong. Some detailed steps which has some screenshots depicting step by step procedure of creating a JOB that calls a SSIS package will be highly helpful

Thanks in Advance,

Take a look at http://support.microsoft.com/kb/918760, it explains the various protection levels and how to troubleshoot package execution under Agent.|||

thanks for the link...

but the link does not say anything on how to put the SSIS package on the server where we are creating the job. I did it manually and when I look for the package in the SQL Server agent window (in the package combo) I am not able to locate the package.

When do we any export / import of data through the wizard, we have an option of saving the same as SSIS package right? Those are the packages that get listed :(

Can someone say which is the path I need to put my SSIS package so that it can be picked, I think once its done there shouldn be any issue in executing the same

thanks in advance

|||

The SSIS package should be saved under SSIS Packages\Servername (your SSIS server name).

then in SSMS connect to Integration Services Server and look under StoredPackages\MSDB. The saved package will be there.

Hope this helps