Solved

Error debuggins SSIS package

Posted on 2014-02-10
6
1,108 Views
Last Modified: 2016-02-10
I have created an SSIS package which was built successfullt, but when I tried to start debuggin , I got the following error: "Failed to start project. Error starting debugging. (Micrsoft.DataTransformationServices.VsIntegration)"

Nothing else was displayed, no further explanation. The only other thing I found was in the Application Event Viewer:

"A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 21276, committed (KB): 42148, memory utilization: 50%%."

Can anyone help me to further diagnose this issue?
0
Comment
Question by:YZlat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 5

Accepted Solution

by:
dannygonzalez09 earned 500 total points
ID: 39847615
If you haven't tried this already... Save your package, close the project, then exit BIDS. Open it up again and re-run to see if that helps.
0
 
LVL 35

Author Comment

by:YZlat
ID: 39847929
I tried that and it ran! This time it was running for a while and when it was done, it highlighted the items in red and did not transfer any rows. No explanation again. What can I do now?
0
 
LVL 5

Expert Comment

by:dannygonzalez09
ID: 39847939
that means you have an error... look at the progress tab for error logs
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 35

Author Comment

by:YZlat
ID: 39848514
That's what I found

[My Data SQL Server Destination [16]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E14  Description: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".".
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E14  Description: "The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.".
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E14  Description: "The Bulk Insert operation of SQL Server Destination has timed out. Please consider increasing the value of Timeout property on the SQL Server Destination in the dataflow.".

I do not understand why does it mention linked server at all. I had no linked server setup to begin with.

I am gettign data from Oracle database into SQL Server. For oralce database there is a tns entry in tnsnames.ora file. And destination SQL Server is on the same machine as the package runing on. Why linked server?
0
 
LVL 35

Author Comment

by:YZlat
ID: 39848745
OK, looks like I fixed the problem by modifying destination from "SQL Server Destination" to "OLE DB Destination". Now it works
0
 
LVL 5

Expert Comment

by:dannygonzalez09
ID: 39850422
i wonder how that solved the error, but glad it worked out for you
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question