Error Including null value in a Numeric field

Hi All,

I'm migrating some SQL 2000 DTS to SSIS.

I am transfering data from a DB2 table to a SQL 2005 table using the OLE DB Source, Data Converstion then the OLE DB Destionation.

So, I have a numeric (Precision 3, Scale 2) field with NULL value in the DB2 table.

I'm trying to transfer these data to a SQL2005 table and I am receiving this error message below:

"[Destination Table TFACIL [18]] Error: There was an error with input column "COMB_OPPT_PRCT" (2865) on input "OLE DB Destination Input" (31). The column status returned was: "The value violated the integrity constraints for the column.". "

The field must accept null because of the APPLICATION ( i can't change it, im not the owner ).

Could someone help me?

Thanks in advance.

Regards,

Thiago

Check that the SQL table TFACIL.COMB_OPPT_PRCT

1) Has no CHECK constraints on it that would prevent NULL being loaded

2) is not defined as NOT NULL

Error in migrating from AS2000 to 2005

Hi all,

I have an analysis server database in AS2000. I want to migrate the same to 2005 analysis services.while doing that I am getting an error of following.

"Source server: No error message available, result code: E_FAIL(0x80004005)."

My AS2000 is in windows server 2000 with SP4 of SQL server.

My client is in windows XP and having SQL server 2005 with SP1.

Can anybody has suggestion on it?

Thanks in advance,

Vinod

It it is possible your AS 2000 server is not setup to be administered remotely. Books online should provide sufficient information on how to setup your machine to enable remote administration for AS2000.

Alternatively, try installing AS2005 as named instance on your AS2000 box. Or you can install AS2000 on AS2005 box and then migrate you databases.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.