Hi,
I´m trying to retrieve data in SSIS from DB2 server with OLE DB and the data
access mode "SQL Command". The SQL query I am using works in SQL Management
Studio, in BIDS it doesn´t and I need the where-clause. One Problem the
parameters - without these the query works. Below a subset of the query:

SELECT M_TS_YEAR, [...] FROM SCHEMANAME.TABLE WHERE M_TS_YEAR = ?

With this query it´s possible to open the window "Set Query Parameters" from
"OLE DB Source Editor" and I can map the variables (2009 = ?). But the
preview don´t work with the question mark.

- the error message: Wrong number of parameters.
so I changed the name of parameter in SSIS to var1
- the error message: The SQL statement does not contained any parameters.
....

So I´m searching for a possibility to retrieve data from DB2 by using a
where-clause and parameters. Any ideas..? Thanks!!!


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/communities....sqlserver.dts