<div>
Add a reference into your VBA program for the Microsoft DTS Custom Tasks Object and the Microsoft DTSPackage object library.<br />
<br />
You can then utilize all the properties and methods that are availabe to the DTS object model.<br />
<br />
Brett
</div>


Add a reference into your VBA program for the Microsoft DTS Custom Tasks Object and the Microsoft DTSPackage object library.

You can then utilize all the properties and methods that are availabe to the DTS object model.

Brett

<div>
Hello, Thanks for the answer. I have recently seen an example of what you are sugesting, but I can´t seem to make it work because I think I don´t have a certain library reference which I need, because he doesn´t recognize the objects DTS when I declare the variables.<br />
<br />
Dim objPackage &nbsp; &nbsp; &nbsp;As DTS.Package2<br />
Dim objStep &nbsp; &nbsp; &nbsp; &nbsp; As DTS.Step<br />
Dim objTask &nbsp; &nbsp; &nbsp; &nbsp; As DTS.Task<br />
Dim objExecPkg &nbsp; &nbsp; &nbsp;As DTS.ExecutePackageTask<br />
<br />
<br />
These are all the objects he doesn´t recognize. Do tou perhaps know which is the library I´m missing????<br />
<br />
Once again thanks for the help<br />
<br />

</div>


Hello, Thanks for the answer. I have recently seen an example of what you are sugesting, but I can´t seem to make it work because I think I don´t have a certain library reference which I need, because he doesn´t recognize the objects DTS when I declare the variables.

Dim objPackage      As DTS.Package2
Dim objStep         As DTS.Step
Dim objTask         As DTS.Task
Dim objExecPkg      As DTS.ExecutePackageTask


These are all the objects he doesn´t recognize. Do tou perhaps know which is the library I´m missing????

Once again thanks for the help



<div>
<br />
Sorry didn´t get it the first time around. It works like a charm, thanks....
</div>



Sorry didn´t get it the first time around. It works like a charm, thanks....

<div>
Great!<br />
<br />
have fun<br />
Brett
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I´m trying to find a way to execute a DTS Package using VBA in Excel. 
</div>
</div>


Hello,

I´m trying to find a way to execute a DTS Package using VBA in Excel. 

Execute SQL Packages

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.