Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-12 : 11:12:29
|
mark writes "We have several DTS packages at RAMS that call NT bat files, that then call isql and execute stored procedures. I am trying to find a way to get DTS to replace these with the appropriate ActiveX script. My problem is that I have created a SQL connection in the DTS package, which executes a stored procedure. I would then like to use this connection inside an ActiveX script and find out what the value of @@error is. I have created code that displays the information about the connection
eg
set oConn = oPackage.connections(aa)
if oConn.datasource = "SRVSQL2002" then
MsgBox oConn.datasource
MsgBox oConn.connected
' MsgBox oConn.catalog
' MsgBox oConn.description
' MsgBox oConn.ID
' MsgBox oConn.LastOwnerTaskName
MsgBox oConn.Name
MsgBox oconn.Reusable
end
but I can not figure out how I use the connection, with it's properties already set up, to execute a procedure. Once I can do this the I'll examine my next problem of determining the @@error returned." |
|
|
|
|
|
DTS/ADO/Stored procdures