THKZ SIMMONS IT WORKED ...

No I cant it throws error

yes tom its unicode but i converted it to to dt_str from dt_wstr using data conversion....but still i have the same problem ..could u plz let me know that ...

Dfine tat works but i dont have any id column there in my select statement ...let me show u what exactly i am doing

select a.center,a.type,

count(case when...

Murali ...

did u get it solved ...if not i believe this should work as paul said ...

from the source send it to multicast

Source-----multicast ....it sends the same o/p to...

The packages which have .config file might be using it in prod also ...it is mainly used for deployment..it is to dynamically configure ur packages ...so which ever u want...

You are updating it on a single record and it takes 20 min ...tat sounds strange....

so do u want to update all the ids or jus one single id ..can...

Murali,

could u explain me what exactly u are doing as i haven't understood what u are trying to do ...

if at all u want to eliminates the dup u can...

Is the Client name and id same for all the data if so why dont u set default in ur dest table ......

if not where do u get it...

So do u have a table with column names --id, emp_social, emp_no.,cline_id,client_name in the destination

i want to know if u want to match based on name and insert it...

where are u getting this falt file from ...if u are exporting data from ur db to flatfile and moving it to another location then u can use some expresiions...

but where are u getting this id and client name from ...plz explain it clearly so that there would be a better to chance to get the answer...

hmm......see the attachment ..

:arrow:feels like a totty ....Take it easy...:P

how are you passing the parameters

exec usp_abc ?,?,?,?,?,?,?,?,?,?,?,

u need to have 11 commas i guess try this once and let me know

I forgot to say u...did u run the sp after making changes to 11 columns in management studio if not run it before u exec in ssis package...i belive...