Passing variables thru data manager

[Former Member]

Hi,

I would like to pass parameters to stored procedure thru data manager.....How to do that....

Thanks

Prabha

[i045436 · Accepted solution]

Hello,

You can create a global variable into SSIS package, populate it from other task with the right value and then use that variable into SQL task Execute SQL query call the stored procedures with the right parameters.

Best regards,

Mihaela

[Former Member]

One thing to note, the DTSX variable name must be ALLCAPS -- at least this is true on BPC 5.1, SQL 2005. I spent a couple hours once scratching my head, unable to get MyVariable to work and with no error messages to guide me.

When I stumbled upon MYVARIABLE, it worked just fine.

[Former Member]

Thanks! I have assigned full points.