none
SSIS package to create maintenance plan fails silently

    Question

  • This is SQLServer 2008.

    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?

    Extra 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 chose the option "do not save sensitive data" but I'm not aware of any in the plan.

    Thursday, November 29, 2012 4:55 PM

All replies