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.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.