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 user permission

Hi,
I have a user 'AAA' who has NT Login to a database db1 on a test machine
running SQL Server 2000. I recently restored a database db2 from Production
machine to the test machine and I will call this db2_test. The production
machine didn't have the login 'AAA" set up.
Now after the restoration of db2_test I still see user 'AAA' in the list of
users and I am not able to drop it so that I can give permissions to 'AAA'
login for this restored database under the Security tab in Enterprise Manager.
I have tried running the Stored Procedure sp_change_users_login but it
didn't help.
sharman,
I don't think I understand your description. Could you do the following
please and share the results:
use master
exec sp_helplogins 'AAA'
use db1
exec sp_helpuser 'AAA'
use db2_test
exec sp_helpuser 'AAA'
Do the SIDs all match? Do the sp_helpuser LoginNames match each other? Etc.
RLF
sql

Error in user permission

Hi,
I have a user 'AAA' who has NT Login to a database db1 on a test machine
running SQL Server 2000. I recently restored a database db2 from Production
machine to the test machine and I will call this db2_test. The production
machine didn't have the login 'AAA" set up.
Now after the restoration of db2_test I still see user 'AAA' in the list of
users and I am not able to drop it so that I can give permissions to 'AAA'
login for this restored database under the Security tab in Enterprise Manager.
I have tried running the Stored Procedure sp_change_users_login but it
didn't help.sharman,
I don't think I understand your description. Could you do the following
please and share the results:
use master
exec sp_helplogins 'AAA'
use db1
exec sp_helpuser 'AAA'
use db2_test
exec sp_helpuser 'AAA'
Do the SIDs all match? Do the sp_helpuser LoginNames match each other? Etc.
RLF

Error in Updating records using Openquery

Hi,

I am trying to update a DB2 table from Sql Server using Openquery but it gives me an

error, I tried selecting rows from the DB2 table using Openquery and it works fine.

Following is the update query:

UPDATE OPENQUERY(DB2_DB2T, 'SELECT STATUS FROM $ZUDBA01.TPT20_VOLS

WHERE AUD_NBR=10000004 AND POLL_NUM_ACTUAL=''999456789'' AND

REC_TYP=''SYM''') SET STATUS='RETURNED'

This query when executed gives following error:

Server: Msg 7399, Level 16, State 1, Line 35
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: Insufficient base table information for updating or

refreshing.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange:: SetData returned

0x80004005: ].

Kindly help me out.

Thanks and Regards,

Pranjal

I am not sure how much this helps...but check it

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=113747&SiteID=1

sql

ERROR in loading data to DB2 from AS400

Hi,

I have a problem loading data from a flat file into a DB2 Dtabase by using the OLE DB Provider for DB2.

I read the data from a flat file in the unicode format and as soon as the data is to be written in the DB2 database the following error occurs and the loading process is aborted:

Information: 0x402090DE at Data Flow Task, Flat File Source [813]: The total number of data rows processed for file "C:\Dokumente und Einstellungen\Administrator\Desktop\SSIS1.txt" is 2.
Error: 0xC0202009 at Data Flow Task, OLE DB Destination [842]: An OLE DB error has occurred. Error code: 0x80040E53.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: The ProcessInput method on component "OLE DB Destination" (842) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0202009.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.......

......Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package 1.dtsx" finished: Failure.

I dont know waht those error codes meanand I tried so many things already. The tables in the database are created correctly and also, SSIS can read the data from the database if I use the preview function, but somehow, the program never starts to write data into the database for some reason. Can anyone help me?

Thx, andy

It looks like some other have had similar problems using the OLE DB Source with DB2.

One

user fixed the problem but using a DataReader source and an ODBC

connection to DB2 (see this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=250370&SiteID=1)

Another

user seems to have fixed it by restarting the Distributed Transaction

Coordinator service although he was using beta 2 of SQL Server. See

here: http://www.ureader.com/message/287061.aspx

Hope this helps.

Jason|||Hi,

I'm Facing almost similar kind of problem.
Got to load data to DB2 data base taken from AS400.

I'm using dataReader ( ADO .Net connection (ODBC connection did not work, its a work around to fetch data)) to fetch data from AS400 Server and trying to load it to a DB2 datbase ( OLEDB conection manager - using IBM OLEDB provider for DB2)

>> Is there a compatibility issue with DataReader Source and OLEDB destination ?
>> Any other alternative in that case?

PLZ help !!!!!!!!!!

Here is the ERROR Message i get on execution:

Error: 0xC0202009 at Data Reader to DB2, OLE DB Destination [12]: An OLE DB error has occurred. Error code: 0x80040E53.

Error: 0xC0047022 at Data Reader to

DB2, DTS.Pipeline: The ProcessInput method on component "OLE DB

Destination" (12) failed with error code 0xC0202009. The identified

component returned an error from the ProcessInput method. The error is

specific to the component, but the error is fatal and will cause the

Data Flow task to stop running.

Error: 0xC0047021 at Data Reader to DB2, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0202009.

Information: 0x4004300B at Data Reader to DB2, DTS.Pipeline: "component "OLE DB Destination" (12)" wrote 0 rows.

Task failed: Data Reader to DB2

SSIS package "Package.dtsx" finished: Success.