Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abacusdotcom
Posting Yak Master
133 Posts |
 Posted - 2008-09-18 : 06:51:45
|
| Morning All,I need your helps.Kindy advice how I can do my daily loading without loading those have loaded before.. My load into DW database daily ranges 1M to 2M fresh records. This cause timeouts and other form of delay on the database..Please advice.. ThanksI sign for fame not for shame but all the same, I sign my name. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-18 : 08:35:25
|
| Can you give us scenerio about your loading? I mean where its coming from and where it's going to. Do you lots of indexes in your tables? |
 |
|
|
ells
Starting Member
25 Posts |
Posted - 2008-09-18 : 08:53:21
|
| one possibilty could be to create a temporary table and load to the temporary table, and from there to the target table for thoise that dont exist in the target table.Has you target table got indexes stc on that may slow down the load?Ells |
|
|
|
abacusdotcom
Posting Yak Master
133 Posts |
Posted - 2008-09-18 : 13:53:12
|
| ELLS, THATZ MY APPROACH TOO, but i do using tsql straight.. how can do this using ssis?thanksI sign for fame not for shame but all the same, I sign my name. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-18 : 13:56:52
|
quote:
Originally posted by abacusdotcom
ELLS, THATZ MY APPROACH TOO, but i do using tsql straight.. how can do this using ssis?thanksI sign for fame not for shame but all the same, I sign my name.
use data flow task in ssis inside which create connections to your source and destination server dbs using OLEDB source and OLEDB destination. |
|
|
|
abacusdotcom
Posting Yak Master
133 Posts |
Posted - 2008-09-19 : 06:20:23
|
| done that Visakh, what i want to do is called "ccumlating shapshot fact table"...Got the term on google this morning.. wont mind any method ST or ETL.. thanksI sign for fame not for shame but all the same, I sign my name. |
|
|
|
|
|
|
Daily Update