SQL Query on Staging Table in SSIS 2008

• hamid.fastnu

  Grasshopper

  Points: 15

  More actions

  March 29, 2013 at 9:34 pm

  #291609

  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

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  March 30, 2013 at 12:54 pm

  #1602263

  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.