Code

Home / Posts tagged "Code"

02 May. 3:04 pm

Matt Code, Connection Managers, Extensions 1 Comment

How to Localize Your Custom Connection Manager

Similar to localizing a task, you can localize the display name and description of a custom connection manager by setting the LocalizationType property of the DtsConnection attribute. SSIS will look for two properties on the class: ConnectionDescription ConnectionDisplayName These must be public, static string properties on your LocalizationType class. The code looks like this:

    [DtsConnection(ConnectionType = "MYCONNECTION", LocalizationType = typeof(Strings))]
    public class MyConnectionManager : ConnectionManagerBase
    {
    }

[DtsConnection(ConnectionType = "MYCONNECTION", LocalizationType = typeof(Strings))]

public class MyConnectionManager : ConnectionManagerBase

{

}

28 Mar. 1:46 pm

Matt Code, Excel, Samples, SSIS 4 Comments

Refresh an Excel Workbook with a Script Task

Are you loading data from an Excel workbook with external queries using SSIS? Do you want to make sure those queries are refreshed before the load takes place? Have I got the post for you! I recently had to do this myself, and after some googling with Bing, I found an MSDN forum post that … Continued

07 Mar. 7:37 pm

Matt Code, Data Flow, SSIS Leave a comment

Generate Data with a Script Component

I use the following code to generate data with a script component. I’ve found this useful in the past to demonstrate how buffers are handled in the data flow, as well as perf/load testing a destination component. This script will automatically generate data based on the columns you’ve defined for the component – no additional … Continued

03 Oct. 12:06 pm

Matt API, Code, Extensions, SSIS Leave a comment

Encrypting Sensitive Properties in a Custom Connection Manager

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

03 Oct. 7:52 am

Matt API, Code, Extensions, SSIS, Tasks Leave a comment

How to Localize Your Custom Task

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:

[ DtsTask( LocalizationType = typeof(Resources) ) ]
public class ExecuteCatalogPackageTask : Task 
{
}

[ DtsTask( LocalizationType = typeof(Resources) ) ]

public class ExecuteCatalogPackageTask : Task

{

}

You can add localizable string resources to your class from the Project settings: Note, the … Continued

01 Oct. 1:33 pm

Matt API, Code, Data Flow 6 Comments

Automatically Select Input Columns in a Custom Data Flow Component

The following code snippet can be used in a custom data flow component to automatically select all input columns when you attach a path.

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);
		}
	}
}

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.