DataPump DestinationObjectName - Change value via ActiveX

[davida37]

Hi,

SQL Server 2000... New to ActiveX (vbscript) and DTS.

I am trying to change the values of some of the DataPump properties via ActiveX (vbscript).

I have managed this for connections:
'Now set the new values
con.Catalog = strToDataMartdb
con.DataSource = strToDataMartServer

BUT I cannot do the same for DataPump properties. Esp, DestinationObjectName and SourceSQLStatement.

I have tried the following:
Tsk.DestinationObjectName = strToTempTableName
and/or
Tsk.DestinationObjectName.value = strToTempTableName

Neither work. How do I reference these. Please Help.

Thankyou.

 

[AlexCuse]

What is in your strToTempTableName? And how are you instantiating Tsk?

I think it needs to be fully qualified if the owner is not dbo (MyDatabase.Owner.MyTable)

Also, you do not need to use the .value in setting the name.

I think the problem is probably elsewhere in your code though. Have a look at this, and post back with ny questions.

http://www.sqldts.com/213.aspx

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[davida37]

I just found that page! Thanks! Its v. helpful

 

[AlexCuse]

That is a great site for DTS. You will more often than not find a great example of whatever you need to do right there



Ignorance of certain subjects is a great part of wisdom