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 |
|
slboytoy
Starting Member
30 Posts |
 Posted - 2005-10-27 : 16:44:31
|
I have a table that holds all the reference information. From there I have a few views that pull certain information out of the reference table. The views are indexed With Schemabinding.I have a DTS that gets the textfile and goes to truncate the reference table to reload anynew data off of the mainframe. It won't allow me to delete/truncate the table because it has views referenced to it. How can I drop the relationship during the DTS package, then reload the relationship ?? The only reason I'm indexing the views because almost every query they will be referenced.Customer Type -> Customer DescriptionPlant Number -> Plant Description... etc Is that right to index the two fields in each View ? |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-10-28 : 07:06:39
|
Hi,Didn't get you ! , have you refer [url]www.sqldts.com[/url] HTH-----------------------------------------------------------MSSQL Server encryption software http://www.activecrypt.com |
 |
|
|
slboytoy
Starting Member
30 Posts |
Posted - 2005-10-28 : 11:34:20
|
| It doesn't matter if it's in a DTS or SP, the logic will still be the same. |
|
|
|
|
|
|
Index View, trying to Truncate Table....