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

Hello,

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"

SELECT PartOID,LUD FROM Supplier
WHERE  SuplrStatCd = 1  AND LUD BETWEEN ? AND ?

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 3.01.00.00

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
http://www.sqldts.com/default.aspx?6,102,205,7,1

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE, MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org



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 8.01.07.00 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.3.60.00.00

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

11. Problem with Sybase 03.00.02.00 and Raw device

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


 
Powered by phpBB® Forum Software