Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Email Sample Expand / Collapse
Author
Message
Posted Friday, August 21, 2009 1:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 11, 2012 4:15 AM
Points: 4, Visits: 27
Dear Forum

I am a little new to SSIS so please forgive my ignorance.

I have a small project where every month i need to email various recipients depending on values within the table.

I am OK with extracting the data I require but have no knowledge of SSIS.

Is there a member who could guide me or pass a sample SSIS package that mails the result set of a query dynamically based on email addresses returned by the query.

For example

each row of data would have columns with the persons email address and the subject and body.

Thank you all in advance


With Kind Regards

Paul Marks
Post #774814
Posted Friday, August 21, 2009 1:17 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 4:50 AM
Points: 1,949, Visits: 8,315
Hi Paul ,

IMO SSIS is a bit of a beast and has quite a steep learning curve.

You can email direct from sqlserver though , i would suggest taking that route unless you have a specific reason not to.

http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm




Clear Sky SQL
My Blog
Kent user group
Post #774817
Posted Friday, August 21, 2009 1:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 11, 2012 4:15 AM
Points: 4, Visits: 27
Thank you for your reply.

If i have a SP am i able to schedule the execution from SSIS?

As this would probably resolve my issue

With Kind Regards

Paul
Post #774818
Posted Friday, August 21, 2009 1:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 11, 2012 4:15 AM
Points: 4, Visits: 27
Thank you for your reply.

If i have a SP am i able to schedule the execution from SSIS?

As this would probably resolve my issue

With Kind Regards

Paul
Post #774819
Posted Friday, August 21, 2009 1:28 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 4:50 AM
Points: 1,949, Visits: 8,315
SqlAgent is responsible for executing and scheduling tasks, so again SSIS is not needed.







Clear Sky SQL
My Blog
Kent user group
Post #774821
Posted Friday, August 21, 2009 2:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 11, 2012 4:15 AM
Points: 4, Visits: 27
Thank you so much for your guidance. Greatly appreciated
Post #774839
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse