SQL Server Performance

problem with dts launched using a stored procedure

Discussion in 'SQL Server DTS-Related Questions' started by nomercy, May 23, 2007.

  1. nomercy New Member

    Hi everybody!
    i hope you can help me.
    I've written a big set of DTS package. those packages must be launched every day using a stored procedure. using a plan table so i can store the global variables to be used for each day and pass to the procedure.
    when i did it i've tested in my office and everything goes weel. Now i'm trying to use it on customer server and things are going worst....
    all the packages works well, but when i launch the procedure (in which are used extended procedures) happens that a vbscript that is part of a package, is stopped at half of the processing.
    after this all the other steps are executed as the vbscript was fail....
    here i use sql2000 sp4 as in my office. the only difference is that here was installed sqlserver and sp4, while in my office was installed sql server and sp3 and 4 after.
    any ideas?
    thank you all in advance
    Luciano
  2. satya Moderator

    First thing to do is to enable the DTS package logging in order to see where exactly it is failing.
    Also ensure if you are using vbscript then relevant .dlls exists on client side too including the privileges for the SQLAgent account.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. nomercy New Member

    Hi Satya,
    i've checked where the vbscript fails. is when is to be created an xls file system object. the strange think is that all the sequent modules are executed....
    where i can enable dts logging?
    thanks
  4. satya Moderator

    Open up that package and go to properties, it is there under logging tab.
    Is there any change on the office components you use as compared to the client's end.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  5. nomercy New Member

    hi satya, thanks again...
    i've setted the logging on an tomorrow i'll try again...
    i've restarted also the server and it gives me an error on excel. do you think that could be a possible reason for the fail i've registered?
    Luciano
  6. satya Moderator

    What is the error on Excel in this case?
    if you are using the Office automation within the DTS package then ensure to have relevant office components on the server & client that matches.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page