Post reply

Loading partitioned table incrementally using SSIS

  • November 2, 2017 at 12:00 am

    #402641

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

  • 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.

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

  • 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.

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

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

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