Link to home
Start Free TrialLog in
Avatar of Physimed
PhysimedFlag for Canada

asked on

Jobs in SQL Server 2005

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.
Avatar of Saqib Khan
Saqib Khan
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PraetorianGuard


By chance can you post this SSIS package?  I have a SYBASE Server Process I need to get data out of daily as well ...  I am new to SSIS and am trying to build a SSIS package to query a SYBASE DB (about 6 tables) daily, inserting only the new or changed data.  

thank you