SSIS Coding Help
 

Differences

This shows you the differences between two versions of the page.

ssis_tips [2013/08/07 15:03]
tznind
ssis_tips [2013/08/07 15:04] (current)
tznind
Line 137: Line 137:
  
 ===== CHECKLIST FOR COPY PASTING A DATA LOAD FOR SPRINT 2 ===== ===== CHECKLIST FOR COPY PASTING A DATA LOAD FOR SPRINT 2 =====
 +CHECKLIST FOR COPY PASTING A DATA LOAD FOR SPRINT 2:
  
-1. Change delete statement at top + 1. Change delete statement at top 
-2. Change package name (click anywhere in grey area and change Name) + 2. Change package name (click anywhere in grey area and change Name) 
-3. Data Load Info  + 3. Data Load Info  
- 3.1 Change data load description + 3.1 Change data load description 
- 3.2 Change rollback command + 3.2 Change rollback command 
-4. Change table info + 4. Change table info 
- 4.1 change source description + 4.1 change source description 
- 4.2 change destination table + 4.2 change destination table 
-5. Update the names of component blocks to make sense + 5. Update the names of component blocks to make sense 
- 4.3 enter expected INSERTS (Based on lines in file)+ 4.3 enter expected INSERTS (Based on lines in file) 
 + 6. Change connection managers and build data flows 
 + 6.1 Rename blocks 
 + 6.2 Change connection manager in source file 
 + 6.3 Update row errors component (Error Destination) 
 + 6.4 Create new ERRORS file and set it as error destination 
 + 6.5 Assign this new ERRORS flat file to the error output of the flat file input 
 + 6.6 Change database destination tables 
 + 6.7 Delete unmapped inputs comming out of the first database destination (errors output) 
 + 6.8 Confirm mappings are correct for all database destinations 
 + 7. Confirm all columns are set to redirect on errors 
 +
  
-6. Change connection managers and build data flows 
- 6.1 Rename blocks 
- 6.2 Change connection manager in source file 
- 6.3 Update row errors component (Error Destination) 
- 6.4 Create new ERRORS file and set it as error destination 
- 6.5 Assign this new ERRORS flat file to the error output of the flat file input 
- 6.6 Change database destination tables 
- 6.7 Delete unmapped inputs comming out of the first database destination (errors output) 
- 6.8 Confirm mappings are correct for all database destinations 
- 
-7. Confirm all columns are set to redirect on errors 
-  
  
 
ssis_tips.txt · Last modified: 2013/08/07 15:04 by tznind
 
Recent changes RSS feed Creative Commons License Driven by DokuWiki