SSIS - pass variables to Data Manager for Appset and Application name

[Former Member]

Hi folks,

I'm building an SSIS package, and I can't work out how to set the Appset and Application names in the Convert Task item - I have created the item, and the variables, but I can't work out how to reference the two.

Any tips or help greatly appreciated - this is one of the worst-documented pieces of software I've ever seen!

Thanks,

Jason

[Former Member · Accepted solution]

Hi,

Please refer to the other SSIS packages already created. We need not set these parameters while creating the SSIS package. When we link the SSIS to DM package, we can dynamically send the appset name and the application names.

Hope this helps.

[Former Member · Accepted solution]

Thanks Nilanjan, that was exactly what i needed - thanks a lot!

[Former Member]

Jason Maidment

Why you are using convert task . use make dim task to set the appset name and mbr table name , then add that package to DM