InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 22:14:28 GMT20http://www.sqlservercentral.com/Forums/Topic1430819-364-1.aspx[quote][b]Paul Hernández (3/14/2013)[/b][hr]Hi Phil,It was a language mistake due to my level of English, which sometimes is not good enough :-DYou are right; the correct term is [b]“temporary”[/b]Thanks for your remark.[/quote]No problem. That's a shame - I was quite looking forward to an innovative temporal solution :-)Thu, 14 Mar 2013 03:53:10 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1430819-364-1.aspxHi Phil,It was a language mistake due to my level of English, which sometimes is not good enough :-DYou are right; the correct term is [b]“temporary”[/b]Thanks for your remark.Thu, 14 Mar 2013 03:50:52 GMTPaul Hernándezhttp://www.sqlservercentral.com/Forums/Topic1430819-364-1.aspx[quote][b]Paul Hernández (3/14/2013)[/b][hr]Hi Phil,Thanks for your quick answer.Then I will create a temporal table to store the records to be update, and then perform a batch or bulk update, I think it is the best option since use a "OLE DB Command" component is too slow.I posted it here, because this issue is a part of an ETL proccess and I´m comparing loading strategies, but it could also be posted in the SQL Server 2008 forum.Kind Regards,[/quote]Sounds like a good option. I think you meant 'temporary' rather than temporal. If not, I'd like to know how you would use a temporal table here.Thu, 14 Mar 2013 03:46:37 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1430819-364-1.aspxHi Phil,Thanks for your quick answer.Then I will create a temporal table to store the records to be update, and then perform a batch or bulk update, I think it is the best option since use a "OLE DB Command" component is too slow.I posted it here, because this issue is a part of an ETL proccess and I´m comparing loading strategies, but it could also be posted in the SQL Server 2008 forum.Kind Regards,Thu, 14 Mar 2013 03:42:44 GMTPaul Hernándezhttp://www.sqlservercentral.com/Forums/Topic1430819-364-1.aspx[quote][b]Paul Hernández (3/14/2013)[/b][hr]Hi Folks,I would like to know if it´s possible to use the T-SQL MERGE if the source DB is a DB2/AS4000 in a remote server, and the target is a SQL DB in the local server.Any comment would be appreciated.Kind Regards.[/quote]I doubt it, given that DB2 SQL is a different language from T-SQL.Why have you posted this in the Integration Services forum, by the way?Thu, 14 Mar 2013 03:08:34 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1430819-364-1.aspxHi Folks,I would like to know if it´s possible to use the T-SQL MERGE if the source DB is a DB2/AS4000 in a remote server, and the target is a SQL DB in the local server.Any comment would be appreciated.Kind Regards.Thu, 14 Mar 2013 03:01:37 GMTPaul Hernández