custom SSIS control flow Task not showing in Toolbox
Hi, I have been following below links for developing custom task http://msdn.microsoft.com/en-us/library/ms403356.aspx http://blogs.msdn.com/b/mattm/archive/2008/07/18/creating-a-custom-task-with-a-default-ui.aspx I am succeeded in adding the DLLs in GAC as well as in Tasks folder of the SQlServer. However I cannot see my task in the toolbox. I also tried to choose Items from dialog box but my Task is also not showing up there. Below are the details that i have done so far I am using VSTS 2010The targeted Framework version is 3.5. Reason behind choosing this is gacutil.exe doesnot support Framework 4.0I can see my UI file in GAC_32 and CS file in GAC_MSIL. I can also see my CS file in C:\Program Files\Microsoft SQL Server\100\DTS\Tasks folder. As suggested in above links I didnot add my UI dll to this folder.I am looking for the Task using VSTS 2008. Reason is I was not able to see the SSIS Control Flow Task dialog (from where we can choose the items) in VSTS 2010. Already also tried to restarting the VSTS 2008 after adding my Task in GAC & Tasks folder. But it didnt help. How can i solve this problem? Any help will be appreciated. Thank you Mr myName
May 30th, 2012 4:06am

I have this in the build event of my visual studio project (this will drop the dll's in the right places): If you want to test it in a package you must (re)start bids/visual studio because the gac is cached on startup. When you open a SSIS project in Visual Studio/Bids, right click the toolbox and choose "Choose Items...". After this Visual Studio will be busy for a couple of seconds! When the Choose Toolbox Items window appears, go to the SSIS Control Flow Items and search for the newly installed File-in-use Task and select it. Click ok to finish. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
Free Windows Admin Tool Kit Click here and download it now
May 30th, 2012 4:38am

Hi, I have already configured the post build event to set this DLL to correct folder. Below is the command that i used in post-build event The post-build event for .CS file project "C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\gacutil.exe" -u "$(TargetName)" "C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\gacutil.exe" -i "$(TargetPath)" copy "$(TargetPath)" "C:\Program Files\Microsoft SQL Server\100\DTS\Tasks\" The post-build event for UI project "C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\gacutil.exe" -u "$(TargetName)" "C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\gacutil.exe" -i "$(TargetPath)" Still I cannot see the task in the Choose Items dialog for SSIS Control Flow Items.Mr myName
May 30th, 2012 4:59am

And if you browse to the dll?Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
Free Windows Admin Tool Kit Click here and download it now
May 30th, 2012 5:06am

Hi, Unfortunately there is no Browsing facility in "SSIS Control Flow Items" tab of Choose Items dialog. But that triggered onething in my mind. I checked the path of all available Control Flow Tasks and it was pointing to Program FIles (86) and not Program Files. and in my post-build events i was referring to Program Files folder. I changed it to "C:\Program Files (86)\Microsoft SQL Server\100\DTS\Tasks\" and I got my DLL/Task. Thanks for your suggestion.Mr myName
May 30th, 2012 5:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics