Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smithygreg
Starting Member
37 Posts |
 Posted - 2004-10-29 : 14:17:01
|
| Hi everyone...I am new to both SQL Server AND VB.net...Here's my problem.I created a DTS package basically to just import a CSV file into a table in my database. I want to be able to run this package from my VB.net front end on a client machine. I used some of the sample code that comes with SQL Server and I kept getting errors saying the different DTS Types that I was trying to Declare were not defined.For ExamplePublic goPackageOld As New DTS.PackagePublic goPackage As DTS.Package2Would give me "Type DTS.Package is not defined"and "Type DTS.Package2 is not defined"Well, like I said, I am new at this..I have experience with VBA and VB6, but I am a bit lost here. Are there references I need to load or some include statements missing?Any help on this problem would be appreciated...Also, Does anyone know of a good resource for information? I mean, besides these forums.THANKS!!!Greg |
|
|
smithygreg
Starting Member
37 Posts |
Posted - 2004-10-29 : 19:51:03
|
| Well, I figured it out...Thanks anyway...I am still interested in any beginner material, books you could recommend |
 |
|
|
brendalisalowe
Constraint Violating Yak Guru
269 Posts |
|
|
AlDragon
Starting Member
12 Posts |
Posted - 2004-12-06 : 23:35:35
|
| Add reference Microsoft DTSPackage Object Library under the COM tab.This can also be done in VB6 This will get you started:Dim opkg As DTS.PackageClassopkg = New DTS.PackageClass()'This call will load the dts package from the sql serveropkg.LoadFromSQLServer(Add paramter variables as needed)Al Franzini |
|
|
|
|
|
|
VB.Net Running a DTS Package