sql server dts: Setting And running DTS using code -- sql server dts

Re: Setting And running DTS using code

Allan Mitchell
8/28/2003 7:10:35 AM

sql server dts:

Here is how to get started in DTS. You can substitute the text file for an
XL connection

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

Here is how to execute using a stored proc

Execute a package from T-SQL
(http://www.sqldts.com/default.aspx?210)

--

----------------------------
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]

Setting And running DTS using code

Roy Goldhammer
8/28/2003 8:29:42 AM

Hello there

I have some table that i need to create excel file that provide me the data
inside of the table.

How can i create DTS package and how can i run it using Store Procedure?

any help would be useful