Troubleshooting SSIS – The component could not be added to the Data Flow task.
So if you are getting this error creating an SSIS package and you happen to be testing out a new component; these are the things to do:
- Check the name, version, and SNK (Strong Name Key) between BIDS, GAC (General Assembly Cache), and in the components source.
- If more than one version exists in the file location or in the GAC, delete all entries and reinstall the correct version.
- Restart the SQL Integration Service.
- Delete the component (in the package) and reset the toolbar in BIDS.
Hope this helps. I applaud the SSIS beginners, experts, and gurus out there!