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 |
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
 Posted - 2003-08-21 : 13:37:19
|
| I need to use a DTS Data Pump task to populate a table from a file. Trouble is, the table is a base table for an indexed view and I'm getting an error in DTS that I the wrong ARITHABORT setting. What can I do aside from changing my database default setting?Jay White{0} |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-21 : 13:56:57
|
| You could save the DTS package to a VB file and change the options in there. Not sure how to do it, but I would bet that you could do it in the VB file.Also, you could transfer the data into a table rather than an indexed view. Then use an "Execute SQL Task" to transfer the data from the table into the indexed view and you would SET the various options in the task before the transfer.Tara |
 |
|
|
|
|
|
DTS and Indexed View