Wednesday, November 21, 2012
There are so many funny quirks in SSIS 2012 that I have to list them, to save other people from the misery.
- If you want to move items to one direction, make sure you "grab" the opposite side. For example, you want a whole bunch of data flows to move up, select them all and grab the lowest item.
- When you drag the arrow to connect Precendence Constraint, make sure you drop it on the area of target that has no text, otherwise, it thinks you want to edit the text and change the target item layout
Always was able to do it in a .NET application and a reporting project. This took me a while to realize. In SSIS 2012 project, once you create project.params, you can add them to your configuration settings by clicking this button
A dialogue pops up where you can add your project params and specify their values in different configuration set.
Refer to my previous post (http://geekswithblogs.net/LifeLongTechie/archive/2012/11/14/time-to-stop-using-ldquoexecute-package-taskrdquondash-a-way-to.aspx) about dynamic package calling and multiple packages execution in these posts:
I only saw this twice, other times the stored procedure was able to call the packages successfully. After the service pack, I haven't seen it...yet.