A very basic question ( I think....)

I am new to DTS. I want to create a simple .xls(excel) file with a specific
name using my DTS package

How can I do it?

Thanks.

Hi JK,
Use activex script task for this.
Here is a great example for txt file but should the same for xls file.
http://www.sqldts.com/default.aspx?6,101,200,0,0
JFB

"JK" <jeetrana (AT) hotmail (DOT) com> wrote

Not quite true.

Try creating a Datapump task between a SQL Server and an Excel Spreadsheet. OK ? test,Works ? Good. Now go to disconnected edit and manually change the filename of the excel file. DTS will choke with an unrecognised destination object name.

You need to make sure you create the destination object on the XL Spreadsheet i.e.

CREATE TABLE `authors2` (
`au_id` VarChar (11) ,
`au_lname` VarChar (40) ,
`au_fname` VarChar (20) ,
`phone` VarChar (12) ,
`address` VarChar (40) ,
`city` VarChar (20) ,
`state` VarChar (2) ,
`zip` VarChar (5) ,
`contract` Bit )

I put this in an ExecuteSQL Task before the datapump task.


--

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