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.
| Author |
Topic |
|
AAAV
Posting Yak Master
152 Posts |
 Posted - 2010-05-03 : 10:32:36
|
| I drop the index in the first step of the SSISIF EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_gross_up_netted_id') DROP INDEX [gross_up_netted].IX_gross_up_netted_idGOIn the last step i recreate the indexCREATE UNIQUE CLUSTERED INDEX IX_gross_up_netted_idON gross_up_netted (vc_trimid)GOIt fails when i try to recreate saying it already exists.What am i missing? |
|
|
|
|
|
SSIS error when creating index.