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 |
|
Rafferty Uy
Starting Member
23 Posts |
 Posted - 2004-09-22 : 22:10:12
|
Hello,How do you get and set the FileName property of an ExecutePackageTask object? I tried doing something like this:Dim objConn1Set objConn1 = DTSGlobalVariables("<ExecutePackageTask_ObjectName>")objConn1.FileName = "C:\SomePackage.dts"but obviously it doesn't work (or else I wouldn't be posting this question hehe)  Thanks so much!-Rafferty |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-22 : 22:48:54
|
| have a look at http://www.nigelrivett.net/ScriptDTSProperties.htmlwhich has most task properties - but seem to have missed that task.It's probably a custom task property.I always do it in VB6 to find the properties.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Rafferty Uy
Starting Member
23 Posts |
Posted - 2004-09-22 : 23:00:37
|
| looks like its not in the link...any more ideas? :)-Rafferty |
|
|
|
Rafferty Uy
Starting Member
23 Posts |
Posted - 2004-09-23 : 03:09:10
|
| I'm still stuck :-sWhat I'm trying to do is to make the path of the ExecutePackageTask configurable. I will be passing the path from C#, adding it to the GlobalVariables and then let the ActiveX Script Task get the correct path and set the correct path onto the ExecutePackageTask objects :) Well, so far it seems like what I'm trying to do can't be done... so does anyone know of other methods in doing this? :)-Rafferty |
|
|
|
|
|
|
How do I access the ExecutePackageTask object