Can you please tell me how it has worked for you,I am also having the same scenario.

Thanks for the reply. But here in this case ETL packages will be run by customer,if we set protection as EncryptAllWithPassword we have to share the password with them...

I do not have sufficient permission to add deadlock trace.Actually I am inserting new records into Target table (say Table B) using Merge statement (WHEN NOT MATCHED), I have replaced...

You have to insert that the Results into a Table,because the Execute Sql Task doesn't display resultant data while executing the ssis package..

If you want to work with the results...

If your source is Table you can write Sql query to filter the null records using oledb source query.If it is a flat file or excel source then you can...

Thanks for the response guys..

It worked for me...If there is only one ID present (Like 400) we need to select that record,here no need to look at Min amt and...

Here are the sample interview questions.

1)WHAT'S THE DIFFERENCE BETWEEN CONTROL FLOW AND DATA FLOW?

2)Difference between Merge and Merge join Transformation?

3)How checkpoints work in a package.

4)How you would suggest using...

Thanks dude ...Your solution worked for me...The problem is with permission for user account..Thanks alot..

The account on which the job has created has admin privilege..Then what might be the other reasons for failure of the package.And the package is running good in production with...

The account on which the job has created has admin privilege..Then what might be the other reasons for failure of the package.

Hi,

as u mentioned the merge option works under sql server 2008 only.How can we do the above scenerio in sql server 2005..

Hi,

I can send answer for one of ur requirement

update emp_dest

set status='D'

where empid not in(select empid from emp_stage)

It updates 4,5 to 'D'

u can use delete,insert into,update statements to to...