Post reply

Having Problem in Running DTS from Query analyzer

  • April 3, 2003 at 12:38 pm

    #80583

    My Requirement :

    --Transffer data from XL to SQL.

    -- Want to change connection of xl file dynamically with different name

    Trying :

    -- I have created one xl conn, one sql connection in DTS.

    -- Created one global variable "Source File" as string data type

    -- Gave some file path value to global variable

    -- Now i changed Data source of Xl to global variable

    -- So the sequence is first dynamic property task will run and then data transfer between file and sql.

    -- Now if i run this dts from another dts passing different value of file name using inner package global variable then it runs fine.

    Perfect. But still this is a manual operation to change file name in Inner package variable.

    -- so i was trying to run DTS from query analzer using xp_cmdshell and want to pass global variable....

    but getting error.

    i am running

    ---exec xp_cmdshell "DTSRun /S UWSTAGE /U test /P test897 /N test_U_list /A SourceFile: 8 = C:\test\5240-Silvercrest Extended Care Facility-.xls"

    its giving me this kind of error sequence ''''''''''''''

    ==========================================

    DTSRun: Loading...

    DTSRun: Executing...

    DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1

    DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1

    DTSRun OnStart: DTSStep_DTSDataPumpTask_1

    DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)

    Error string: Failure creating file.

    Error source: Microsoft JET Database Engine

    Help file:

    Help context: 5003436

    Error Detail Records:

    Error: -2147467259 (80004005); Provider Error: -329978796 (EC54EC54)

    Error string: Failure creating file.

    Error source: Microsoft JET Database Engine

    Help file:

    Help context: 5003436

    ===========================================

    Thanks in Advance.

    Brijesh Shah

    rgds,

    Brijesh Shah

    Database Specialist

    @IS-SEIU1199

    @212-603-1759

  • April 4, 2003 at 12:14 am

    #453134

    When you run DTS via xp_cmdshell it will run on the sql server, rather than your pc

    Does you .xls file exist in the c:\test directory on your sql server?

    Steven

  • October 21, 2003 at 6:51 am

    #478932

    Has there ever been a resolution to this? I am getting the same errors when trying to populate an Excel file through a DTS package. It worked fine for almost a year until about 4 weeks ago. I don't know what could have changed to start causing the error.

  • October 21, 2003 at 5:14 pm

    #479017

    Are you getting the same errors?

    Whenever you see '80004005' in the message it's something to do with security. This number is basically the catch-all access denied error.

    Has something changed recently that altered privelages? New security patch, over-enthusiastic Network admin, etc...

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

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

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