maybe a fresh install of the Oracle drivers would be in order (64 bit version)

so on the advanced tab there is an execute as option that I had missed. Well that produces the same error as putting the Execute AS in the sql statement.

Also you may want to filter out registry keys, it drasticaly cuts down on the number of records......

I'm assuming everything has been running in 64bit since before the upgrade.

One thing you could try, I find this to be useful.

Run Process Monitor http://technet.microsoft.com/en-us/sysinternals/bb896645 on the server, setup...

I'd bet it's a security issue.

What did you upgrade from?

Also If you could post the errors, that would be helpful.

Can you run the job from the agent?

so what you are saying is you want to run the same package on the same server but hit different servers/databases depending on which job step is run?

If so then...

Well I knocked 220 lines of code (110 IF statements) down to 4 lines of code using Reflection.

Basically I needed to populate up to 110 output fields in a script...

can you provide error messages. also post how far the script is getting (based on your message boxes). do you have the needed references in your code?

One thing you can...

Oh yeah you don't need to tell me about it, this is 3rd party software too, nothing we built that's for sure!

Yeah it's strange, generally we strip off the spaces but this is an odd case when the space is actually part of the key, very frustrating indeed, we stripped the...

Steve I understand not wanting too many levels. My main reason is that the activity for bi forums is spread across multiple areas and these are generally lower activity so...

Well here is my option 4:

Unless you have a 3rd party job scheduler, I suggest you install the SQL Engine as well on your SSIS server and use the SQL...

Use a derived column.

You can either add it as a new column or choose the Replace 'ColumnName' option

Give it a formula like:

the...

Sean you beat me to it.

here is my version anyway figured I'd post it since I spent the time. this may come in handy for searching our SSIS config tables...

Hi, first off I am using an ADO.Net connection type

I have created a sample procedure that errors out due to divide by 0

CREATE PROCEDURE [dbo].[test]

@ErrorMessage NVARCHAR(4000)...