Well I've done it now.

I've gone and used activeX to create a SQLCopyObjects task, because I
wanted to have full dynamic control over the properties of that task
including objects to be copied, flags, etc.

That part worked GREAT, the tasks and steps are visible in disconnected
edit, and they appear there right after the active x step gets run.

They are not visible however, and so now I am trying to figure out; once
they are created, how do I run them, and then get the package back on
track?

Right now I create one copy objects task then I hope to execute it then
move on to another activeX step which creates the next copy objects step
and then runs it.

Here is the execution order I am hoping to achieve.

ActiveX step creates the first SqlCopyObjects Task and Step and sets
that step to run once the current activex step reports success.

SqlCopyObjects step runs.

Second ActiveX step runs and creates the second SqlCopyObjects step,
sets it to run after the current step runs successfully

Second SQLCopyObject step runs

Finally, a cleanup step runs that destroys the steps and tasks, and of
course any precedence that has been established.

Any ideas on this?





Warm Regards,

Edward R. Hunter
Developer, Dba
comScore Networks, Chicago IL (USA)
http://comscore.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Warm,

It seems you want to use Microsoft ActiveX scripts to customize the
execution of steps in a Data Transformation Services (DTS) package. Please
check the suggestions in the following article.

Using ActiveX Scripts in a DTS Workflow
http://msdn.microsoft.com/library/de...us/dtssql/dts_
elemwkflow_0793.asp

I also found the following articles for your reference.
VBScript Interfaces in SQL Server 2000 Let You Transform Data and Provide
Reports to Your Users
http://msdn.microsoft.com/msdnmag/is...erver2000/defa
ult.aspx

Using ActiveX Scripts in DTS
http://msdn.microsoft.com/library/de...us/dtssql/dts_
addf_ax_06er.asp

I am looking forward to hearing from you soon.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.