Yes. The DBA team did a Manual Failover to the prior state. Is there any site or articles on what exactly is Always on and how we can do a...

I got the issue resolved by deleting the User from the Database and mapping the login to the DB after that..

Well. The destination would be having data from multiple sources.. so i cant go with the PK from source...I found a way to achieve this in script task. But wanted...

You are absolutely correct Andy and we have already informed the same to our client. But for some reason they have gone by this design.

Hey Koen,

Thanks for your response. I found that there are 2 tasks which you can use for this purpose. OnError and onTaskFailed. All I am going to do here is...

Thanks Steve for your response. The Migration would not be a one time process. It is going to be a daily job and I guess MERGE should be able to...

Thanks both of you for your responses. I haven't worked much with Data Migration. So I am not really sure about the performance aspects of MERGE for this purpose. Moreover,...

Thanx Koen.. That cleared my doubts...

It is not advisable to use Varchar datatype to store Date & Time values. Kindly declare the variables as DateTime and test it...

First thing to check: from the SQL Server, can you connect to the SQLExpress instance (with SSMS or SQLCMD)?

If not, there's no need to involve the linked server in your...

Do i need to specify the port...

You have to use a LEFT JOIN here with the branch column. However, a join is usually made on a Primary KEY which would be an integer column which is...

This blog might help..

http://blog.sqlauthority.com/2009/05/03/sql-server-add-or-remove-identity-property-on-column/

[font="Tahoma"]Could there be some other triggers on this table[/font]

Thanks for your input Eugene...