TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Sanjay Atpadkar
NA
19
0
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
Reply
Answers (
0
)
How can the public generate and view Reports using SQL Sever Reporting Services?
Word Document Opening : Editing from .Net c# without loosing control