Sorry for coming again and thanks for ur response Jack...

I did the same and i couldnot get the component in

Toolbox(right click) --> Choose toolbox items --> SSIS Data Flow...

Thanks for ur response.. I did the same.. Right clicked the Toolbox --> Choose Toolbox items --> SSIS Data Flow items -->

But i could not find the custom component.....

Hi Jack,

I am using VS2008. Should the VSS be installed for sure? I dont have VSS in mine.

I could not find the GACutil in the folder "C:\Program Files\Microsoft Visual...

Hi All,

I had created the ErrorHandling.cs to a .MSI Installer.... After installing the setup, i could not find the component in the SSIS --> Data Flow Transformation tab.

Please help me...

Hi Jack,

I have a doubt again.... Should I want to create ur downloaded code as a .msi installer for reusing it for all the packages or is that used as...

Hi Jack,

Thanks for your innovative work!

Regards,

Nithya

Hi!

Thank u so much....

I got the result.... I was wondered to see the date format set previously....

Now it works.....

Nit :hehe:

It looks in the foll. format

2008-01-01 00:00:00.000 (in the table)

I run it from SSMS.....

Hi...

Thank u so much...

I am really very shocked that the code for coalesce works with sample but not with the original sp...

Could u plz say me why the code...

Hi,

My actual problem is......

CREATE PROCEDURE [dbo].[usp_EmpSearchResult]

@EmpID Int = 0,

@EmpName Varchar(100) = Null,

...

Hi... Thanks again...

The problem is that the value for the parameter is not passed exactly to the query.....

Previously, the dates were substituted and the results were displayed....

But after substituting Coalesce...

Hi,

Thank u for reply......But the problem persists......

I had replaced the search conditions with coalesce like....

IF EXISTS(SELECT NAME FROM NCRMSP..SYSOBJECTS WHERE NAME LIKE '%usp_EmpSearchResult%' AND TYPE = 'P')

BEGIN

DROP PROCEDURE usp_EmpSearchResult

END

go

CREATE...