Loading partitioned table incrementally using SSIS

  • shubhankarthatte

    Mr or Mrs. 500

    Points: 589

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

  • MMartin1

    One Orange Chip

    Points: 27502

    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.

    ----------------------------------------------------
    How to post forum questions to get the best help [/url]

  • MMartin1

    One Orange Chip

    Points: 27502

    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.

    ----------------------------------------------------
    How to post forum questions to get the best help [/url]

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

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