Hi<br /><br />Is there a straightforward way to make an HTTP post from SQL Server itself, without calling the code to do so from a DTS object?<br...
Is it possible to get an Active X script in DTS to use a version of JVM other than the Microsoft JVM? Cheers Tom
Thanks. The issue was that the new machine does not have the Microsoft JVM on it (though it did have another JVM) and DTS seems to use this as a...
Hi I have a SQL Server 2000 DTS package that instantiates a JAVA object and completes a HTTP post. This package works fine when I run on Windows XP...
Hi In package properties for DTS I have checked 'Just in Time Debugging'. However when I execute a DTS package from DTS Designer Just In Time...
Yes I understand how to access global variables. How do I populate them or pass parameters between objects?
I have worked out how to see the logs (from properties of the package go to debug tab). But in the log I am just getting an unspecified run time...
Note I specify the string parms immediately after the package name.
Thanks. I can now execute the package (from a OS command prompt) but the execution returns a runtime error. I do not seem to get any information in...
Hi Having looked at the MS site I am confused by the syntax I should be using for DTSRun in SQL Server 2000. The MS site says the syntax is ......
Thanks. I have solved my problem. The issue (as you alluded to) was that the java class path was not correct (the directory structure was not as...
Thanks Adriaan. I've reworked what I was doing so I can use the underlying table.
Ok I found out that what I wish to do I can refer to the nText value in the table originally inserted into.
I am calling a JAVA class ... I get past the error above but now get an unknown runtime when the GetObject is executed. JScript is function...
Hi I am getting the following runtime error when I try to instantiate a JAVA class with GetObject in JScript inside a DTS step. "Automation server...
Hi I wish to conduct a http post of an xml document in T-SQL (SQL Server 2000). I have not found any reference on how to do this in T-SQL itself...
Thanks. I guess I'll start looking at the Instead Of trigger. Sadly have to use SQL Server 2000 in this instance ...
Hi I wish to copy the data in one table to another upon execution of an after trigger. One of the fields I wish to insert is of datatype nTEXT and...
Separate names with a comma.
