|
Here are some notes with a buch of links to topics discussed in our June 3rd, 2008 meeting.
I have put the Word document on my SkyDrive http://cid-89384f23767a9a97.skydrive.live.com/browse.aspx/Public?uc=1 .
1 Tools
1.1 BIDS Helper
1.1.1 Create Fixed Width Columns
1.1.2 dtsConfig File Formatter
I cannot get this to work. Ctrl-K,Ctrl-D does the same thing, but hard to remember.
1.1.3 Expression and Configuration Highlighter
For very large packages this might need to be disabled.
to enable or disable functionality go to Tools | Options ... The select BIDS Helper.
1.1.4 Expression List
This is a big time saver. All of your expressions are listed in one place. Also they can be edited from here as well.
To get to it go to View | Other Windows | Expression List (BIDS Helper)
1.1.5 Smart Diff
Smart Diff is great for comparing your working copy of a package against the last version checked into your version control system. In addition it makes the xml, the packages are saved as, easier to read by us humans.
1.2 SSIS Non Admin Access Tool
1.3 SSIS Package Manager - PacMan
1.4 Version Control
Use it early and often. There is no UNDO in many cases.
2 Tips
2.1 Creating Solutions
2.1.1 Start with a blank solution
|