Hi

I am using BizTalk Server 2004. My application uses the BAM feature too. I
have to archive some of the data in the BAMPrimaryImport. As per MSDN
http://msdn.microsoft.com/library/de...admin_rgbi.asp,
I used the BAM_DM_<activityname> dts package, it does archive the data but
creates the tables in the same BAMPrimaryImport database rather than
BAMArchive.

I have checked the bamconfiguration xml file as well...nothing is wrong with
that.

Any help will be appreciated.

regards
yashrah.

Is it using a datapump task to copyout data to an archived table? If so, you
should be able to change the connection for the datapump destination, so
that the archived data, goes to a different database.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Yashrah [Xavor]" <YashrahXavor (AT) discussions (DOT) microsoft.com> wrote

Hi

I am using BizTalk Server 2004. My application uses the BAM feature too. I
have to archive some of the data in the BAMPrimaryImport. As per MSDN
http://msdn.microsoft.com/library/de...admin_rgbi.asp,
I used the BAM_DM_<activityname> dts package, it does archive the data but
creates the tables in the same BAMPrimaryImport database rather than
BAMArchive.

I have checked the bamconfiguration xml file as well...nothing is wrong with
that.

Any help will be appreciated.

regards
yashrah.

And to show you an example of what Vyas is talking about and doing it dynamagically


Changing the DataPump Source and Destination Tables
(http://www.sqldts.com/default.aspx?213)


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Narayana Vyas Kondreddi" <answer_me (AT) hotmail (DOT) com> wrote