I can understand that. I've wasted 3 days trying to figure this out. Finally got the output variables to work using ADO.NET as the Conn Type, but, as you said, it is FINICKY. I wanted to use the Data Flow Task to move data, but it appears that it doesn't like variables, either, so I'll take my result set and use OLE DB Command to get it into the destination database.
Thanks again.
|