HomeSQLServerPedia SyndicationUsing SSIS lookup transformation editor with millions of rows

Comments

Using SSIS lookup transformation editor with millions of rows — 5 Comments

    • Hi Pedro,

      I have not tried the Cache Transform task. I will give it a spin, but I’m thinking I will have the same issue with it taking up all the memory when I try to load millions of records. Thanks for the question.

  1. Hello James,

    Right now I am using lookup transformation and we have more than 2 millions rows, the tempdb is not able to handle this. Can you give me an example on how to use merge statement, please.

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>