Parameterized Queries in DTS using SYBASE 11 Driver Version 
Author Message
 Parameterized Queries in DTS using SYBASE 11 Driver Version


I am working on DTS using SQL 2000. My source Database is SYBASE 12
and Destination Database is MS SQL SERVER 2000.

When i try to the following query in Execute SQL Task, it's giving an
error message
"Provider cannot derive parameter information and SetParameter info
has not been called"


I have created 2 global variable in DTS and passing through various
SQL Task in DTS. It's working fine with SQL Server.

Any solution to overcome this problem?

Advance Thanks,

Wed, 30 Mar 2005 05:12:46 GMT
 Parameterized Queries in DTS using SYBASE 11 Driver Version

To use parameters the driver also has to support them and at first look I would guess the Sybase one does not.

All is not lost though as you can easily build the task in an ActiveX script and substitute in the values through there.  Here is an example.  If you need help then shout

Global Variables and SQL statements in DTS,102,205,7,1


Allan Mitchell (Microsoft SQL Server MVP)
I support PASS - the definitive, global community for SQL Server professionals -

Wed, 30 Mar 2005 15:33:40 GMT
 [ 2 post ] 

 Relevant Pages 

1. Bad Timestamp Format at 19 in 1974-08-02 00:00:00.00+01] in PostgresQL

2. Problems after Upgrade 4.00.3711.08 to 4.00.5303.01

3. Help with 00:00:00:00 format

4. Sequence and Oracle ODBC driver problem

5. Sql query doesn`t narrow year --pulls in 00 and 01

6. how do i get only the date format from 2001-01-01 00:00:00.000

7. WHY? last_batch = '01 Jan 1900 00:00:00:000'

8. ODBC Driver 4.00.3513.00 Do Not Install -- Confirmed Issue with Microsoft

9. Need help : Progress 8.3c and ODBC driver Merant ver.

10. Sybase ASE ODBC driver ( version ) and Crystal Reports 4.6 error

11. Problem with Sybase and Raw device

12. problems with ASE 11.9.3 on HPUX 11.00:64 bit

Powered by phpBB® Forum Software