Jhon thanks for ur response.

well i have only used so far OLE DB provider but didnt use ODBC, cannot you guide how...

BEGIN TRANSACTION /END TRANSACTION doesnot work ib my DB2 OS390 7.1.1. May be in some other version.....i am stuck such simple piece is required and i cannot find it out...

Thanks jack.

I have already applied this technique and i have mentioned that Transaction property of SSIS creates problem when you have more then one machine and on different enviorments. Microsoft...

Thanks alen for ur feedback....and every body else who are contributing to solve problem. Null values problem now aint that important i have somthing more significant to ask from u...

jack i did use the script component for error description.

Any ways i agree with u, noramlly microsfot build a paltform and on top of that they mature thier product.

SSIS is...

well guys configuring "redirect rows on error" worked for me. In source data, there were some rows with Null values, although in destiantion there isnt any Null constraint, therefore my...

yes jack, for that i actually removed that stagging table, and i was inserting data direct in DB2, even then no success.

Thanks once again.

Thanks jack corbett, Atleast somebody has responded on my thread, previously about connectivity and OLE DB Provider for DB2 i asked a question on MSDN and on this forum, and...

Hi thanks for the reply....well i have learned some basics of .Net to parse a file...however the way u told me ...i will look into that...

but thanx any way for...

Thnx peter you are abs rite, column has no name, error was coz of select 1/0 statement, and yup now i m getting same problem that u have mentioned with...

yes SET NOCOUNT is ON in the beginnig of SP,

let me paste the code here.........

/****** Object: StoredProcedure [dbo].[usp_Inv_Lot_Ship_History_2201s] Script Date: 06/16/2008 02:40:37 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

Thanks fritchy for ur time and support, yes users of applciations are using view as wild earsh..,means no where clause, i just cannot understand why they are doing so, i...

Thanks for u guys feedback i am attaching the execution plan, code and table and index defination, kindky see these and propsed your solutions.

Looking fwd for ur replies

Thanks Jack for ur reply, ya i m doing the same approach so far, by getting true or false by simple select statemnet and on failure i m sending a...

Thansk Animal Magic for you quick response, well yup better to add another step on job failure and get the details from sysjobhistory table and then emailing it.