DTS Error

  • Hola, tengo este error, hay alguien que pueda ayudarme ?

    Hi, I have this mistake, there is somebody that can help me ?

    DTSRun OnError:  DTSStep_DTSDynamicPropertiesTask_1, Error = -2147220492 (800403F4)

        Error string:  Could not open file for reading.

        Error source:  Dynamic Properties Task

     Error Detail Records:

     Error:  0 (0); Provider Error:  0 (0)

        Error string:  Could not open file for reading.

        Error source:  Dynamic Properties Task

     Error:  -2147220440 (80040428); Provider Error:  0 (0)

        Error string:  Package failed because Step 'DTSStep_DTSDynamicPropertiesTask_1' failed.

        Error source:  Microsoft Data Transformation Services (DTS) Package

    Se los agradesco...

    Thanks, regards

  • The file that you are trying to read, either does not exist, or it is open by another user, and cannot be read.

    Make certain that the file is in the path that you have set, and that the file is not already opened for reading.

    Andrew SQLDBA

  • Thanks, Andrew

    Let me see, if this ´cause the mistake.

    Best Regards,

  • If the file exsists then check for the permissions for the users trying to use the DTS package.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  •  

    Yeap,

    Thanks so much Cheers...

    By the way I like your phrase 

     

     

     

     

  • That phrase is my favourite in this Industry i add to my signatures everywhere.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 6 posts - 1 through 5 (of 5 total)

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