- Vb6 Object Library Not Registered
- Vb6 Missing Microsoft Dts Package Object Library Free
- Vb6 Missing Microsoft Dts Package Object Library Access
Vb6 Object Library Not Registered
All tasks in the package are reviewed for appropriate settings during validation, and all objects in the package are reviewed, including the package, containers, and other components in the package. If there are no problems encountered in the validation phase that would cause the package to fail, the package object proceeds to call the Execute. Importing a 'Save As Visual Basic' DTS Package into Visual Studio.Net. Using the Upgrade Wizard. Save the package as VB from the DTS Designer. Create a new VB6 Standard EXE project. Add a Reference to the Microsoft DTSPackage library. Remove the default Form1 from the project. Select Project Add Module and add the saved.BAS module to project.
Vb6 Missing Microsoft Dts Package Object Library Free
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.
All Forums
Development Tools
ASP.NET
VB.Net Running a DTS Package |
|
| 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 Example
Public goPackageOld As New DTS.Package
Public goPackage As DTS.Package2
Would 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 | | Posted - 2004-11-16 : 12:50:37 | You really figured it out? I have been trying forever. Want to help me out a little bit? This is what I have posted, just to give you an idea of what I am doing.
http://www.vbforums.com/showthread.php?s=&threadid=308100&perpage=40&pagenumber=1
Thanks for any help!
Brenda
If it weren't for you guys, where would I be?
|
| 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.PackageClass
opkg = New DTS.PackageClass()
'This call will load the dts package from the sql server
opkg.LoadFromSQLServer(Add paramter variables as needed)
Al Franzini |
|
|
|
Subscribe to SQLTeam.com
Vb6 Missing Microsoft Dts Package Object Library Access
Resources