View Single Post
  #2 (permalink)  
Old March 9th, 2007, 02:30 AM
raysot raysot is offline
Registered User
 
Join Date: Feb 2005
Location: Seattle, WA, USA.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to raysot
Default

...this is crazy.. It can't be this difficult to set an Output variable in SSIS, can it? I've been at this for 3 solid days now, tried every connector, with every conceivable combination of parameters, with no luck.

The sproc return the desired rowcount of a table both as a single-row resultset, and as a return value. And still the Output param in the SSIS package remains untouched.

Help, before I become an Oracle convert! :-) At this point I'm even willing to let someone remote into this server to set me straight!



Ray Sotkiewicz
Reply With Quote