I am trying to create a SSIS package to transfer MSDB and Master from my production to my backup. However Master goes fine. MSDB I am having errors with certain Stored Procs.
On google search I found one place where a person said that SSIS has issues with Stored Procs using variables in subqueries. I see that I have some stored procs with that same thing i.e variables in subqueries and they get transferred. Also, the work around of using
a SSIS variable is not easy as when I am transfering 2 dbs.
Any help will be appreciated.
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!