Error running parameterized query against MySQL database in SSIS package
Posted on 2010-01-04
I am building a SQL 2005 SSIS package to accomplish a task that was previously done in SQL 2008 without any problems. The first control flow step connects to a SQL 2008 database and retrieves and stores an data in variables. That part isn't a problem. The second step connects to a MySQL database and runs a query using the varaibles as input parameters. At this Point I get the error:
'INSERT INTO test (TestID) VALUES (?test)': 'Only MySqlParameter objects may be stored'
I try both with @ or ?. An also the "Allow user parameters" and "Use old syntax" in the my sql connection settings. Nothing helps.
If I try it with
'INSERT INTO test (TestID) VALUES (1) it works also fine. Only with parameters it fails.
On my SQL 2008 SSIS packets it works fine. I use my sql ado.net connector 6.1.3 on both SQL 2005 and SQL 2008.
ANyone an idea?
Thans a lot.