Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 question about ssis package

Author  Topic 

priyabala
Starting Member

6 Posts

Posted - 2010-11-12 : 14:02:57
I'm a new bee to ssis. We have couple of ssis packages on production .If one of the database tables or views (that the packages depend on )gets dropped and recreated ,what will happen to the SSIS packages?

Would they run fine without any errors next time they run.The database tables and views will have the same structure as before.

I would really appreciate any response.

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-12 : 14:08:44
The packages will be fine, but be sure to test this scenario.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -