June 5, 2008 at 3:47 pm
I am trying to use the "?" place holder in my SQL statement so I can map to package variables.
The Parameters... button works properly and I can assign the variables. Also the Parse Query returns a successful parse. But when I click OK or Preview... I get the error message shown below.
If I take out the parameter and hard code a value it works fine. According to the error message I am not sending any parameters
Also the variable I am using has a value, I can hard code the entire statement in the variable pick SQL Cmd from variable and it works fine so I know there is a value.
Not sure how to proceed any suggestions on where to look etc....
thanks
TITLE: Microsoft Visual Studio
------------------------------
Error at DFT - Load AB [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Pervasive.SQL V9 OLE DB Provider" Hresult: 0x80004005 Description: "Unspecified error".
An OLE DB record is available. Source: "Pervasive.SQL V9 OLE DB Provider" Hresult: 0x80040E10 Description: "No value given for one or more required parameters.".
Error at DFT - Load AB [OLE DB Source [1]]: Unable to retrieve column information from the data source. Make sure your target table in the database is available.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC020204A (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
June 5, 2008 at 9:44 pm
One question is - does the provider for Pervasive support parameters ? Some providers don't.
For what it is worth, I get a similar error when trying to preview a query against a SQL Server database using the SQL Native provider when using a similar sort of query
December 8, 2008 at 10:20 am
Brian Knight, author of the Wrox Press "Expert" and "Professional" SSIS books, replied to a similar question that the preview function just doesn't work with parameters. http://www.bokebb.com/dev/english/2006/posts/2006107267.shtml
(Since this SQLServerCentral thread came up first on Google for my query, I figured I'd provide the reference).
December 10, 2008 at 5:56 am
This was a pretty old post and since then I just use a fully formed sql statement to get the data. I am pretty sure the Pervasive OLEDB provider does not support parameters or much else for that matter.
As for the OLEDB provider for SQL server, I can't say whether the preview worked, but I would think if you set variable values it should preview ok.
thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy