I have a nice DTS extract from SQL to Excel setup where I pull the data and
load into a spreadsheet. I then have a SendMailTask which mails the result
set in Excel to a maillist.

My Problem: Somehow, in setting schedules I get duplicates of the Excel
file attached in the e-mail. I've actually even had quadrupelets attached
and I am unsure what I am doing to multiply the number of attachments. I
only have one e-mail, but multiple attachments. My suspicion is it has to do
with the Scheduling and Versioning of the DTS Package.

Anyone have experience with this who can shed light? Specifically, I would
like to know how to remove the duplicates.

Thanks,
Leslie

I doubt it has much to do with the version of the DTS Package as you will
only ever be calling the one.
Scheduling shouldn't affect this.

To get multiple files into the eMail you would have to ask for them so maybe
something in your logic is a little off centre

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Leslie" <Leslie (AT) discussions (DOT) microsoft.com> wrote

Hi Alan,

When I check the log for the scheduled job, you can see specifically that
the MailTask. Since I did not "Code" this, rather I built the DTS package
using GUI, I cannot see anything which would "call" the file to be attached
twice. Do you have any ideas on where I would look to find the "duplicate"
attachment?

Here is the log file from the scheduled package run:

Executed as user: AERO\Administrator.
C:\Program Files\Common Files\SYSTEM\MSMAPI\1033>
C:
C:\Program Files\Common Files\SYSTEM\MSMAPI\1033>CD
\SQLData\MSSQL\JOBS\reports\
C:\SQLData\MSSQL\JOBS\reports>copy ShockBlockerReport.xls
ShockBlockerReportBAK.xls 1 file(s) copied.
C:\SQLData\MSSQL\JOBS\reports>copy ShockBlockerTemplate.xls
ShockBlockerReport.xls 1 file(s) copied.
C:\SQLData\MSSQL\JOBS\reports>cd \
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 12 Rows have been transformed
or copied.; PercentComplete = 0; ProgressCount = 12
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1

********* THIS IS THE STEP WITH THE PROBLEM ************
DTSRun OnStart: DTSStep_DTSSendMailTask_2
DTSRun OnFinish: DTSStep_DTSSendMailTask_2

DTSRun OnStart: DTSStep_DTSCreateProcessTask_1
DTSRun OnFinish: DTSStep_DTSCreateProcessTask_1
DTSRun: Package execution complete. Process Exit Code 0. The step
succeeded.

Thanks,
Leslie

"Allan Mitchell" wrote:

OK

So how is the package requesting the Excel File?
I presume there is only 1 file?

This is a long shot but it is the WorkBook you are seeing and not the
Worksheets?



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Leslie" <Leslie (AT) discussions (DOT) microsoft.com> wrote

Hi Alan,

I'm glad someone is out there this holiday weekend. When I open up the
SendMailTask, I have the following options:

Description
Profile Name & Password
To:
CC
Subject
Message
Attachments

In the ATTACHMENTS section, it looks like you can add items. AND, as I look
at that item, I see my problem now!!! There is only an "ADD" button -- so
when I changed the file name, I used the ADD button to select the new file
name... Now it is all so clear. The system simply concatenated the file
attachments, and since the file names scrolled off beyond the length of the
field, I couldn't see there were multiples attached!

Thank you for getting me to look further at this specific point. I love it
when I finally find these things and obviously your prompting further got me
to go exactly where I needed to go. I feel pretty silly now! But at least I
have the solution. Now I know that Add really means Add, not just update
which is how I was thinking it was working.

Cheers and happy holidays!
Leslie


"Allan Mitchell" wrote:

Don't feel silly

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Leslie" <Leslie (AT) discussions (DOT) microsoft.com> wrote