I am trying to run a SQL Server 7.0 DTS package containing several Tasks. I have a DataPump task
that executes a stored procedure on the server running Sybase SQL Anywhere V 5.5
and writes the resulting dataset to a table on a SQL Server 7.0 box.
The stored procedure takes 2 parameters and I am using placeholders and creating 2 global variables inside the DTS to hold the values. example: Exec myreport ?,?
When I run this DTS package interactively then it runs fine.
Also when I hardcode the values, it runs fine.
Example: Exec myreport '2004-03-25','2004-03-25'
When I try to schedule it then the package within SQL Server it fails with an error = Error: -2147217904
(80040E10); Provider Error: 0 (0) Error string: [Sybase][ODBC Driver]Wrong number of parameters Error source: Microsoft OLE DB Provider for ODBC Drivers.
I am also running a SQL Server 2000 Developer edition as a personal server.
When I schedule the identical package to run from my personal server then it
Why can't Sybase read and pass the Global Variables in a scheduled package?