Package doesn't run anymore on SP2

Hi all,

I've installed SP2 on my server. If I run the package on the server, the package worked there before the installation of SP2. Now with SP2 it doesn't work anymore. In VS2005 on my computer the package works before and after the installation of SP2.

He gives an error with the execution of a sql-task on an oracle server:

Error :Executing the query "insert into cube_content values (trim(?), trim(?), trim(?), trim(?), trim(?), sysdate) failed with the following error: "ORA-01401: inserted value too large for column". Possible failure reasons: Problems with the query, "ResultSet property not set correctly, parameters not set correctly, or connection not established correctly.

Anybody an idea?

Thanks,

Dennis

That error appears to be from the Oracle server, not SSIS related. It looks like you are inserting a value too big for the field.

Look at the table definition and the data you are trying to insert.

|||

It seems as though the interface to Oracle has changed. Do you use the Microsoft OLE DB Provider for Oracle? My best guess is that something in SP2 has changed the provider or something. That's my best guess.

Build a new package using the same SQL statement against Oracle and see if it sets it up with different metadata to what is in your existing package.

-Jamie