Hello there

I have dts package that needs to create new excel file and import data from
query to it. the name of the new file is name of report and date/time stamp.
the name of the files is being saved in activeX and send into the
destination connection

How can i give order on dts package to create new excel file?

find this

http://sqljunkies.com/Article/A8CB0A...BFEDFCCD7.scuk

--soonyu

"Roy Goldhammer" wrote:

Hello soonyu,

This article will work, but it uatomates the Execl application, which is
unsupported, and prone to nasty little errors, causing it to hang when being
used unattended. It is just not aimed for that. Saying that I used it in
this way for several years despite the issues, so it may work for you too.

An alternative is to create a "template" file. At the start of the package,
copy the template to the name of your required export file. This ensures
the file is always valid, and clean, ready for you to export to.

Hello soonyu,

This article will work, but it automates the Execl application, which is
unsupported, and prone to nasty little errors, causing it to hang when being
used unattended. It is just not aimed for that. Saying that I used it in
this way for several years despite the issues, so it may work for you too.

An alternative is to create a "template" file. At the start of the package,
copy the template to the name of your required export file. This ensures
the file is always valid, and clean, ready for you to export to.