Loading partitioned table incrementally using SSIS

• shubhankarthatte

  Mr or Mrs. 500

  Points: 589

  More actions

  November 2, 2017 at 12:00 am

  #402641

  Comments posted to this topic are about the item Loading partitioned table incrementally using SSIS

• MMartin1

  One Orange Chip

  Points: 27841

  More actions

  November 2, 2017 at 1:22 pm

  #1966473

  Not sure that you need a dynamic sql statement in Ole db source adapter, via a variable. To use something like a date variable I can simply construct my query like the following:
  
Select col1, col2 col3
from myTable
where dateField >= ?


  Use the Parameters dialogue via the button to map the '?' to your date variable. 

  You also mention :
  

  In my example, I have created 3 tables as shown above – dbo.TGT_tablename_tbl, swap.TGT_tablename_tbl and shadow.TGT_tablename_tbl.

  The names here are not consistent with the diagram. That would be good to have. 
  Thanks.

  ----------------------------------------------------

• MMartin1

  One Orange Chip

  Points: 27841

  More actions

  November 3, 2017 at 2:24 am

  #1966529

  Referring to figures 7 and 8 ... I also wonder what someone would expect from the use of the NOLOCK operator. It is not an optimizing technique.

  ----------------------------------------------------