Do not use on any
shared computer
August 29, 2008 10:07pm pdt
 
[x]
Attachment Details

SSIS loadPackage

Tags: Biztalk C# SSIS
We have a Biztalk orchestration that calls an SSIS package, via a .net C# utility class The package is deployed in SQL server and runs fine most of the time. eg: you could continuosuly run the package from the Biztalk orchestration, which is invoked from a GUI. But what is strange is after running for a few times. u pause and come back after say a half hour and then run the package again via the orchestration and we get this error
-----------------------------------
Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.
--------------------------
once this happens, if we restart the biztalk service it works fine.
The place where it fails is
myPackage = integrationServices.LoadFromSqlServer(packageName, ssisServer, ssisUserId, ssisPassword, null);
-------------
All params being passed are correct and here is where the error happens as described above
The above snippet is in a c# utility class whiich is called from a Biztalk orchestration.

Any suggestions would be more than welcome

Please advise
Thanks in advance
Rajesh

Start your free trial to view this solution
Question Stats
Zone: Web Development
Question Asked By: rjvittal
Question Asked On: 03.31.2008
Participating Experts: 1
Points: 500
Views: 0
Translate:
Loading Advertisement...
 
[+][-]Author Comment by rjvittal
Author Comment by rjvittal:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Author Comment by rjvittal
Author Comment by rjvittal:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by PedroCGD

Rank: Master

Expert Comment by PedroCGD:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Author Comment by rjvittal
Author Comment by rjvittal:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
20080723-EE-VQP-34 / EE_QW_2_20070628