Solved

Error debuggins SSIS package

Posted on 2014-02-10
6
1,067 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
  • 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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What is format f12.8 for a CSV file 6 41
SQL Query Syntax Join 4 34
SQL Field Length for Email Address 3 17
Replace Dates in query 14 18
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

896 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now