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 |
|
whizsql
Starting Member
17 Posts |
 Posted - 2009-01-05 : 15:47:08
|
| I have a SSIS import export package, which truncates records on destination table,imports data and inserts records.It copies primary key as well.I used import export wizard in BIDS to create this package.Around 100 tables are imported.I didnt use optimized option on wizard.Since I used import export package, I have no idea about underlying code.Now, I have to tailor this package to include differential import such that only updated records are imported nightly.Also,I need to setup log files, notifications etc. How can I achieve these? I would appreciate if someone can recommend recources to understand the code behind my import export package.These import export packages are customizable?Thanks in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-05 : 21:27:47
|
| You can find all logics behind Export/Import wizard by opening the Saved SSIS package for export/Import wizard in Business Intelligence Studio as DTSX. |
 |
|
|
|
|
|
Customized SSIS import Export package