Post reply

Output Full Result Set to a Table - Article

  • December 1, 2016 at 10:06 am

    #1915494

    Thom A (12/1/2016)

    Welsh Corgi (12/1/2016)

    I just ask for guidance.

    I think that it is pretty clear what I want.

    All you've asked is "How do you get all the rows from a table in SSIS". That doesn't give us any information, as I said. What is your goal? What are you doing with all these rows? Are you putting them into another table? Extracting them into CSV files? Looping round them and sending emails?

    Every one of these has a different answer.

    Your question is about as clear as "How do I cook?". Without knowing what it is you want to cook, someone would find it very hard to tell anything helpful.

    Just look at the article. I do not need your help.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 1, 2016 at 10:08 am

    #1915495

    DamianC (12/1/2016)

    With ssis you can

    Create an sp that performs your select.

    Use the sp as the source using with result sets followed by all the columns you require along with their type.

    Then map to a destination.

    I've used this quite a bit as you can include temp tables without any issues.

    I got it thanks.

    Just create a SQL Task and do an insert.

    DAAAA... What was I thinking. 🙂

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 1, 2016 at 10:09 am

    #1915497

    Welsh Corgi (12/1/2016)

    Thom A (12/1/2016)

    Welsh Corgi (12/1/2016)

    I just ask for guidance.

    I think that it is pretty clear what I want.

    All you've asked is "How do you get all the rows from a table in SSIS". That doesn't give us any information, as I said. What is your goal? What are you doing with all these rows? Are you putting them into another table? Extracting them into CSV files? Looping round them and sending emails?

    Every one of these has a different answer.

    Your question is about as clear as "How do I cook?". Without knowing what it is you want to cook, someone would find it very hard to tell anything helpful.

    Just look at the article. I do not need your help.

    That's quite the change of tone from the previous post you quoted of mine... If you're going to tell people you don't "need" their help, you're not going to get any from anyone. We're not paid to answer your questions here, help us help you... Clearly you DID need my help though, as you thanked me for my previous answer.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • December 1, 2016 at 10:10 am

    #1915498

    Thom A (12/1/2016)

    Welsh Corgi (12/1/2016)

    I just ask for guidance.

    I think that it is pretty clear what I want.

    All you've asked is "How do you get all the rows from a table in SSIS". That doesn't give us any information, as I said. What is your goal? What are you doing with all these rows? Are you putting them into another table? Extracting them into CSV files? Looping round them and sending emails?

    Every one of these has a different answer.

    Your question is about as clear as "How do I cook?". Without knowing what it is you want to cook, someone would find it very hard to tell anything helpful.

    Did you read my original post?

    Forget it.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 1, 2016 at 10:16 am

    #1915503

    Thom A (12/1/2016)

    Welsh Corgi (12/1/2016)

    Thom A (12/1/2016)

    Welsh Corgi (12/1/2016)

    I just ask for guidance.

    I think that it is pretty clear what I want.

    All you've asked is "How do you get all the rows from a table in SSIS". That doesn't give us any information, as I said. What is your goal? What are you doing with all these rows? Are you putting them into another table? Extracting them into CSV files? Looping round them and sending emails?

    Every one of these has a different answer.

    Your question is about as clear as "How do I cook?". Without knowing what it is you want to cook, someone would find it very hard to tell anything helpful.

    Just look at the article. I do not need your help.

    Thank you we are all good. You answered my question. This post has nothing to do with CSV Files.

    Have a nice day.:-)

    That's quite the change of tone from the previous post you quoted of mine... If you're going to tell people you don't "need" their help, you're not going to get any from anyone. We're not paid to answer your questions here, help us help you... Clearly you DID need my help though, as you thanked me for my previous answer.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 1, 2016 at 10:21 am

    #1915505

    Thom A (12/1/2016)

    Welsh Corgi (12/1/2016)

    Thom A (12/1/2016)

    Welsh Corgi (12/1/2016)

    I just ask for guidance.

    I think that it is pretty clear what I want.

    All you've asked is "How do you get all the rows from a table in SSIS". That doesn't give us any information, as I said. What is your goal? What are you doing with all these rows? Are you putting them into another table? Extracting them into CSV files? Looping round them and sending emails?

    Every one of these has a different answer.

    Your question is about as clear as "How do I cook?". Without knowing what it is you want to cook, someone would find it very hard to tell anything helpful.

    Just look at the article. I do not need your help.

    That's quite the change of tone from the previous post you quoted of mine... If you're going to tell people you don't "need" their help, you're not going to get any from anyone. We're not paid to answer your questions here, help us help you... Clearly you DID need my help though, as you thanked me for my previous answer.

    I'm sorry for my response.

    I have been walking on a broken foot since 22 OCT.

    No excuse. I beg your pardon.

    I do need to loop thru a table and send an e-mail as an attachment or in the body of the message.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 1, 2016 at 10:27 am

    #1915511

    Thank you for your help.

    What was I thinking.

    I do need to read from a query and send the results as an e-mail attachment or in the body of the message.

    My sincere apologies.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 1, 2016 at 11:17 am

    #1915526

    Ok. That's a good start. What your reasoning for choosing to do this via SSIS? I asked as send dbmail is very good at achieving this, especially as your data is located in a table.

    As you said, you want to do this with a dataset, SSIS is awful for emailing datasets. MSDN has a good article about using dbmail to send a dataset, table formatted. In a HTML email here: https://msdn.microsoft.com/en-us/library/ms190307.aspx. (sorry I'm on my phone now, IfCode is a pain).

    If that looks more like what you're after I'm happy to point you further in the way you want to go.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • December 1, 2016 at 11:32 am

    #1915533

    Thom A (12/1/2016)

    Ok. That's a good start. What your reasoning for choosing to do this via SSIS? I asked as send dbmail is very good at achieving this, especially as your data is located in a table.

    As you said, you want to do this with a dataset, SSIS is awful for emailing datasets. MSDN has a good article about using dbmail to send a dataset, table formatted. In a HTML email here: https://msdn.microsoft.com/en-us/library/ms190307.aspx. (sorry I'm on my phone now, IfCode is a pain).

    If that looks more like what you're after I'm happy to point you further in the way you want to go.

    I am Grateful for your help.

    Thank you.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 9 posts - 16 through 24 (of 24 total)

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