Re: Bam.xls

If you are not using Real Time Aggregation, connect to the "Integration
Services" using the SQL Server Management Studio and look under the Stored
Packages/MSDB folder. The packages should be there. You can either run it
manually from there or create a SQL Agent job to schedule the package.


Paul Wu
http://biztalkdev.com/blogs/paulwu/


-------------------------------------------------------------

"SalamElias" <eliassal@xxxxxxxxxxxxx> wrote in message
news:9039B18A-DC27-46AE-93F2-C5141BBC75B3@xxxxxxxxxxxxxxxx
Ok, thanks, the add-in was not in the default excel file, I needed toadd
the
addin. I continued working with the existing excel file, launched the exe
and
data were generated which I was able to query in the Bam portal.

However, before the end of the tutorial, it is indicated the following :

"To view the OLAP cubes (if you created them), you must manually run the
DTS packages that have been dynamically created.
For more information about running DTS packages, see SQL Server Books
Online."

I checked my 2005 sql server, there is no DTSs created? Also, I connected
to
Analysis services, I was astonished that there was no cubes are created.
There is only one cube for the preceding tutorial I had done the
BamEndToEnd.

So where does data come from in the BAM portal ? Does BAM query directly
the
BAM databases

Thanks


"Richard Seroter" wrote:

In BizTalk 2006, there's no "default" BAM template anymore. If you've
installed the BAM tools, when you open Excel you should have a BAM
add-in,
and a menu. From that menu item you can create new BAM Activities.

If you're working with BizTalk 2004, then a default BAM template should
exist.
--
Richard Seroter
http://seroter.wordpress.com


"SalamElias" wrote:

Hi, I understood from sdk example "The BAM API sample" that there
should be a
file called BAM.xls in the "installation path\tracking" directory. I
don't
have this file in this directory, also I checked the BTS CD, it was not
there
as well.

Where can I find a clean copy of theis file.

Thanks


.

Relevant Pages

  • RE: Bam.xls
    ... "Richard Seroter" wrote: ... Aggregation" button in the BAM toolbar), ... "To view the OLAP cubes, ... For more information about running DTS packages, see SQL Server Books ...
    (microsoft.public.biztalk.general)
  • Re: Upgrading DTS to SSIS
    ... You cannot run packages outside of BI Development Studio on a client computer that does not have Integration Services installed, and the terms of your SQL Server 2005 licensing may not permit you to install Integration Services on additional computers. ... SQL Server 2005 Integration Services (SSIS) is now a server component and is not redistributable to client computers in the same manner that the components required for SQL Server 2000 Data Transformation Services (DTS) were redistributable. ...
    (microsoft.public.sqlserver.dts)
  • Re: Editing DTS Packages on a 64-bit SQL Server 2005 installation
    ... The tips for running 32-SSIS packages can be extended to running 32-bit DTS ... store your DTS packages in a 64-bit SQL Server database. ... have tried installing the Web download it says to install but then I get ...
    (microsoft.public.sqlserver.setup)
  • DTS package permissions errors when transferring pkgs btw servers
    ... I have a DTS problem that's been giving me fits and am hoping someone here ... configuration & operate similarly to the source machine. ... Server service and SQL Server Agent logins, (they use mixed mode security - ... There are 40 odd DTS packages, which I transferred (by using Save As for the ...
    (microsoft.public.sqlserver.dts)
  • SQL Server 2005 Workgroup Edition und SSIS
    ... The Business Intelligence Development Studio option installs the Integration ... and you cannot run packages outside of BI Development Studio. ... Mit dem SQL Server 2005 Workgroup Edition werden Teile der Integration ...
    (microsoft.public.de.sqlserver)