August 4, 2008 at 2:26 pm
Okay, so I have a database that has a stored procedure that accepts one parameter. Call this Source.dbo.spTheOneToCall. This proc does a select and I need to obtain the results and insert them into a source database table. Call this Destin.dbo.tblDestination. So, wouldn't I want to do this with a Data Flow task? But it seems nearly impossible to do this. First, using an OLE DB Source, I cannot get it to recognize my parameter. Second, even when the source stored procedure doesn't have an input parameter, I cannot get it to display the columns.
I have read all over the internet (Microsoft propaganda) saying this can be done. Have you done it? If so, care to explain how?
Thanks!
August 5, 2008 at 12:57 pm
What error do you get when you pass parameters? If your parameter variable is of type Int34 or Int64 map it to 'LONG' type in the Parameter Mapping.
Also Paramter Name should be 0 if you are using OLE DB connection type.
Also if you could give details about what error you get that will be helpful to understand your issue better.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply