connection manager

Question

connection manager

sqlfriend

SSC Guru

Points: 52794
More actions
March 21, 2012 at 4:29 pm

#149186

I have a package that has some flat file connecition managers.
One of the flat file is no longer needed to import, and the file source is no longer available, but for history record reason, I don't want to delete the connection manager but I will just disable the data flow tasks using it in the package.
My question is :
Will the package fail if the connection is still left in the panel of the connection manager and the file source is no longer available?
Thanks

Viewing 6 posts - 1 through 6 (of 6 total)

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

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 1

As long as the connection manager is not used, it will not fail the package.

It's no problem if the flat file is no longer available, otherwise we couldn't use the flat file connection manager as a destination.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 2

I'm thinking Delay Validation = TRUE would help, otherwise it will try to verify it and fail..

CEWII

sqlfriend SSC Guru Points: 52794 More actions · Answer 3

Thanks, it seems the above two answers are different.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 4

In reality there are quite close.

When a package opens it tries to verify all the items in the package unless Delay Validation is set to True, I believe this includes connections that are otherwise unused. however with delayed validation they aren't validated until they are used.

I hope that clarifies it for you.

CEWII

sqlfriend SSC Guru Points: 52794 More actions · Answer 5

Thanks,

The above post said,

"As long as the connection manager is not used, it will not fail the package.

It's no problem if the flat file is no longer available, otherwise we couldn't use the flat file connection manager as a destination."

so it will not fail the package. Then I don't need to change anything.

My package has 30 data work flow in it, so it is hard for me to take a test run.

I did create a very simple package that has one sql task, one data flow tasks, I disabled the dft one, and made the connection to an invalid file path.

Then I run the package in BIDs, I didn't see it fails the package.