VG is right. First combine the two columns as one as string. and then convert that combined column into data type of your choice. You will get an issue if...

This might be because of several issues. First what is your datatypes?. and Also, I belive there are some null values or values at least looks null, but have some...

TRY this

"SELECT Count(*) As Count FROM Table A".

Then on the ResultSet , Type Count in the value and map to your Varaiable.

This should work.

thanks

First of All I would rather use ADO.net connection when i am using Proc in the SSIS, especially when i am passing parameters. reasons: Much easier to map the parameters...

MUKTI ........., I believe I am doing right here. But I don't know what is wrong here. Let me give you my proc str

ALTER PROCEDURE [dbo].[uspOmniCaidException]

@type char(1)-- 'P' for...

Because my Proc that ia m calling on the next step requires either P or M as input parameters. The logic is build in that way within the proc.

Jack u r a Geni.......s!! I solved the problem. Jack is right, it was not the prblem with case , but string. I found out that the lenght of the...

Help me out here .....( i am very bad at coding..............)

How would you do that exactly in the code.

Output0Buffer.AddRow()

Output0Buffer.FooterRow = String.Format("T{0}",...

Do you suggest me to do with Expression in variabales or do the coding in the script. I tried with variables ---

I declared another variable CountForWrite and whitin that varaiable...

I belive we are still not on the same page here..........

There is no such column name in detail table called [EDI_CLM_SEQ_NBR].

Here If u see in the HDr, For CLM_KEY 3...

Loweel I belive U missunderstood me or my explanation was not well enough to give you the hint.....................

the column in HDr tbl [EDI_CLM_SEQ_NBR] will have int value like 1,2, 3,...

Hey Lynn!!

May be u could help me out here too. I need to add 1 more logic here ...

Below is the code. I need to make sure that this column...

Here What Saral.... Has Done is ................

He added one more column so that he can use that column in is update statement for Dtl tbls. He HAs Two OLEDB Command...

DOn't worrry Crispin , I will defenately post it , Once I am Done with it...

Just give me some time...................

Thanks

SOrry I took out all the OLEDB command and multicast, since it was giving me all kind of Errors--

Here is the package for you -------

Now Looks like it is...