CPackage::LoadFromXML fails while Using SSIS Integrated Service

Jul 9 2009 5:54 AM

I have created a Web Application for importing CSV file into the Database using the SSIS Integration Service. I have installed the SQL Server 2005 and the Integrated Service on my machine. I have add reference of Microsoft.SQLServer.ManagedDTS in the web appication.  I have created a package and call in my Web Application using following code.
Microsoft.SqlServer.Dts.Runtime.DTSExecResult local_DTSExecResult;
        Application application = new Application();
        Package pkgProduct = application.LoadPackage("D:\\CSV\\Package1.dtsx", null);
        local_DTSExecResult = pkgProduct.Execute();
       
        if (local_DTSExecResult == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure)
        {
            foreach (Microsoft.SqlServer.Dts.Runtime.DtsError local_DtsError in pkgProduct.Errors)
            {
                Response.Write(local_DtsError.Description);
            }
        }    
       
the code work fine in the visual studio environment and the CSV is imported in the database successfully.
When i double click the Package1.dtsx then also it import the CSV file in the database,
but when i publish the site and run from my localhost it gives me error.
            The package failed to load due to error 0xC0011008 "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.". This occurs when CPackage::LoadFromXML fails.
Pleas help to sort this problem. Thanks in Advance