All the column data should be same in all 7 databases. - basically select *..from table

do we need to use intersect?

select NOMB1 from view1where TNum = 0011008183

Data looks like this

02020790

00000000

select SUBSTRING(Emp.NOMB1, PATINDEX('%[^0]%', Emp.NOMB1+'.'), LEN(Emp.NOMB1)) as EmpNUM

from view1 Emp where TNum = 0011008183

Data looks like

2020790

Note : In the second select...

yes NOMB1 column is nvarchar(8), null.

Yeah, TY

I have commented that return statement and kept a break point on Execute sql task. I can see all the values which I am passing to that SP for...

I didn't understood this point

I understand that, but OUTPUT parameters in a proc do not need the RETURN keyword, all you need to do is set their value within the...

I changed from Select to SET.

Still its showing error

"Input string was not in a correct format.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,

parameters...

We need this Id to return we are using in another Sp as imput. to update Emp table with this Id.

Solution

Let me clarify here - The code which I mentioned I am not using any cursor its just a bulk insert..

In the old procedure the people who coded was using...

Is there any example or link should I refer to?

I am confused here ..If you have any proper links where I can see and implement please forward it to me.

The query which I am using in the package is just select query -- it is not using any variables.

it is coming from different database we are using it as...

This is just for testing another area.

SSIS script component used as destination.. to see weather we can load anything entirely from the script to destination.

This is for just testing purpose of SSIS package using Script component.

I created an empty table in test database with 2 columns and I drag this script component and trying...

Basically we are loading SSIS package where the Employee information is coming from source(Different database)to staging (Temporary table) called EmpTemp

Note - Full amount column is not comming from source.

In the...

Yes, Those 3 columns are nvarchar and char

they are not int.