SSIS - create Connection Manager at runtime, conditionally

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247183 More actions · Answer 1

There's are a couple of tricks to get round these problems.

Put your dataflow inside a FOREACH container, with the enumerator is set to 'File' and the 'Enumerator Config' pointing to the file you wish to process.

The dataflow will execute only if that file is found. If not, the package completes (successfully) without doing anything inside the container.

To prevent the validation error, set the Connection Manager's 'Delay Validation' property to True.

Michael Gerholdt SSCommitted Points: 1907 More actions · Answer 2

Beautiful, thanks.

Note: In addition to your directions, I also had to set "Delay Validation" to true for the pipeline object that led to the Destination object.