New to DTS... Simple question!

[dBjason]

SQL Server 8

Hello,

I'm a little new to DTS packages. I'm trying to make a small change to an existing package, hopefully someone can help.

The existing package is fairly simple: There's a server (Labeled SQL1) connected to an Excel Spreadsheet. Currently when executed, the package overwrites an existing Excel file on the network.

What needs to be changed is the way it writes. Instead of writing over/to an existing spreadsheet file, I need it to create a new directory (ie: //server/path/2006reports/) and create a new spreadsheet.

Is there any way to do this?

Thanks in advance,
Jason

 

[philhege]

DTS won't create new folders. Plus the Excel connection must refer to an existing spreadsheet.

I think you'll need to script some of this outside of DTS.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Eschewing obfuscation diurnally.

 

[MDXer]

Actually you can use Active X tasks to create new folders and files then use Dynamc Properties to specify the new path and file name. It is doable but not simple.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck