November 26, 2009 at 11:27 am
Rebuilt my windows 2003 box recently. Installed sql server 2005 including SSIS. I am NOW having a problem with the OLE DB Command, data flow transform where as on my old box, I did not have this problem. Not sure if it is a permission problem, a syntax error or some other non specific error :/ .
In order to debug, I created a new project who's only job is to execute a test transform using the OLE DB Command:
Input:
TESTINPUT TABLE (id,data1)
Transform:
OLE DB command: takes the two input fields from the testinput table and inserts them into an identical output table called TESTOUTPUT table (id,data1). The id field is defined as an auto identity on the input, but not on the output.
This mirrors what I am trying to do in my original transform, but on a smaller scale.
The Problem:
On typing out the SqlCommand I am entering: exec aspdnsf_CPTEST ?,?. I get an error that says :
"Error at Data Flow Task[OLE DB Command[37]]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Syntax error, permission violation, or other nonspecific error".
When I remove the ?,? this error does not occur but of course I then get an error on mapping when it executes.
I have tried brute forcing the parameters in the "Input and Output Properties" and everything else in between. I even looked at the version of the component and compared to one that works on another server I have to no avail.
ANY help or advice would be really appreciated... :-/.
November 27, 2009 at 6:30 pm
did not add service packs..sp2 and now sp3, case closed
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply