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 ssis package!

Hi,

[OLE DB Destination [1146]] Error: An OLE DB error has occurred. Error code: 0x80040E23. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E23 Description: "Cursor operation conflict".

[DTS.Pipeline] Error: The ProcessInput method on component "OLE DB Destination" (1146) 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.

[DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0202009.

have any of u encountered this error?

package is working good on source side but destination is indicated in red with the above error,it was working good yesterday,not sure what happened today all of a sudden.

pls help!

Regards,

sg

That's an error returned from SQL Server so I would suggest the problem is in SQL Server rather than SSIS. That's not much help I know but hopefully it gives you some pointes about where to to investigate.

Google turned these up:

http://blogs.conchango.com/kristianwedberg/archive/2006/03/08/3045.aspx (from my friend and fellow Conchango-ite Kristian Wedberg)

http://support.microsoft.com/default.aspx/kb/324900

-Jmie

|||

Hi jamie,

Thanks a lot,ur information was valuable.The package is working.

|||

Cool. If it proved to answer your problem, please could you mark it as an answer.

Thanks.

sql

error in SQL 2000 / help

Hi

Some times I get this eeror when I want open my web pages

what is this?

=========

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

/common.asp, line 260

=========

note: some times I get this error

I installed SQL on my system

My web site is in ASP

thankshey where are you?

please help me I need it|||The most common cause of this problem is a typographical error in the script. There are several million other possibilities, but that is where I would start.

-PatPsql

Error in OLE DB Command task

Hi all,

After applying the SP2 for Korean - we are getting the following error in the above task.

Transfer Fact Data From StagingDB to Presentation DB: Insert Update MetricFact [1021]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "'OPTIMIZE' ? ? ?.".

Not sure what the problem is. The same task was running properly before applying the SP2.

For other language SP2 (on other languages) the same task runs correctly and without any error.

sachin.dubey wrote:

Hi all,

After applying the SP2 for Korean - we are getting the following error in the above task.

Transfer Fact Data From StagingDB to Presentation DB: Insert Update MetricFact [1021]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "'OPTIMIZE' ? ? ?.".

Not sure what the problem is. The same task was running properly before applying the SP2.

For other language SP2 (on other languages) the same task runs correctly and without any error.

Hmmm... strange.

Can you run SQL Server Profiler to see what is getting executed against SQL Server?

-Jamie

|||

I m getting the error at design time also when the Package is opened in BI studio

when i tried using Profiler

it executes exec sp_procedure_params_rowset in backend

and throws following error

???102, ??15, ??1, ????sp_procedure_params_rowset, ?151

'OPTIMIZE' ?????????????.

|||

sachin.dubey wrote:

I m getting the error at design time also when the Package is opened in BI studio

when i tried using Profiler

it executes exec sp_procedure_params_rowset in backend

and throws following error

???102, ??15, ??1, ????sp_procedure_params_rowset, ?151

'OPTIMIZE' ?????????????.

It sounds as though the problem might be outside of SSIS. Try and isolate the problem in SQL Server.

-Jamie

|||

Hmm Thanks Jamie.

I will try there.

Error in OLE DB Command task

Hi all,

After applying the SP2 for Korean - we are getting the following error in the above task.

Transfer Fact Data From StagingDB to Presentation DB: Insert Update MetricFact [1021]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "'OPTIMIZE' ? ? ?.".

Not sure what the problem is. The same task was running properly before applying the SP2.

For other language SP2 (on other languages) the same task runs correctly and without any error.

sachin.dubey wrote:

Hi all,

After applying the SP2 for Korean - we are getting the following error in the above task.

Transfer Fact Data From StagingDB to Presentation DB: Insert Update MetricFact [1021]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "'OPTIMIZE' ? ? ?.".

Not sure what the problem is. The same task was running properly before applying the SP2.

For other language SP2 (on other languages) the same task runs correctly and without any error.

Hmmm... strange.

Can you run SQL Server Profiler to see what is getting executed against SQL Server?

-Jamie

|||

I m getting the error at design time also when the Package is opened in BI studio

when i tried using Profiler

it executes exec sp_procedure_params_rowset in backend

and throws following error

???102, ??15, ??1, ????sp_procedure_params_rowset, ?151

'OPTIMIZE' ?????????????.

|||

sachin.dubey wrote:

I m getting the error at design time also when the Package is opened in BI studio

when i tried using Profiler

it executes exec sp_procedure_params_rowset in backend

and throws following error

???102, ??15, ??1, ????sp_procedure_params_rowset, ?151

'OPTIMIZE' ?????????????.

It sounds as though the problem might be outside of SSIS. Try and isolate the problem in SQL Server.

-Jamie

|||

Hmm Thanks Jamie.

I will try there.

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.