Re: Scheduling Problem - Duplicate Attachments

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 19:22:02 -0000

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@discussions.microsoft.com> wrote in message 
news:DE2DDDD7-7B56-4EC4-A916-96D4DD5525E3@microsoft.com...
> 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:
>
>> 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@discussions.microsoft.com> wrote in message
>> news:E0066C02-B658-43C7-A9D2-0674BC057046@microsoft.com...
>> >I have a nice DTS extract from SQL to Excel setup where I pull the data 
>> >and
>> > load into a spread***.  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
>>
>>
>>
Loading