August 4, 2009 at 11:13 am
Dear Experts,
I am trying to create a package that does the following.
WHAT I WANT
-Get some data sent to an excel file
-Send a mail (SMTP) after the data transfers from the ole db source to the excel file.
-I want this mail to include the data from the excel file that just transferred.
-I want to see this mail everyday with the excel file (report).
WHAT I HAVE SO FAR
-Created the data flow task to send data from ole db to excel (fine)
-Attached a send mail task to the data flow to send me the excel file after the data transfer.
-For the daily mail, I intend to schedule the package (not a problem at all).
PROBLEMS
-It sends the mail but I don't see the excel file. It just shows me this weird thing "PK ".
-Even after it sends that gibberish email, trying to run the package again leads to a "newmetadataneeded" error
QUESTIONS
-Is there something I am doing wrong?
-I am also opened to a better or more effective way to approach this. Thanks in advance !
August 4, 2009 at 11:28 am
How are you sending the e-mail? Are you using DBMail (calling T-SQL) or using the SSIS SendMail task?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2009 at 11:48 am
USING THE SEND MAIL TASK IN SSIS
August 5, 2009 at 7:20 am
I wonder if it's a problem with SSIS holding a lock on the file. Have you tried making the e-mail into a second step in the job, instead of being in the same package? That shouldn't be necessary, but might be worth a try.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply