Linking VB 6.0 to DTS

Richard Waymire answers a reader’s question about passing parameters between VB 6.0 and DTS.

Richard Waymire

August 21, 2001

1 Min Read
ITPro Today logo in a gray background | ITPro Today

I'm running SQL Server 7.0 Service Pack 3 (SP3). I developed an interface between Visual Basic (VB) 6.0 and Data Transformation Services (DTS) by using SQLNamespace, and I need to pass parameters between VB 6.0 and DTS. I know that DTS doesn't support this process, but I improvised by using the Package2 DTS object with the methods LoadFromSQLServer and SaveToSQLServer. How can I pass the parameter pVarPersistStgOfHost, which prevents the alignment of objects in DTS?

Microsoft has reserved the pVarPersistStgOfHost parameter for its own use in current versions of DTS, so you can't retain the package layout when you use DTS through the object model.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like