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!

Advertisements

Have an opinion? Leave an opinion!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s