How to send record(which is a weblink) from a table to the value of the variable in SSIS package and send that weblink through an email? | ansaurus

tags:

sql
ssis

views:

13

answers:

1

Q:

How to send record(which is a weblink) from a table to the value of the variable in SSIS package and send that weblink through an email?

Hi Folks,

I have table called Table1 with columns, col1 and col2 with col1 having weblinks for the report and col2 the name of the report. Now, i have a package with a variables var1 and var2 which should get the col1 and col2 values respectively from table1 and send it through an email. if the weblink gets updated in the table, package should send the updated link. i know the reverse way of it but trying to do somethig like this.

Appreciate any help from you guys.

Thanks

A:

bobs 2010-09-01 18:50:59

Thank you very much. thats how an answer should be. thanks. just one question how do i see the value of the variable, i dont see it in variables window?

CombatCaptain 2010-09-01 19:15:25

You can view the variable values at runtime by setting breakpoints. For example, if you want to see the values at every iteration of the Foreach Loop Container, you can set a breakpoint on the container. Right-click the container and select Edit Breakpoints. Check the Enabled boxes for the appropriate events, "Break at the beginning of every iteration of the loop" in this case. Start the package and when there's a break, look in the Locals window for your variables to see the current values. Click the start button to continue processing.

bobs 2010-09-01 20:24:02

Thanks bob. really appreciate your help and your expertise in SQL. Thanks a million.

CombatCaptain 2010-09-01 20:32:24

related questions

Backup SQL Schema Only?

Sql to query a dbs scheme

Timer-based event triggers

Sql query, count and group by

Paging SQL Server 2005 Results

SQL 2005 For XML Explicit - Need help formatting

How do I use T-SQL Group By

What all do I need to escape when sending a (My)SQL query?

Split String in SQL

Datatable vs Dataset

ASP.NET MVC "CRUD" Database Sample

Convert HashBytes to VarChar

Best Book for a new Database Developer

What is the best way to avoid SQL injection attacks?

What language do you use for Postgresql triggers and stored procedures?

What is the best way to handle multiple permission types?

How do I index a database field

Swap unique indexed column values in database.

cx_Oracle - what is the best way to iterate over a result set?

cx_Oracle - How do I access Oracle from Python?

Is there a version control system for database structure changes?

How to export data from SQL Server 2005 to MySQL

ASP.NET Site Maps

Decoding T-SQL CAST in C#/VB.net

Flat File Databases in PHP