hi all !!!

I am trying to push some data from SQL Server to Informix via ODBC.

The insert query for Informix is:
INSERT INTO informix.table (field1, field2, field3, field4) VALUES (?, ?, ?,
?)

During design time, when I try to parse/show parameters I get the following
error:
"Provider cannot derive parameter information and SerParameterInfo has not
been called."

The question is: how could I overcome this problem ? is there any other way
to insert information in a target database like this ?

(one again) thanks in advance,
ant.

The ? is a placeholder as you know. The problem is though that not every
driver supports this type of action. Easiest way? Set the statement up in
an Active Script task beforehand

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

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Antonio Lopez Arredondo" <adog (AT) someplace (DOT) com> wrote