Use the CustomPropertyCollection["OpenRowset"] property on the component cast as IDTSComponentMetaData100, like so:

Executables pExecs = pkg.Executables;

foreach (Executable pExec in pExecs)

{

TaskHost taskHost = (TaskHost)pExec;

Console.WriteLine("Executable...

You can also use dbcc freeproccache, which will prevent the error from occurring until the next time the schema on the linked server changes.

As someone who is guilty of coding 2-digit years back in the day when disk space was expensive, I’m a little offended and a little amused by the profligacy of...