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 |
|
stonebreaker
Yak Posting Veteran
92 Posts |
 Posted - 2011-04-28 : 17:16:51
|
| I am extracting a rowset from a database on one server and need to send it to a stored proc for processing on the destination server. The only input parameter on the stored proc is a TVP with two columns. I can pull the data from the source database no problem by calling a stored proc on that server. I can see the result set's columns in the OLE-DB Source data flow item; but when I set up a OLE-DB destination item and try to use SQL Command mode, it doesn't want to show the destination columns in the TVP. I'm sure I'm missing something obvious.These databases until recently were on the same server, thus the desire to use the already-written stored procs.StonebreakerThe greatest obstacle to discovery is not ignorance - it is the illusion of knowledge. -Daniel Boorstin |
|
|
|
|
|
need to pass rowset to stored proc with tvp