Linking VB 6.0 to DTS
Richard Waymire answers a reader’s question about passing parameters between VB 6.0 and DTS.
August 21, 2001
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.
About the Author
You May Also Like