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 (188.8.131.52).
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]
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.
This session is all about developing for SSIS, writing .Net code to create your own tasks. We cover b... [More]