SQL Server Performance Forum – Threads Archive
problem with dts launched using a stored procedure
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
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.
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
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.
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
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.
]]>