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
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Error in delete records from SQL table in SSIS

Author  Topic 

yosiilan
Starting Member

1 Post

Posted - 2009-10-12 : 03:52:00

when I try to delete recorrds from sql table in a "execute SQL TASK" I get the error:
"
Execute SQL Task] Error: Executing the query
"exec APPEND_TEMP_TO_HOZAOT_MUFRATOT" failed with the following error:
\ "DELETE failed because the following SET options have incorrect settings:
'ARITHABORT'.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly,
parameters not set correctly, or connection not established correctly.
although this delete works in sql manahement studio

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-10-15 : 06:16:57
This maybe due to different SET OPTIONS in the two connections.

Is the same user account used in both connections?

You can run DBCC USEROPTIONS in SSMS to see the setting for 'ARITHABORT' in that connection.
And use SQL Profiler to see the connection setting for the connection from SSIS.
See this for more information:
http://sqlblogcasts.com/blogs/martinbell/archive/2009/06/15/Other-ways-to-see-User-Options.aspx

Go to Top of Page
   

- Advertisement -