Need Help for DTS Error...

  • While i am executing the DTS Package I am getting the below error -

    Message

    Executed as user: DYW062D001\user_bs. ...ing...

    DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1

    DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1

    DTSRun OnStart: DTSStep_DTSActiveScriptTask_2 DTSRun OnError: DTSStep_DTSActiveScriptTask_2, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= Crystal Reports ActiveX Designer Error Description: Invalid directory. Error on Line 184 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error Detail Records: Error: -2147220482 (800403FE); Provider Error: 0 (0) Error string: Error Code: 0 Error Source= Crystal Reports ActiveX Designer Error Description: Invalid directory. Error on Line 184 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp . The step failed.

    Can someone please help me as soon as possible.

    Thanks!!

  • Have a look at your DTSStep_DTSActiveScriptTask_2 step, line 184

    DTSStep_DTSActiveScriptTask_2, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= Crystal Reports ActiveX Designer Error Description: Invalid directory. Error on Line 184

    Looks like you're defining a directory that doesn't exist on line 184.



    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • Hi I got the answer- By mistake some of my team member has deleted the directory from the path. 😀 Now I have placed that directory back and it now working fine:hehe:

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

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