I get this error when I try to run a(ny) BAM_NA DTS/SSIS package.
The machine has BizTalk 2006 and SQL Server 2005 installed locally.
I have used "bm deploy-all" to deploy my BAM definition (this also
creates BAM_DM and BAM_AN DTS packages). When I try to run the BAM_AN
packages they all give this error.
So I ex****ted a package to file and looked at the script with VS.NET.
The Server object that was being instantiated looked like a SMO
object: Connect was being called and it had a Databases property.
So I installed SQL Server 2005 Feature pack and manually confirmed
that the microsoft.sqlserver.smo.dll was on my machine. Then I
restarted the SQL Server service (services mmc) and tried again. Alas,
same error.
Now I'm running out of options...
Could anyone please help me.
Thanx,
Marc Jacobi
