sql server dts: Hi!
I've recently migrated my db to Sql Server 2005. With Sql Server 2000
I

could easily execute my DTS packages from an Excel's macro exploiting
the following VBA code:

Dim dtsp As New DTS.Package

dtsp.LoadFromSQLServer _
ServerName:="Server_Name", _
ServerUserName:="sa", _
ServerPassword:="", _
PackageName:="Package_Name"

dtsp.Execute

How can I run an SSIS from an Excel's macro?

Thanks in advance.

Max

Hello MaxBel,


You are going to need to install SSIS wherever you are running the Package
from. You can then call the SSIS equivalent of the object model.

Have a look here

http://blogs.msdn.com/michen/rss_tag_ssis.xml



--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]