Jobs in SQL Server 2005

Hi,
I have created a SSiS package (package source : File system)  in SQL 2005 which does import data (ODBC-Sybase to SQL 2005), I am trying to execute a daily for that i created a job but it is giving me this error,
SQLServer Error: 536, Invalid length parameter passed to the SUBSTRING function. 
The package runs without error when I execute the package itself (Execute Package Utility).
Through research I don't find the solution.
Thanks,

Posted by:

Comments History


by: on
try scheduling it using batch file and see what happens. dtexec /f "C:\SSIS\DeckDta\DTSX\DoPackage.dtsx" paste above into text file and save with .bat extension. you can always schedule batch files using windows scheduler.
 

Name :  

Email :  

Comment Below