tag:blogger.com,1999:blog-1714283384790610704.post5414769297843055700..comments2023-12-01T12:13:25.623-06:00Comments on Lane's Tech Blog: Utilizing Transactions in SSIS to Rollback After a Failed ImportLanehttp://www.blogger.com/profile/05548461086853951131noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1714283384790610704.post-89462529410099999602014-05-29T10:18:14.667-05:002014-05-29T10:18:14.667-05:00Ah, good question. Generally speaking, you just n...Ah, good question. Generally speaking, you just need to have the database ports open: the DTC communicates with the local database driver for your remote database server. This means that, if you've got the ports open for database communication, you should be set.Lanehttps://www.blogger.com/profile/05548461086853951131noreply@blogger.comtag:blogger.com,1999:blog-1714283384790610704.post-55471311221756814012014-05-29T10:08:05.136-05:002014-05-29T10:08:05.136-05:00what about config firewall, we have to open ports ...what about config firewall, we have to open ports in 2 servers, right?<br />Do we need domain account or any specific account exist in both servers?ChinhPLQhttps://www.blogger.com/profile/08321723194244872680noreply@blogger.com