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:

1. Check the name, version, and SNK (Strong Name Key) between BIDS, GAC (General Assembly Cache), and in the components source.
2. If more than one version exists in the file location or in the GAC, delete all entries and reinstall the correct version.
3. Restart the SQL Integration Service.
4. 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!

Advertisement