Solved

Error debuggins SSIS package

Posted on 2014-02-10
6
1,085 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Get the latest status 8 30
Need some help to cast ntext to nvarchar SQL 2000 7 31
SQL - Copy data from one database to another 6 19
Update a text value in another table 10 39
My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

776 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