assume our DLL name is: TestTask.dll
now follow the below 3 steps: [see below Image for help]
- install the dll in GAC
- copy the dll to SSIS DTS location
- Test the Task is working
now the details :
- install the dll in GAC (see image)
- find the GACUtill in the "Microsoft SDKs" folder... in my case, it is in "C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\gacutil.exe"
- if you don't have it installed .. you can download it from here (click here).
- open Command Prompt as Administrator
- now execute below
- "C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\gacutil.exe" -if "C:\TestProj\bin\Debug\Test_Task.dll"
- copy the dll to SSIS DTS location (see image)
- now find your Microsoft SQL Server location and go to DTS\Task folder
- in my case, it is in "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Tasks"
- the folder "100" may vary due to SQL server version.
- now copy the dll and past it to the Tasks folder, you may need administrator permission.
- Test the Task is working (see image)
- open the Visual Studio.
- close it if already open then open it again.
- create/open an SSIS project
- now look at the toolbox.
- if the task is already there then we are done
- if the Task is not in there then follow below
- right click on ToolBox, then click on "Chose Item".
- OR click "Tools" menu -> click "Choose ToolBox Items..."
- a new window will come with all of the Installed tasks...
- go to "SSIS Control Flow Items" [in general all goes to this location]
- select/check your Task(HelloWorld)
- click ok
Install SSIS Custom Task |
Test to Run the Task |
No comments:
Post a Comment