sql server dts: Hello everyone, I have implemented a DTS Package (call it Package A) on a
SQL Server 2K/SP3 enviroment. I know that there is a COM that you can
reference in a VBA enviroment that you can use to execute/create a DTS
Package on a SQL Server. What I need is a sample code that shows how to? I
need an example the uses this COM model to execute a DTS "Transform Data
Task"
Thanks in advance for this

--
Jeff Bamba

Hi Jeff,
Easy way to see is to save you pkg as visual basic file (name.bas) from DTS
enterprise manager and open the file in vb.
JFB

[quoted text, click to view]

You wouldn't really use the object model or DTS for that matter to execute
parts of a DTS package, you would generally use it to execute a package as a
whole.
The object model is quite intuitive and you can look here for examples of
how to run a package.

Execution
http://www.sqldts.com/default.aspx?6,104,104,5,1

Remember DTS is client side so you will need the libraries on the PC you
press "Go" on

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



[quoted text, click to view]