October 8, 2007 at 11:17 am
I hope I'm posting in the right section
Here goes...I'm developing an application which needs to interface with Ingres. My main Db engine is Sql Server 2000, and the interface is done via a DTS which "should" execute some parameterized queries against the Ingres DB.
Before entering the parameterized criteria the statements execute fine...however after including the parameter place holder "?" i get the following error (message prompt):
---------------------------
Package Error
---------------------------
Error Source : Microsoft OLE DB Provider for ODBC Drivers
Error Description : Provider cannot derive parameter information and SetParameterInfo has not been called.
---------------------------
OK
---------------------------
As you can see...I'm using ODBC drivers to establish the Ingres connection....
I'd appreciate any help you can give.
October 11, 2007 at 6:12 pm
How did you design your DTS package?
How did you get the data from Ingres DB?
The first thing that came to my mind was using Dynamic Property Task.
my 2 cents
November 21, 2007 at 1:13 pm
Sorry for replying just now...i used the DTS designer as for how i got the data from Ingres I used a transform data task.
Do it this way allowed me to retrieve the Ingres data and direct insert them into the destination table...
And thanks for your reply...needless to say i still have this problem...
but have plenty of other things on my hands to keep me busy until i find a solution.
November 21, 2007 at 6:50 pm
First you have to set up a ODBC connection for you Ingres database. Go to Control Panel and set it up.
It seemed to me the error message said you did not set up the connection or did not set it up correctly.
What kind of parameter did you want to pass?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply