Ms Access calls sql server DTS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Madhuri - 15 Jul 2005 21:16 GMT

How can I design a form in ms access which could call a DTS package in sql
server ? Also it should perform a certain procedure in msaccess.

Thanks
Madhuri

Reply to this Message

Joerg Ackermann - 15 Jul 2005 22:21 GMT

> How can I design a form in ms access which could call a DTS package
> in sql server ?

Try:

Sub DTSExecutePackage()
Dim dtsPackage As New DTS.Package
dtsPackage.LoadFromStorageFile "F:\ACCESS\DTSSAMPLE.dts", ""
dtsPackage.Execute
End Sub

A reference to "Microsoft DTSPackage Object Library" is nessesary.

Acki

Reply to this Message

Madhuri - 15 Jul 2005 23:26 GMT

The problem with MsAccess form coding is that it dosent show me any
components or references to add from. Any idea on where to add these
references ?

Madhuri

> > How can I design a form in ms access which could call a DTS package
> > in sql server ?
[quoted text clipped - 10 lines]
>
> Acki

Reply to this Message

Joerg Ackermann - 15 Jul 2005 23:45 GMT

> The problem with MsAccess form coding is that it dosent show me any
> components or references to add from. Any idea on where to add these
> references ?

In VBA-Ediitor - Tools - References

Acki

Reply to this Message