KnowlegeZone.com, Share knowledge Gain knowledge
New Articles:
     

Home > SQL : Jobs in SQL Server 2005

Question By: Physimed   Date: 8/27/2008

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,



Share |


Comments.
Comment/Solution Posted By: adilkhan    Date: 8/27/2008 1:37:00 AM
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.


Pages :
Post Comment or Solution   OR   Sign in using Google/Aol/Yahoo/Msn/OpenID
Your Name:  
Your Email:  
Comments:
 
Please Verify:
(Type Answer)