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
 Cannot drop view

Author  Topic 

Grifter
Constraint Violating Yak Guru

274 Posts

Posted - 2012-03-27 : 04:20:59
Hi

I am working on a script that someone else built, and is run by a SSIS package and keeps failing, the error is that 3 of the views cannot be created because they already exist, when i pull the script into SQL server and run it same thing happens but when I go to drop the view it says cannot drop because it does not exist????

Either it does exist or it doesn't so why is one bit saying it already exists and other is saying doesn't exist?

Thanks

G

rajarajan
Starting Member

48 Posts

Posted - 2012-03-27 : 05:10:34
Can u check in the package where the view is created and end of the package view is droped .


let me know in case of more
Go to Top of Page
   

- Advertisement -