Help me!

I try to import some data from an informix 5.0 table to Sql Server 2000 with
a DTS package.
I use Intersolv ODBC driver version 03.011.0021 to connect to the database.

It works well, but i can't define a parameter in the sql statement. For
example if a try to execute :

select *
from table
where field = ?

The dts environment give me an "unspecified syntax error....."

Where is the problem?
The driver don't support parameters or these must be defined with another
syntax?

Bye
Daniele

Hi Daniele,

I was in a similar situation where I needed to pull some data out of
Informix 7.3 passing parameters to the queries. What I ended up doing was
writing Informix reports with input parameters (not that hard) letting them
save output as files, and then pulling files to the sql server side. Used
rsh service to execute reports and rcp to transfer the output. Worked like a
charm. This way I was not depending on ODBC/OLEDB driver idiosyncrasies.
Good luck.

Ilya

"Nonno Oreste" <dffdfd (AT) dfd (DOT) dfd> wrote

Very possible that the driver does not supoprt parameters like this.

Try rearranging to use this

Global Variables and SQL statements in DTS
(http://www.sqldts.com/Default.aspx?205)

--
--

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

"Nonno Oreste" <dffdfd (AT) dfd (DOT) dfd> wrote

It works well, but if it's possible to use parameters it's faster to
develope a package.

Hi
Daniele

programmer..... :-(
I develop on MS platform and so i can use only the MS technologies such as
ODBC..... :-(

I was not either. I was in you shoes. Informix sql is very close to SQL-92
and UNIX ain't that bad.
"Nonno Oreste" <dffdfd (AT) dfd (DOT) dfd> wrote

What about using ActiveX task to compose a sql statement string including
actual parameter value into a package variable and then using dynamic
properties task replace the statement to what you've composed. This way you
do not have to pass parameters. This worked for me once.

Ilya

"Nonno Oreste" <dffdfd (AT) dfd (DOT) dfd> wrote