tag:blogger.com,1999:blog-7491929482503971187.post6092721884364977448..comments2023-07-10T17:14:18.804+08:00Comments on Pinay Programmer (SQL): SSIS How to UPDATE instead of INSERT (UPSERT)oyenhttp://www.blogger.com/profile/00519133229541888933noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-7491929482503971187.post-80025655049784296062019-04-03T19:33:47.273+08:002019-04-03T19:33:47.273+08:00Hello all,can anyone please tell me from this post...Hello all,can anyone please tell me from this post that how can I simultaneously create and change the table without disturbing the current process in the image titled 'Bulk Update in <a href="https://zappysys.com/products/ssis-powerpack/ssis-upsert-destination/" rel="nofollow">SSIS using Upsert Destination</a>.Is that possible by any means?Thanks.James Zicrovhttps://www.blogger.com/profile/00094356083987556970noreply@blogger.comtag:blogger.com,1999:blog-7491929482503971187.post-1682072884774985502019-03-20T19:38:00.030+08:002019-03-20T19:38:00.030+08:00This comment has been removed by the author.James Zicrovhttps://www.blogger.com/profile/00094356083987556970noreply@blogger.comtag:blogger.com,1999:blog-7491929482503971187.post-43631201375434269412016-07-29T21:06:23.865+08:002016-07-29T21:06:23.865+08:00Very useful post. This is my first time i visit he...Very useful post. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. Really its great article. Keep it up. <a href="http://adlockmedia.com/" rel="nofollow">cpa network</a><br />historypakhttps://www.blogger.com/profile/12429820414620086221noreply@blogger.comtag:blogger.com,1999:blog-7491929482503971187.post-68807883524190602462012-05-24T23:22:13.272+08:002012-05-24T23:22:13.272+08:00I can't find the way to mapp input cols to par...I can't find the way to mapp input cols to parameters. From the lookup object I get 2 columns so for the match output I set the OLE DB Command with "<b>UPDATE dbo.MyTable SET MyCol2 = ? WHERE MyCol1 = ?</b>". In this case MyCol1 is my ID but there isn't any mapping where it should so UPDATE statement is not working at all.Hernán_https://www.blogger.com/profile/16874568422657913886noreply@blogger.comtag:blogger.com,1999:blog-7491929482503971187.post-82894693249098879552011-10-06T09:44:27.450+08:002011-10-06T09:44:27.450+08:00Hi, ashuthinks,
You only need the update query if...Hi, ashuthinks,<br /><br />You only need the update query if you want to update existing data. If all you want is to insert missing data, then you don't need it at all.oyenhttps://www.blogger.com/profile/00519133229541888933noreply@blogger.comtag:blogger.com,1999:blog-7491929482503971187.post-85767408168768554482011-10-05T18:10:21.874+08:002011-10-05T18:10:21.874+08:00HI AFTER LOOKUP I HAVE USED OLEDB DESTINATION AND ...HI AFTER LOOKUP I HAVE USED OLEDB DESTINATION AND DID MAPPING LIKE BELOW http://social.microsoft.com/Forums/getfile/19170/<br /><br />IS THERE ANY NEED OF UPDATE QUERY ???ashuthinkshttps://www.blogger.com/profile/03734815865428231212noreply@blogger.comtag:blogger.com,1999:blog-7491929482503971187.post-6563343530201181392011-09-22T06:42:38.997+08:002011-09-22T06:42:38.997+08:00How can I put names to the parameters?How can I put names to the parameters?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7491929482503971187.post-23917641402339282792010-08-14T03:47:38.682+08:002010-08-14T03:47:38.682+08:00Ack!
UPDATE dbo.MyTable SET
Column1 = ?
...Ack!<br /><br /> UPDATE dbo.MyTable <b>SET</b><br /> Column1 = ?<br /> ,Column2 = ?<br /> ,Column3 = ?<br /> WHERE ID= ?Jinyounghttps://www.blogger.com/profile/03888098265470029495noreply@blogger.com