Post reply

ERROR : OleDBProperty ''Multiple Storage Objects'' already exists

  • November 13, 2006 at 10:52 pm

    #69150

    Hi,

    I have scheduled number of jobs in SQL Agent to execute SLQ Packages.

    One of the packages failed with following error:

    Step Error Source: Microsoft Data Transformation Services (DTS) Package

    Step Error DescriptionleDBProperty 'Multiple Storage Objects' already exists in the collection.

    Step Error code: 800403EC

    Step Error Help File:sqldts80.hlp

    Step Error Help Context ID:399

    I am not able to figure what is going wrong?

    Any help in figuring out the problem will be of great help.

    Thanks in advance.

    Prashant

     

  • November 21, 2006 at 4:13 am

    #673149

    Hi All,

    I think I have figured out what was going wrong. Actually I was getting this "CRAZY" error messages when my DynamicPropertiesTask was trying to set some properties for OLEDB Connection which was being used at that time. Hence there was the conflict.

    Solution: I introduced a precedence constraint to make sure that the connection is used only after DynamicPropertiesTask completes successfully.It worked.

    Thanks

    Prashant

     

     

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply