Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CloudDeity
Starting Member
1 Post |
 Posted - 2011-03-30 : 14:24:01
|
| I need help with my data flowShort versionI have source and I'm trying to pass it down to an OLE DB CommandI'm trying to call a stored procedure in that Command and I want to pass in data from my source as parameters for my Stored ProcMy command looks like exec sp_My_SP ?,?,?But I get an error and I cant map my parametersHow do I fix thisLong VersionI have a source where I get names of people and their addressesTable 1 has the name and I generate a keyTable 2 has the address and an FK referencing Table1Basically I want to insert into table 1, generate a key and use that in table2And since you cant get the identity of the item you just inserted and reuse that in your data flow - I tried doing it all at once in a stored procedure. But I have trouble passing in parameters into a stored procedure in my data flow.Any help would be niceThanks |
|
|
|
|
|
OLEDB Comman Stored Proc Parameters