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 |
|
mdelgado
Posting Yak Master
141 Posts |
 Posted - 2002-07-18 : 08:06:39
|
| Good Morning...I'm having a problem with one of my DTS packages and I hope one of you can help me.One of my packages executes every night. It contains a SQL-Task that up until yesterday everything was running fine. When the DTS package executes this step I get the following error:Error Source: Microsoft OLE DB Provider for SQL ServerError Description : Deferred prepare could not be completedStatement(s) could not be prepared.DELETE failed because the following SET options have incorrect settings: 'ARITHABORT'.I didn't change anything on my server from the time it worked to the time it failed; I've already set both Arithabort and Arithignore on and off; I've tried creating a brand new package witha a new connection, and I still get the error. HOWEVER, there is nothing wrong with the actual script. I know this because when I copy and paste the script in Query Analyzer, it works fine. I only get the error when it runs in a DTS package.I hope one of you can help me with this.thanks... |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-07-18 : 11:13:38
|
| I get some strange errors back from DTS packages as well. Every so often I'll get back an error msg that says 'error: ' and thats it. If it works fine in a query analyzer, try making it into a stored procedure and then just telling dts to run the stored proc.-----------------------Take my advice, I dare ya |
 |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-07-18 : 11:16:31
|
| another possibility.. DTS sometimes defaults a few setting differently then query analyzer does.Consider putting set Arithabort onorset arithabort off-----------------------Take my advice, I dare ya |
|
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2002-07-18 : 11:28:07
|
| No luck still.... |
|
|
|
hmsubasi
Starting Member
1 Post |
Posted - 2004-08-18 : 13:46:03
|
Hi,You can try settingSET ARITHABORT ONSET ARITHIGNORE OFF |
|
|
|
iancuct
Yak Posting Veteran
73 Posts |
Posted - 2005-03-03 : 10:48:23
|
quote:
Originally posted by M.E.
another possibility.. DTS sometimes defaults a few setting differently then query analyzer does.Consider putting set Arithabort onorset arithabort off-----------------------Take my advice, I dare ya
|
|
|
|
iancuct
Yak Posting Veteran
73 Posts |
Posted - 2005-03-03 : 10:51:16
|
| I just wanted to let everyone know that this error sometimes occours because if you do a delete and the that you are trying to delete is referenced somewhereelse in your sp's or views with schemabinding than this error happens. All you have to do is delete the view that is created with shemabinding |
|
|
|
|
|
|
DTS Error.