SSIS Email Sample

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS Email Sample

SSIS Email Sample

Rate Topic

Display Mode

Topic Options

Author

Message

paul.marks

Posted Friday, August 21, 2009 1:04 AM

Forum 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

Dave Ballantyne

Posted Friday, August 21, 2009 1:17 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 10, 2013 4:07 PM
Points: 1,943, Visits: 8,227

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

paul.marks

Posted Friday, August 21, 2009 1:19 AM

Forum 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

paul.marks

Posted Friday, August 21, 2009 1:21 AM

Forum 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

Dave Ballantyne

Posted Friday, August 21, 2009 1:28 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 10, 2013 4:07 PM
Points: 1,943, Visits: 8,227

SqlAgent is responsible for executing and scheduling tasks, so again SSIS is not needed.

Clear Sky SQL
My Blog
Kent user group

Post #774821

paul.marks

Posted Friday, August 21, 2009 2:05 AM

Forum 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 »

Permissions