.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

Custom Task poeprties values persistance issue?

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


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

View Complete Post

More Related Resource Links

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 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

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?



SortPropertiesAttribute for Custom SSIS task issue?



I have decorated internal node class with


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



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

How to assign values to workflow task person or group custom field?

Using visual studio 2008, in createTask_MethodInvoking, I have the following code. RequestFields has the values from the InfoPath form. ApprovingPersons is a person or group field, added to the task list by my custom task content type. I checked the task list associated with the workflow and I see the custom field.

SPUser user;
SPFieldUserValueCollection fuvc = new SPFieldUserValueCollection();
foreach (Contact person in RequestFields.Persons)
      user = workflowProperties.Web.EnsureUser(person.LoginName);
      fuvc.Add(new SPFieldUserValue(workflowProperties.Web, user.ID, user.Name));

// this is the line causing problem, I believe
PreApprovalTask_TaskProperties.ExtendedProperties["ApprovingPersons"] = fuvc;

I got the following error message:

at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] argument



Setting Task Field Values in Custom .aspx Edit Form and accessing through ExtendedProperties


Since we're using WSS 3.0 and not MOSS 2007, we have to create and use ASP forms for any custom Workflow Task Edit pages instead of being able to use InfoPath forms (which would be nice...maybe some day we'll step up to MOSS). The custom Workflow Edit Pages are used for custom Task Content Types that we create so that our Workflow Tasks can have additional fields beyond the standard Workflow Task fields. Once you've collected the values for the Task fields from the user on the ASP Workflow Task Edit form, the typical procedure is to create a hashtable and fill the hashtable with key/value pairs that represent the names of your Task fields and their associated values, as such:

// This function is called when the user clicks the Save/Submit button
// on the Custom Task Edit ASP form
public void btnSubmit_Click(object sender, EventArgs e)
  // Create a hashtable that will be used to update the values of task fields
  Hashtable taskHash = new Hashtable();
  // For each field, create two values in the hashtable. If the field name 
  // matches a field in the Task content type, the field name will not be 
  // searchable as a key within the ExtendedProperties hashtable. So 
  // create a second field that is a duplicate of the first but having a 
  // name that doesn't exactly match an existing field in the Task 
  // content type. That way it will be a searchable ke

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.



How do you create a custom BDC data field that allows for multiple selected values?

I need help creating a custom data field using the BDC column as a base.  We need to allow for multiple selected values instead of just a single one.  I can't find anything on the net which shows how to do this.

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)

Giving Custom Colors for Graph values in SSRS2000


Hi All,

        I am stuck here with the color for the graph values i want to give custom colors for each values present in the graph, is it possible in SSRS2000.

 Problem Statement : Suppose if i want to display two data fields as bar graph

                                 Data Fields are : Vegetable Count and Fruits Count

                                          I want Vegetable count to be in Blue Colour and I want Fruits count to be in green colour.

Any help would be appreciated.

Thanks in advance.

Anish Shenoy

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?

How to detect that a Data Flow Task has failed (from inside a custom componet)

Hi, in the PostExecute Method of a custom component i would like to check if the Data Flow Task has been failed. Is that possible? Also it would be great to be able to check if this custom component already got all data or has been marked as "green".  Thanks, Dennis

"Mixed mode assembly is built against version 'v2.0.50727'.... " issue and use custom config file

Hi, My Winform applilcation has used Microsoft.SqlServer.Management.Common namespace(assembly :Microsoft.Sqlserver.smo.dll/Microsoft.Sqlserver.ConnectionInfo.dll) and developed in .NET 4.0. Problem:Application is throw an exception when it tries to use above assembly reference methods. Full error text is shown below, "Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information. " Error is resolved when we include "app.config" file with below code, <?xml version="1.0"?> <configuration> <startup useLegacyV2RuntimeActivationPolicy="true"> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/> </startup> </configuration> But, I need to keep configuration file as "renamed.config" and not to include app.config file as of the project requirement.I have set configuration file as "renamed.config" file using below code, //AppDomain.CurrentDomain.SetData("APP_CONFIG_FILE", "d:\\reanmed.config" ); I have also included <Startup> element in this "renamed.config" configuration file and removed the app.config file.But it raise me below error, it always expect app.config file with <Startup> element to resolve this iss

Calculated measures, calculated cells, and custom rollups issue

Hi,  I'm a little bit confused according to the purpose of Calculated measures, calculated cells, and custom rollups as they lead practically to the same goal, is there any differnce between those modes from a technical point of view. And for the last one, the custom roll up the question how to perform this, I need a walkthrough that lead me to undersand the way to set a custom roll up to a given dimesion, I visited microsoft site but the inforamtion that I have is poor, so is there any other source that exposes that as a step by step example? Thank youThe complexity resides in the simplicity
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