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 |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2005-09-07 : 13:19:39
|
| I have a DTS package that utilize multiple dynamic properties (server/dbname)I have a script task inside the package that needs to execute a sproc, get a value and do a success/fail so the workflow can be run properly.Using a sql task is a pain with multiple input/output parms so I figured an activex script would be simpler if changes needed to be made.Since I have dynamic properties for my server connections, can I utilize them in the package versus doing the normal way of creating a new connection, string, etc and having it stored in the active X script?sql = " spGetID " Set pkg = DTSGlobalVariables.Parent Set conn = pkg.Connections("Dev Server")So how do I say conn.Execute(sql)Haven't been able to find any data on the "pkg" properties.any pointers?________________________________________________Working man's privilege, beer is.Harsh, Life is. |
|
|
|
|
|
utilize package connection inside activex