Wednesday, March 7, 2012

Call DTS package from VBA/Excel?

Can you call a DTS package using VBA (specifically from Excel). I would like
to have a command button to launch a DTS package that extracts data from the
spreadsheet to SQL Server. Today I have to open up Enterprise Manager to do
this.

Any code examples would be great too if this is possible.

Thanks,
ChadLook up "Executing DTS Packages in Visual Basic" in Books online or on
the Microsoft website.

-Tom.

No comments:

Post a Comment