Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

Here's what I did:

  • Connect to SSIS on server A (from management studio on server B, click connect, choose integration services, choose server A)
  • Find required maintenance plan
  • Right click and export to file, save it in a file accessible to both servers
  • Edit file to change server name in connection string to server B
  • Connect to SSIS on server B (as above)
  • Import package
  • Find file exported above
  • Execute it

There are no error messages, yet the maintenance plan doesn't get created on Server B. Am I missing something fundamental about what SSIS packages are about?

share|improve this question
Which protection level are you using when exporting the package? In past I had issue with encryption of sensitive data, so I had to export packages without it (option "Do not save sensitive") to make packages work on another machine. – Emyl Nov 27 '12 at 11:28
I took the default the first time, and the second time I chose "do not save sensitive" and it still didn't work. I'm not aware of any sensitive data in the maintenance task. It's just a series of TSQL commands to do backup. – paulmorriss Nov 27 '12 at 11:31
@paulmorriss I think there's a slight ambiguity in terms. A maintenance plan is found in SQL Server -> Management -> Maintenance Plans - and they are executed using SQL Agent Jobs. Now, an SSIS package can have maintenance plan tasks (like backup db), but not entire maintenance plans inside. So what is it? If it's SSIS, how do you store the packages: in local files or on SQL Server? Can you describe step by step how you connect, where and what do you export? – Marian Nov 27 '12 at 14:37
I'm not sure of the difference between a maintenance plan task and an entire maintenance plan. Here's some useful info: The plan consists of a shrink db step, several TSQL steps and the run an agent job step. In the .dtsx file I can see all of those. I've added info to my question to answer your questions. – paulmorriss Nov 27 '12 at 14:49

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.