To execute a package from Visual Basic is a relatively simple task using the DTS object model. Before you start using the object model you must add a the appropriate reference to your project. From the Project menu select References and check the 'Microsoft DTSPackage Object Library'. Gets or sets the X.509 certificate object for the package. CertificateObject: Gets or sets the X.509 certificate object for the package. CheckpointFileName: Gets or sets the name of the file that captures the checkpoint information, which enables a package to restart. CheckpointUsage: Gets or sets a value that specifies if or when a package is.
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 |
|
Vb6 Missing Microsoft Dts Package Object Library Free
| 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 |
|
|
|
Vb6 Missing Microsoft Dts Package Object Library Download
Subscribe to SQLTeam.com
Vb6 Missing Microsoft Dts Package Object Library Dll
Resources