I’ll be co-presenting a couple of sessions at SQL Saturday #172 in Portland, Oregon this weekend (11/3). The lineup for this event looks great, with a lot of speakers who will also be at the PASS Summit the following week. First up is an SSIS session with SSIS Design Pattern co-author Tim Mitchell (Blog | … Continued
A big thank you to everyone who came to tonight’s DQS presentation for the New England SQL Server User Group. As promised, you can find the slides on my skydrive share (as well as embedded below). I also wanted to list some of the great DQS resources mentioned in the talk: Performance Whitepaper Getting Started … Continued
SSIS provides a mechanism to automatically encrypt the sensitive properties of your Connection Manager (or Task) based on the package ProtectionLevel. To make use of this in your custom code, you’ll need to do two things: Implement the IDTSComponentPersist interface Add a Sensitive=”1” attribute to one or more elements of your persisted Connection Manager (or … Continued
The DtsTask attribute has a LocalizationType member. This should be your resource class. SSIS will look for two properties: TaskDisplayName TaskDescription These must be public, static string properties on your “LocalizationType” class. Your task code would look like this:
|
1 2 3 4 |
[ DtsTask( LocalizationType = typeof(Resources) ) ] public class ExecuteCatalogPackageTask : Task { } |
You can add localizable string resources to your class from the Project settings: Note, the … Continued
TechEd has its appeal, but of all of the conferences I attend, I must admit that I love the PASS Summit most. I look forward to it every year. The event is physically and mentally exhausting, but I always come home feeling refreshed and inspired. I really enjoy meeting people who use the products I … Continued
The following code snippet can be used in a custom data flow component to automatically select all input columns when you attach a path.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
public override void OnInputPathAttached(int inputID) { base.OnInputPathAttached(inputID); for (int i = 0; i < ComponentMetaData.InputCollection.Count; i++) { ComponentMetaData.InputCollection[i].InputColumnCollection.RemoveAll(); IDTSVirtualInput100 input = ComponentMetaData.InputCollection[i].GetVirtualInput(); foreach (IDTSVirtualInputColumn100 vcol in input.VirtualInputColumnCollection) { input.SetUsageType(vcol.LineageID, DTSUsageType.UT_READONLY); } } } |
This is the equivalent to clicking the Select All box in the Advanced Editor.