Executing SQL 2000 DTS packages from VB.NET 2.0

Executing SQL 2000 DTS packages from VB.NET 2.0

• Graham

  I couldn't find the DTS forum.

  The MSDN documentation includes a lot of good information about coordinating .NET 2.0 with SQL 2005, but there isn't very much about coordinating it with SQL 2000. As I'm stuck with an existing configuration, can you recommend some kind of reference resource that does address this

  Thanks,

  TD

  
  

• Chris_tr

  The trouble with the powerpoint presentation for me is that the code is C# and I'm stuck with programming in VB.

  If you can't run DTS packages from VB.NET, how are you supposed to import and export data from SQL Server 2000 databases

  
  

• mikex_dot_net

  Moving thread to DTS forum.
  
  
  

• FranciscoDaniel

  The current forum for this thread IS the "DTS" forum (Sql Server Integration Services, renamed for Sql Server 2005 release).
  
  The only decent reference I was able to find in a quick search was a TechEd PowerPoint deck here: http://download.microsoft.com/download/b/8/a/b8ad50e0-4bbc-4809-a0fe-0edee65716ae/dat320.ppt
  
  From the deck, it looks like you need to use interop to get at the package, but it does describe setting up the wrapper and executing a package. Hope this helps.
  
  
  

• adiash

  Thanks for your reply.

  I don't have SSIS available where I have to deploy the project. I must import and export data through SQL 2000 procedures and practices.

  Is there a recommended method to use, other than DTS

  
  

• Mital

  You should be able to substitute VB.Net code for the C# code from the PPT deck in a fairly straight-forward manner. First run the utility steps from slides 7 through 9 to generate the wrapper. You should be able to add the wrapper assembly to your VB project. The code on slide #14 then just invokes a package from the wrapper by:
  

  1. Creating a new instance of Package2Class()
  2. Calling the LoadFromSQLServer() method (assumes the package is already in the server, there appears to be also a LoadFromFile() method).
  3. Calling the Execute() method
  4. Calling the Uninitialize() method.
     

  I'm only somewhat familiar with VB, but I believe the call syntax is pretty similar. The methods available on the objects should match up to DTS's COM methods.
  
  "Interop" is short for "COM Interoperability", a layer that allows .Net code to invoke and interact with COM components like DTS. It makes COM objects look like .Net objects.
  
  
  

• nadertawil

  Thanks for your help. I'll review this.

  I'm not sure what you mean by "interop". Is that something I can search for in VB.NET help

  
  

• prashantm

  This seems like it might work. I appreciate all your help. I couldn't find any answers for this in TechNet or the MSDN forums, so you've really been a lifesaver.

  Tom

  
  

• Kegel

  tomatgdd wrote:

  If you can't run DTS packages from VB.NET, how are you supposed to import and export data from SQL Server 2000 databases

  SSIS can happily interact with SQL2000 databases, you don't need DTS.

  -Jamie

  
  
  
• Executing SQL 2000 DTS packages from VB.NET 2.0