November 2, 2017 at 12:00 am
Comments posted to this topic are about the item Loading partitioned table incrementally using SSIS
November 2, 2017 at 1:22 pm
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
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy