SQL Query on Staging Table in SSIS 2008

  • Hi.

    I am doing ETL and after transformation (Multiple table joins etc) has been done, I got the table shown in the picture attached. Now finally I want to perform some simple queries on this transformed table to filter out records. How I can perform sql query on this table ? After performing queries I will load data to the destination table. Please help me.

    I will be very thankful to you.

    Regards

  • What do you mean perform queries?

    What are you trying to do?

    You can Load the data into a Table in the database, make changes query, etc.

    Then you can copy the data to the final table.

    Just depends on what your trying to do.

Viewing 2 posts - 1 through 1 (of 1 total)

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