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.
- Microsoft Dts Package Object Library
- Vb6 Missing Microsoft Dts Package Object Library Dll
- Private goPackageOld As New DTS.Package Private goPackage As DTS.Package2 When I create a package and run that setup on a different pc, my program does not work, it complains about it can't create ActiveX object, or something like that. As far as I can see the problem is DTS, and the package does not ship the proper DTS object with.
- Vbrun60sp6.exe is a self-extracting executable file that installs versions of the Microsoft Visual Basic run-time files required by all applications created with Visual Basic 6.0. The files include the fixes shipped with Service Pack 6 for Visual Basic 6.0.
All Forums
Development Tools
ASP.NET
VB.Net Running a DTS Package |
|
Microsoft Dts Package Object Library
Create a VB.exe project in Visual Basic 6.0. Reference into the new project 'Microsoft DTS Custom Tasks Object Library,' 'Microsoft DTSDataPump Scripting Object Library', and 'Microsoft DTSPackage Object Library.' Include dtsPackage.bas in the new project. Compile and run the project. This will give you confidence that the package will really.
| 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 Dll
Resources