SSIS Package

Question

SSIS Package

arun4.g

SSC Enthusiast

Points: 193
More actions
December 11, 2008 at 9:49 am

#216399

Hi All,
I am creating a package which takes the data from the database and transfer it to the excel sheet. Now, I want to send the excell sheet to different people on different days. As an example: Say I have a excel file created by SSIS package, now I want to send it to:
X and Y on Thursday
Z and A on Friday.
where X,Y,Z and A are different People.
Please let me know how could I set different tasks for sending mails based on what day it is?
Thanks everyone....:)

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

cavo789 Mr or Mrs. 500 Points: 503 More actions · Answer 1

Why not a table in your database with the dayname and the email address of your recipient ? And then read this table in your SSIS package, put recipients into a memory variable and then use it in the Send mail task ?

Is it not possible ?

Christophe

arun4.g SSC Enthusiast Points: 193 More actions · Answer 2

I cannot add table since database is in the production environment.

cavo789 Mr or Mrs. 500 Points: 503 More actions · Answer 3

Is this a good reason ? Why not asking for adding a table ?

I think that this solution will be the best one and the more flexible (just adding a record will means adding a new recipient).

Perhaps somebody will have an another idea...

Christophe

arun4.g SSC Enthusiast Points: 193 More actions · Answer 4

Thanks. I really appreciate your solution. I am new to SSIS. suppose, if I add a table with Dayname and Recepients, how could I fetch them and put them in the global variable in SSIS.

cavo789 Mr or Mrs. 500 Points: 503 More actions · Answer 5

With a SQL task you can fired a SQL directly on your table. Then, store the value in variables.

I don"t doubt that you'll find tutorials on Google for this.

Christophe

Bob Griffin SSCertifiable Points: 5982 More actions · Answer 6

This doesn't answer your specific question, but this functionality is available in SQL Server Reporting Services. After creating the report based on the SQL code you already have, SSRS can schedule deployment of the exported excel version of your report at any time you want to whomever you want via email....

arun4.g SSC Enthusiast Points: 193 More actions · Answer 7

thanks. I am new to SSIs , could you please explain it.

also,can anyone let me know how to execute this SSIs package thru vB 6 or VB.net

Thanks