BizTalk Features

Question

Hi.

I am installing BizTalk and I need BAM functionatily.

I read that it is necessary Microsoft SQL Server Data Transformation Services (DTS 2008) with SP1 or higher to run that functionality.

My question is: This is some feature of SQL or we have to install it on the BizTalk server?

Best Regards

Answer 1

Hi

This is a feature of SQL and it is required on BizTalk box for the configuration of BAM services and portal. The SQL tools are also used while deploying BAM Activities using bm.exe.

I would suggest you to refer BAM:Survial Guide technet wiki, This has some good links for the installationa and configuration issues while BAM installation.

---

HTH,
Naushad Alam

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
alamnaushad.wordpress.com |

My new TechNet Wiki "BizTalk Server: Performance Tuning & Optimization"

Answer 2

Hi Carlos,

Please refer to link below that might help you.

http://sandroaspbiztalkblog.wordpress.com/2011/08/31/biztalk-2010-bam-tools-configuration-error-microsoft-sql-server-data-transformation-services-dts-2008-with-sp1-or-higher-for-bam-archiving-is-not-installed-on-the-local-machine/

---

Thanks With Regards,
Shailesh Kawade
MCTS BizTalk Server
Please Mark This As Answer If This Helps You.
http://shaileshbiztalk.blogspot.com/

Answer 3

Sorry Naushad but I have a doubt about your answer.

You say that is a feature of SQL and it it required on BizTalk box. By that are tou saying that I need to install it also on BizTalk server through some kind of exe. file?

Sorry but it is the first time that I am installing it.

Best Regards

Carlos Almeida

Answer 4

Thkz a lot Shailesh.

That totally answered my question.

Best Regards

Carlos Almeida

Answer 5

Hi

Yes, You would need to install SQL Client tools by running SQL Server setup Wizard.

Check below blog post by sandro for more details

http://sandroaspbiztalkblog.wordpress.com/2011/08/31/biztalk-2010-bam-tools-configuration-error-microsoft-sql-server-data-transformation-services-dts-2008-with-sp1-or-higher-for-bam-archiving-is-not-installed-on-the-local-machine/

http://social.msdn.microsoft.com/Forums/da-DK/biztalkgeneral/thread/2c119f21-91ec-4a35-bfc6-ea678e011873

---

HTH,
Naushad Alam

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
alamnaushad.wordpress.com |

My new TechNet Wiki "BizTalk Server: Performance Tuning & Optimization"

Answer 6

Yes DTS will be part of SQL Server, However when you use BAM all aggragations and data pulling mechanisms of Biztalk uses those features

http://sandroaspbiztalkblog.wordpress.com/2011/08/31/biztalk-2010-bam-tools-configuration-error-microsoft-sql-server-data-transformation-services-dts-2008-with-sp1-or-higher-for-bam-archiving-is-not-installed-on-the-local-machine/

http://msdn.microsoft.com/en-us/library/ee267675%28v=bts.10%29.aspx

---

If this post answers your question, please mark it as such. If this post is helpful, click 'Vote as helpful'.