November 4, 2008 at 7:37 pm
Good evening, i need your help
I run in a DTS package which include a store procedure in
SQL Server, when called this SP and run an error is displayed:
%ls failed because the following, set options have oncorrect settings '%.*ls'.
Because this a complex job in the package which calld different SP, we have to runone by one with the proper parameters, but the question is ¿what does this error mean?, what is the cause? or what is the solution to get rid this awkard message?.
I will appreciate your help
November 5, 2008 at 1:44 pm
Does the stored procedure changes set options (like set ANSI_NULL ON)
Verify the server SET OPTION.
Certain commands fail it some specific "options" aren't set. (like index on calculated columns etc)
November 5, 2008 at 6:43 pm
Adding to the description on this error message, this package sometimes works fine but sometimes failed with this message.
Does it happen with the settings options define in the stored procedure?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply