I have decorated internal node class with
View Complete Post
View Complete Post
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
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
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?
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?
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
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?
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
need help to solve this issue.
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
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.
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:
What should I do to get this working? Thanks!!
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.
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.
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
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.