Data Source=yourDatabasename.world;User ID=yourUserid;Password=yourPassword;Persist Security Info=True;Unicode=True;

OK, so I removed everything else except the ConnectionString part from the config file for the Oracle connections, and now it works both via command line and in my Agent...

Please bear with me; I'm new to all of this.

I've been using the Package Configuration Wizard to create my config file; how do I create one manually? Can you...

Could you please elaborate on what you did to fix this error? I've tried using Don't Save Sensitive, but then I can't even run my SSIS package through my project;...

Are you saying I have to recreate my package? All I'm trying to do is remove the encryption while saving to the database, or after saving to the database, but...

I ended up using CAST to return a string value, then converted it back to a number in another step.

Thanks!

Tried that earlier; doesn't work.