Return to site

Vb6 Missing Microsoft Dts Package Object Library

broken image


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.

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. Now I have created a DTS Package (ActiveX Task) which will create object of the DLL and call a particular function. The problem is when I execute the DTS task from my ID, everything is fine. But, whenever a Generic ID is used to initialte the task the task either fails saying 'Can not create Object - Permission Denied' or the dialog box appears. 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. 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.

Total war: warhammer ii - the queen & the crone for macular degeneration. The Queen & the Crone is the first Lords Pack for Total War: WARHAMMER II. Bolstering the forces of the High Elves and the Dark Elves, it introduces famous rival characters and new iconic units from the world of Warhammer Fantasy Battles to your campaigns and battles.

All Forums
Development Tools
ASP.NET
VB.Net Running a DTS Package

Vb6 Missing Microsoft Dts Package Object Library File


Vb6 missing microsoft dts package object library download
Author Topic
smithygreg
Starting Member

37 Posts Sensus unipro software.

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 Surrey crypt dos2.

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 Object Library Not Registered

Package

Vb6 Missing Microsoft Dts Package Object Library Free

Vb6 missing microsoft dts package object library free
Author Topic
smithygreg
Starting Member

37 Posts Sensus unipro software.

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 Surrey crypt dos2.

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 Object Library Not Registered

Vb6 Missing Microsoft Dts Package Object Library Free

Vb6 Missing Microsoft Dts Package Object Library Free

Resources





broken image