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

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

SortPropertiesAttribute for Custom SSIS task issue?

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server


I have decorated internal node class with


SortProperties(new string[] {"Name","DisplayText","Description" })]



View Complete Post

More Related Resource Links

Custom SSIS task inteface building issue


Hi all,

I'm tying to use the class foundation that SSIS provides to build interfaces like those of built in tasks

I tried to follow this tutorial


I added a Display text property to my task in order to display it when the task is fired, every thing goes well

except three  issues

1. The display value is not persisted( when I change it from the GUI inteface. It is only persisted if it is updated from the BIDS properties grid)

2. The buttons OK, Cancel, Help are not displayed at the buttom of the interface such in the rest of built in tasks, should I add them programmatically and  if it is the case how  do I to persist properties values when user clicks OK.

3. Some cells in the properties grid shows a combo box like those configuring  connection managers. For example one can expand the combo box and selects <New Connection...>  

Or when one property grid cell get the focus then ellipses button appears when he/she clicks then the OpenDialogResult opens up

Or if one selects some properties grid cells then the properties grid changes by

Microsoft.SqlServer.Dts and related assemblies to develop custom ssis task are missing

Hi All, I tried to develop a simple ssis task but the problem that I can't refer the necessary assemblies like Microsoft.SqlServer.Dts.Runtime And also Microsoft.SqlServer.DTSPipelineWrap Microsoft.Sqlserver.DTSRuntimeWrap Microsoft.Sqlserver.ManagedDTS Microsoft.SqlServer.PipelineHost What is certan that they aren't installed within the GAC in my case, so where could I find them? I have SQL server 2008 entrprise edition Other question, should I use Microsoft.SqlServer.Dts.Design and  Microsoft.SqlServer.ManagedDTS which are missed too, or they are part of the 2005 version only Thank you   The complexity resides in the simplicity

SSIS custom task calling web services response errors.

Hi             I have some code within a .Net 3.5 library which call a web service.  The web proxy class was created using WSDL command line tool.  Also the library is wrapped within .Net console, for testing the library works, and SQL Server Integration Services custom task, which is intended to use so that it will be part of the ETL process.    If I run the SSIS custom task and console application on a Windows XP everything works as expected.    However I am currently facing a problem where the response from the web service is not being interpreted correctly when running within the SSIS custom task on windows server 2008 R2, whereas the response from the web service is correctly understood when running the library within console application on the same server.    Has anyone come across this problem before or know any issues with SSIS and .Net libraries which call web services?

Custom Task Icon issue

Hi I'm developping a custom SSIS task I added an icon to the project I set the build action to embedded resource I also added the dts attribute icon related element as [ DtsTask(.....   IconResource = "Mynamespace.iconfilename.ico", .......   But the icon doesn't appear when I drag the task in the design surface, once I want to test it, so what's wrong Thanks   The complexity resides in the simplicity

Custom Task Type Name Issue


I am developing a custom task in VB.NET using VS2008.

My Project sets the Assembly Name to MyCompany.Dts.Tasks.MyTask, the Root Namespace is MyCompany.Dts.Tasks

All my classes define the namespace as MyCompany.Dts.Tasks

When I compile the class library, and view the component in the "Choose Toolbox Items" dialog in VS, the Type Name is:


Where is this extra decoration coming from?



Custom Task poeprties values persistance issue?



This is the case: I wrote a simple task that has one property Display text, it displays text once the package if fired. This built in task has an interface. The user should normally enter the display text property value and click OK then that value is persisted. If the user interface is closed then reopened then this value should be held as normally.

Should I write custom code to cache this value and then write a code to persist it or this is done through a provided way by the SSIS, I asked this question before and CosyRock oriented me to some code samples which I followed with a great intention but until now I couldn't figure out how to persist properties values.

In this case I use the IDtsTaskUI interface to tie the task to its interface and you know there isn't an Edit method such is IDtsComponent interface so I can imlement it to commit or rollback values?

 Thank you

The complexity resides in the simplicity

Custom task user interface issue?



I have designed a custom task with a general view that holds a properties grid in a general view node. I have developed a custom editor to help user set the value of that property, Of Corse, I point my property to use that editor in design time using System.ComponentModel.EditorAttibuteClass . The editor appears as a modal dialog box. 

The issue is that when I put the Dock property of the properties grid to Fill then the ellipsis button doesn't appear but if I set the dock property to None then it appears (I mean the ellipsis button) and then I can click it to configure the property though that Modal dialog box.

So the question should I do additional steps to avoid this anomally

Thank you


The complexity resides in the simplicity

trying to use custom assembly with script task in SSIS 2008 - can't find correct version of GACUtil


I am trying to use a custom assembly (compiled with VS 2005 framework 2.0) with SSIS 2008.  I understand that I need to put this Assembly in the GAC.  I initially attempted to do this using the GACUtil, but I apparently only have version 1.1 of GACUtil intalled on my development PC.  Shouldn't version 2.0 have been installed as part of VS 2005? 

So I then tried simply copying the dll into the GAC folder using windows explorer.  Well, the dll is now visibly in the GAC folder, but I cannot see it from either VS 2005 or BIDS 2008.  Does that mean I do need to use GACUtil 2.0 or higher to install the DLL into the GAC?  If so, is there any place on the Web that I can download it?

SSIS Custom Destination Component colum mapping issue


Hi ,

I am facing the below issue.

I am developed a custom destination component.I have custom UI also to set some properties.

Once i save the component and do the mapping in the Show Advance Editor Colum Mapping.This is working fine.

The problem starts Next.If I edit the component and do some changes  and say Ok ,In the output colum mapping all the mappings which i have already been set is getting removed.Then again i have to remap it.Ho to keep the existing mapping if we edit the component?

need help to solve this issue.

ssis deployment issue - Unable to load custom dll - due to change in Sql server installation


Hello all

I had a strange issue in testing my package, after it was deployed to a Test server.

The details of the server

Sql 2005 is installed, in the D:\ drive

I have used a package, where i use a custom DLL to read values. Hence, i added that DLL to the GAC. I was in the assumption that this should complete my proceess of deploying this package.


However once i executed the package, i got an error - Could not load the Helper object.

Unable to CAST "system.object"  to namaspace.class.Helper.


I reviewed the setting on my macihine, since as part of development inorder to reference the dll i added this to the C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies location so that i can reference this from BIDS. I checked that location in my test server, i was not present. This location was present in the D: drive ( i assume this was present since i installed my complete SQL Server in the D:\ ). I copied the dLL in that location and added it to GAC from that location. My package still failed with the same error.


To resolve this issue, i created the same path in the C:\ folder as C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies

assemblies was newly created in C: and i added the dll to GAC from there. Now my package worked.


SSIS: return list of custom objects after a Script Task


I'm having problems returning a list of self-created .NET objects to a SSIS object variable.

In my SSIS Script Task I'm calling:

Dim fileList As List(Of FileNameEntityDate) = read.getFileNameEntityDate

Directly after this call, It is populated as the size of the List != 0:


Now, I'm trying to return that list to SSIS using variables:

Dts.Variables("oFilenameEntityDate").Value = fileList

oFilenameEntityDate is defined in SSIS as being an Object.
It is also placed in my 'Script Task' under 'ReadWriteVariables'.

When I watch that variable, it seems empty:

- User::oFilenameEntityDate
	Type	__ComObject	
	Value	System.__ComObject	

What should I do to get this working? Thanks!!

Custom controls and ViewState management issue



I want to know that when we create custom controls, then is there State Management through ViewState done automatically or we have to handle it explicitely ?Since i have created Custom Controls that is behaving as if it is not maintaining its state on PostBack.

Create a Outlook Task from Custom WebPart in Code



I have a requirement to create a Outlook Task , from a custom webpart through code .

Is this possible?

has any body tried this , if yes can you please give me an insight on how to acheive it.

Some sample Code would be highly appreciated.



Custom Search issue with freetext


Hi All,

My Environment : MOSS 2007 (sp2) with SQL Server 2005

I have a custom search webpart which uses FullTextSqlQuery to fetch the results from Index. I have a some keywords and a free text boxt to build the search query. Poeple enter their query by selecting the keywords and enter some free text into the text box.

Issue : When any PDF document (Not tested with .Doc) is searched using custom webpart with the numbers like "2,0233.21" I do not get any results returned even though the results are returned using the SharePoint out of box full text search. But when I search the content like "2+0233+21" I get results both in Out of box and in custom search webpart.

Requirement: The Custom search should be able to find the document when numbers like "2,0233.21" are entered. It should work exactly like the out of box search.

Thanks in advance for your suggestions.



Video: Microsoft Office 2010 UI Customization (Custom Task Panes)

Learn about building custom task panes, one of the most widely used ways to enhance end-user productivity in Office. Developers can use custom task to bring the end user information and data from virtually any source, whether via WCF, Web services, BCS, or SharePoint Lists. (Length: 5:34)

Find and replacement SSIS Custom component issues

Hi All, I developed one custom component in SSIS  Find and Replacement I register the dll and copy and paste in to Pipleline component. but it's not visible in the Toolbox while choose Items Please suggest why it's not comming.. using   System; using   System.Collections.Generic; using   System.Linq; using   System.Text; using   Microsoft.SqlServer.Dts.Pipeline; using   Microsoft.SqlServer.Dts.Design; using   Microsoft.SqlServer.Dts.Runtime.Wrapper; using   Microsoft.SqlServer.Dts.Pipeline.Wrapper; using   System.Data.OleDb; using   System.Data.SqlClient; using   System.Windows.Forms; using   System.Runtime.InteropServices; using   System.Data; using   System.Collections; using   Microsoft.SqlServer.Dts.Runtime; using   Microsoft.SqlServer.Server; namespace   FindAndReplace { [ ComVisible(true)] [ DtsPipelineComponent ( DisplayName = "Find and Replace", Description = "Finding Find and replace", IconResource = "Microsoft.Samples.SqlServer.Dts.Find and Replace.ico", ComponentType = ComponentType.Transform )]   class FindAndReplace :PipelineComponent {   #region   ProvideComponentProperties   /// <summary>   /// </summary>   public ove

Execute Package Task password issue

I have a parent and child package. Both are stored on the file system and both are password protected. My problem is that when I call the child package from the parent using execute package task, I get prompted for the child package's password. Now the PackagePassword property of the Execute Package Task is supposed to take care of that. But for some reason the password stored in the Execute Package Task is not getting passed to the child package.  I've re-entered the PackPassword property several times, but it did not help.  I even tried loading the password from a config file, but that did not make any difference.  Can anyone help?
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