Sending email via Integration services - SQL 2005

Posted on 2006-05-24
Last Modified: 2006-11-18
I have a customer table with an email id as column .I want to know how to retrieve the email from the table and assign it to a user variable. This variable will be created in the BIDS as user :: variable.
Question by:bluepearl
    LVL 10

    Accepted Solution

    1. create a query in the Execute SQL Task control Flow.
    2 . Include query  
    Select emailID
    from myTable in it.
    3. Declare the variable with the datatype equvi to that of emailId in the table.
    4. Dbl click on SQL task, go to ResultSet and assign the value returned by query to the user variable.

    LVL 10

    Expert Comment

    y the answer have been graded "C"...
    is it inaccurate/incomplete in any sense....

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now