After importing package remains on database even after deletion

Question

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

Answer 1

Now this package is stored in SQL Server... Now you will have problem to modify it....

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance

Answer 2

Use dtutil to delete the package from SQL server

http://msdn.microsoft.com/en-us/library/ms162820.aspx

Answer 3

Did you import it to the MSDB? By importing you have copied the package from the file system to the SQL database... deleting the package on the file system doesn't delete the version in the database. It's a copy... and it can be executed.

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 4

Hi SSISJoost,

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

Answer 5

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: http://microsoft-ssis.blogspot.com | Twitter