After importing package remains on database even after deletion


  • I am a SQL Server newbie. I imported a package stored on my filesystem into my SQL Server 2008R2 database. Later on I deleted the package from the file system. However the package continues to remain in the SQL Server database and even executes!

    What little I know implies this should not happen since even SQL Server will be referring to that package stored in the filesystem. So my question is: is this behaviour normal? If not what could be the possible reason for it

    Monday, January 21, 2013 4:40 AM


  • Hi SSISJoost,

        I have impoted from the FIle System folder exactly in the manner you have shown above(right-click-> import)

    Then it's a copy (with no reference to the package in the local Windows folder) that can be executed from the MSDB

    Please mark the post as answered if it answers your question | My SSIS Blog: | Twitter

    • Marked as answer by Sparky_47 Monday, January 21, 2013 9:17 AM
    Monday, January 21, 2013 7:03 AM

All replies