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

asked on

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,
Jorge
ASKER CERTIFIED SOLUTION
Avatar of Saqib Khan
Saqib Khan
Flag of United States of America image

Link to home
membership
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
PraetorianGuard

Hi,

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