by Darren Green
6 Jun 2016 16:07
The task will detect changes to existing files as well as new files, both actions will cause the file to be found when available. A file is available when the task can open it exclusively. This is important for files that take a long time to be written, such as large files, or those that are just written slowly or delivered via a slow network link. It can also be set to look for existing files first (1.2.4.55).
The full path of the found file is returned in up to three ways:
The ExecValueVariable of the task. This can be set to any String variable.
The OutputVariableName when specified. T...
[More]
by Darren Green
13 Oct 2007 14:00
Download the slides and sample code from the Extending SSIS with Custom Tasks presentation, first presented at the SQLBits 2007 Community Conference.
The sample demonstrates a custom task with a connection property, including a property grid drop-down (UITypeEditor) to list all your connections and also add new connections, and a password property flagged as sensitive to honour the package protection level. It also illustrates how to create a user interface for your task.
Abstract
This session is all about developing for SSIS, writing .Net code to create your own tasks. We cover b...
[More]