.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

package not loading data

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server

 Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.

I tried to run as adminstrator. package runs and warning disappears but not showing how many rows passed through pipeline. thnx in advance


[SSIS.Pipeline] Warning: The output column "CustomerID" (98) on output "Lookup Match Output" (49) and component "Lookup" (47) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

View Complete Post

More Related Resource Links

XML Source (Data is not loading to Destination ,Package Runs sucessful)

Hi First I run execute SQL Task SELECT TOP(10) [Message],opportunity_Id  FROM SBP FOR XML PATH ('GS_Opportunity'), ROOT('GSOpportunities') That will make 10 different file into single file then i have assigned this output to variable and it will output as XML Now I put Data flow task ,in it I put XML task and in source i have put XML Data From Variable and I select XSD file location,now XML task is showing me different source table and i have selected appropriate destination table but when i run this package it will not transform data from source to destination,Can you suggest me what is the problem i try to put data viewer it is not transforming any data  while insted of if i select direct file location instead of variable it is running good    

To prevent possible data loss before loading the designer, the following errors must be resolved: In

To prevent possible data loss before loading the designer, the following errors must be resolved: The class Form can be designed, but is not the first class in the file. Visual Studio requires that designers use the first class in the file. Move the class code so that it is the first class in the file and try loading the designer again. Instances of this error (1) 1. Hide Call Stack at System.ComponentModel.Design.Serialization.CodeDomDesignerLoader.EnsureDocument(IDesignerSerializationManager manager) at System.ComponentModel.Design.Serialization.CodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager manager) at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager serializationManager) at System.ComponentModel.Design.Serialization.BasicDesignerLoader.BeginLoad(IDesignerLoaderHost host) Thanks! This post is from Matthew Cenance.

Data loading from text file

Hi, I am loading the data from a flat file into a sql table. The values in one of the column have spaces at the end of the value. I want to remove those spaces and load into the table. I am thinking of using derived column and use rtrim on that column, how can I use that as an expression. Thanks.sqldev

What does strategy exist to deploy SSIS package and my own data flow components into a enterparise s

I created a SSIS package and several data flow componenets for this package.    What does strategy exist to deploy SSIS package and data flow components into a enterparise server?   Thanks in advance.

Configurable SSIS data transfer package

I have to create SSIS Pakage for importing data form a sql server to  another. And this SSIS data transfer package has to be configurable at run time for: - Database source connection - Database destination connection - Query to call from the source database - Table to insert in destination database And Also need to call this package from a stored procedure...

Loading Decimal Number From Excel into SQL Server 2005 using SSIS Package

If you have an excel spreadsheet that displays a number .02 (because it is formated) but internally it is stored as .2654329 and you want to load .2654329 how can you do that in the SSIS package?  When we load the spreadsheet it is loading .02.  Is there some kind of option in the SSIS package to tell the package to load the internal number?lcerni

Entity Framework POCO and WCF Data Service - Lazy-loading (expand?) related entities?

I've followed ScottGu article on creating an Entity Framework POCO classes for NerdDinners (right now there are only 2 classes, Dinner and RSVP. I then created a WCF Data Service class, which points to my EF class (NerdDinner), everything is working fine, except I can't lazy-load or expand related entities. For example, I want to get all load all the Dinners and their related RSVPs, something like this throw an error:var result = (from d in db.Dinners.Expand("RSVPs")                      select d);The error is a null reference error:at System.Data.Services.Serializers.SyndicationSerializer.WriteObjectProperties(IExpandedResult expanded, Object customObject, ResourceType resourceType, Uri absoluteUri, String relativeUri, SyndicationItem item, DictionaryContent content, EpmSourcePathSegment currentSourceRoot) at System.Data.Services.Serializers.SyndicationSerializer.WriteEntryElement(IExpandedResult expanded, Object element, ResourceType expectedType, Uri absoluteUri, String relativeUri, SyndicationItem target) ... ... ...Any idea why or what I need to do to load related contents?Thank you very much.

SSIS 2005 - XML Source no data loading to sql server database destination

Hello I am trying to load data from xml source to sql server destination, but the task executes with no data loaded to destination. i really appreciate any guidance in working and troubleshooting xml sources. Regards Harris

Error loading package

Hi there all... We've just started using SSIS packages, and everything seems to be going ok. I've recently set up a couple of jobs which just run an SSIS package every 5 minutes to collect data.These run fine 90% of the time, but intermittantly produce an error. When using a SSIS task in the job it simply reported"Could not load Package." I have changed these to use DTExec as I heard it gave more verbose execution results, and now I get an error like"Executed as user: NZ\SQLAdmin. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.1399.06 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  8:25:00 a.m.  Could not load package "\MSDB\RadiusBilling\Get_RADIUS_AuthLog" because of error 0x80040E37.  Description: Table/view either does not exist or contains errors.  Source: Microsoft SQL Native Client  Started:  8:25:00 a.m.  Finished: 8:25:00 a.m.  Elapsed:  0.047 seconds.  Process Exit Code 5.  The step failed." So far I have not been able to find anyone else with similar errors.Whenever the package executes it seems to run fine, so this seems to be an error just getting the package to execute in the first place, and as I said it only happens internittantly. The packages talk to a SQL2005 server using windows authentication (which I assume is inherited from the SQLAgent service user), as well as a MySQL

SSIS Package for Delta Data between Oracle and SQL Server


Hi all

I have BI Server and Tables and Data Populated using SSIS package.Now Data is ready in BI server.Next week Ihave to same excersize to filll the Data(DROP tables,CREATE table and Pump the Data)

Can any body give an idea how to create SSIS package which can pupm the Delta Data Oracle and SQL Server.


Thanks in advance




SSIS package failed for huge data



I have created one package to archive database. The target database is around 400 GB data and source db is around 300 GB. I have the Lookup control to check the duplicates in the data. The package is working fine with small amount of data. but it is giving the errors when I am trying to archive some 400 GB of data. Getting the below errors while running the package

1)Communication link failure
2)TCP Provider: An existing connection was forcibly closed by the remote host
3)OLE DB error occurred while populating internal cache. Check SQLCommand and SqlCommandParam properties
4)failed the pre-execute phase and returned error code 0xC020824E.

Appreciating your help in advance


dtutil won't deploy my package, "error 0xc0011008 loading from XML"


My package runs fine on the dev server with remote database.  SSMS deploys it to the msdb on the remote server, no problem, and it runs there with no problem.

But when I try to use dtutil from the command line to deploy it from a local .dtsx file to the remote server, I get the following message:

Microsoft (R) SQL Server SSIS Package Utilities

Version 9.00.1399.06 for 32-bit

Copyright (C) Microsoft Corp 1984-2004. All rights reserved.

Could not load package "foo.dtsx" because of error 0xC0011008.

Description: 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.


Dev system is using Visual Studio 2008 and BI Studio R2, database server is SQl 2008 but not R2.

I don't think that matters.

What might matter is that I have embedded spaces in the file names and package names - just renaming the file didn't seem to help, I think I'll try renaming the package, for lack of any better idea to try.

Or, could it be a 32bit/64bit thing?  I'm not sure who is 32bit and who is 64bits, actually.





things to consider when loading a lot of data to a big table


What are the considerations when loading a large amount of data to a large table?

One thing to consider are the indexes because they need to get rebuilt. One advice I had from someone is to drop the index, load the data, and finally re-create the index. Is this faster than loading without dropping the index?

What other considerations or concerns are there? What about data isolation? If it take a while to load the data, are the users locked out from selecting from the table? I would try to test this, but not sure how I can come up with large enough data set to play with.

About loading data onto a Mysql database

I am in the process of transferring data and contacts onto a Mysql database.
I have had some help and am trying to get a software solution.  

So main features would be to migrate large amounts of data and contacts every day. The migration would be done manually. 

Thanks for the help.

Create Excel file dynamically in SSIS package and fill it by resultset data returned by Stored proce


Hello Every One,

I have a scenario in which i am executing a Stored Procedure which returned a result set.

I want to create a Excel file [name_date_time] dynamically, and fill result set data into Excel file. And then finally sent Excel file to Specific user[Email ID].

Point is that the excel file should have unique name so i want to give name as name_date_time.

So every time when package run new file is created with unique name.


Can any one suggest me who to create Excel file and fill result set data into Excel file.

And then finally send that Excel file ?







Loading data from SQL 2008 to AS400


Using SSIS I am trying to load data from a table in SQL server 2008 to AS/400 file, like we have in DTS called "Other Connection" I do'nt see such task in SSIS. I created ODBC DSN to connect to AS/400. Please let me know what task I should use to load data from SQL server 2008 to AS/400. Thanks.


Loading Data into Datawarehouse(SSIS)


I am Beginner to SSIS, but this question is all about Data warehousing.

When I load the data to dimensions Do I need to have constraints off(referential integrity).

Is there any best practices before & After loading data into DW on SSIS ?



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend