asked on

Solution to Execute DTS Packages and Connect to SQL Server with Vb.net

I am trying to create a solution, that allows a user to select a file and have that file imported into sql server, i believe that i can do this with a .net and dts solution, creating my dts packages, and allowing the user to choose where the files are, ftp them from a server, and put them in a pre determined destination so that a dts package can execute the data pump, i need to assume that all the text files are the same every time we run the conversion, and i can run the dts with the same structure. i am new to .net, i have done something similar using vb6, but it's been a whlie, and .net is very new to me. so i need to know how to connect to a database, using ado.net ? i presume, and how to execute the dts pacages, and how to allow the user to select where the files are. i just need a kick in the right direction so that i can get started, i'm sure that i will tweak it once this get up and running. thanks

ASKER CERTIFIED SOLUTION

etmendz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

etmendz

For the other stuffs you need, those are basic I/O operations and you can simply search msdn.microsoft.com for ".Net System.IO" for more information. The classes that may also interest are the OpenFileDialog and the FileSystemWatcher classes. Read about them and about ADO.Net in your Visual Studio.Net documentation, MSDN Library or the MSDN Library online in msdn.microsoft.com.

Samples are available in www.gotdotnet.com where you can view samples organized per class/classes that may interest you.

There is no built-in FTP client in .Net so you might need to download one from the Internet or purchase one from any .Net library vendor you like.

If you've worked with VB6 forms and controls, learning VB.Net forms and controls is a breeze. If you've worked with VB6 .cls class files (which is almost OOP), the transition to VB.Net shouldn't be difficult. If you're familiar with the VB6 IDE, mastering the Visual Studio.Net IDE should be easy.

Have fun.

Auerelio Vasquez

ASKER

here is a twist to this question. how can i create and run a dts package within vb ? are there any good examples for this out there ?

etmendz

That is called dynamic DTS which I also tried to explain in my first post.

I think that there are not much samples. You can create a DTS package using the Enterprise Manager and then save the DTS package to VB6 (which is an existing feature of DTS in SQL Server 2000).

The VB6 code generated works and may be compiled and tested immediately.

You can use the VB6 code generated as basis if you want to rewrite it to VB.Net.

Have fun.