The number of outputs is incorrect. There must be exactly 1 or 2 outputs.

[roniel.navarro]

Hello fellows!

Has anyone faced this error before?
The number of outputs is incorrect. There must be exactly 1 or 2 outputs.

It's a lookup component and it's giving me this error when I run it from a SQL Job and not from the VS IDE

Thanks in advance for your kind help

Roniel

[Shalex]

1. Exactly the same package works correctly (and without errors) in Visual Studio, doesn't it?
2. Try adding the "Refresh Metadata = True;" option in your connection string. Does this help? If not, send us your package (mark a confidential information with asterisks).