How To Upgrade DataDefractor in Business Intelligence Studio’s toolbox
Problem:
DataDefractor integrates with the SQL Server Business Intelligence Studio toolbox. The toolbox contains information about the version of DataDefractor source component currently integrated with it.
This causes a problem when upgrading from one version of DataDefractor to a new one, because the toolbox retains the older version even though a new version of DataDefractor is installed. In this case, when you attempt to use the component by dragging and dropping it on the SSIS Data Flow canvas, you may get the following message:
The component could not be added to the Data Flow task.
Please verify that this component is properly installed.
——————————
ADDITIONAL INFORMATION:
The data flow object “InteractiveEdge.XP3.Import.Ssis.Ddl.DdlDataSource, InteractiveEdge.XP3.Import.Ssis.Ddl,
Version=1.0.0.349, Culture=neutral, PublicKeyToken=576dedec733bc492” is not installed correctly on this computer.
(Microsoft.DataTransformationServices.Design)
This is due to lack of programmatic interface to control the SQL Server Business Intelligence Studio’s toolbox.
Solution:
Follow these steps to resolve the issue:
1. Install the new version of DataDefractor
2. Launch SQL Server Business Intelligence Development Studio
3. Right-click on the toolbox and select Show All
4. Locate DataDefractor Source in section Data Flow Sources, right-click on the component and select Delete
5. Click OK to remove the old version of DataDefractor from the toolbox
6. Right-click on the SSIS toolbox and select Choose Items…
7. Navigate to tab SSIS Data Flow Items and check DataDefractor Source
8. Click OK to add the new version of DataDefractor to the toolbox
9. You should see DataDefractor’s icon added to the “Data Flow Sources” category in the SSIS toolbox
You can start using DataDefractor by dragging and dropping it onto your SSIS Data Flow canvas.
Learn About DataDefractor
Get DataDefractor
Resources
Knowledge Base
- Connect to an ODBC Source on a x64 Machine
- Connect to the ORACLE Database with DataDefractor SSIS
- Isolate a Header or Footer Based on the Contents of a Data Section
- Loop Through Multiple Excel Files Using DataDefractor
- Upgrade DataDefractor in Business Intelligence Studio’s Toolbox
- Ensure Changes are Reflected in Output
- SSIS Beta 1 release notes
- SSIS Beta 2 release notes
- SSIS 1.0 release notes
- SSIS 1.0 SR-1 release notes
- SSIS 1.1 SR-1 release notes
- SSIS 1.1 SR-2 release notes
- SSIS 1.1 SR-3 release notes
- SSIS 1.1 SR-4 release notes
- SSIS 1.1 SR-5 release notes
- SSIS 1.1 SR-6 release notes
- SSIS 1.1 SR-7 release notes
- SSIS 1.1 SR-8 release notes
- SSIS 1.1 SR-9 release notes
- SSIS 1.1 SR-10 release notes
- SSIS 1.1 SR-11 release notes
- SSIS 1.1 SR-12 release notes
- SSIS 1.1 SR-13 release notes
- Solo 1.1 release notes
- Solo 1.1 SR-1 release notes
- Solo 1.1 SR-2 release notes
- Solo 1.1 SR-3 release notes
- Solo 1.1 SR-4 release notes
- Solo 1.1 SR-5 release notes
- Solo 1.1 SR-6 release notes
- Solo 1.1 SR-7 release notes
- Solo 1.1 SR-8 release notes
- Solo 1.1 SR-9 release notes
- Solo 1.1 SR-10 release notes
- Solo 1.1 SR-11 release notes
- Solo 1.1 SR-12 release notes
- Solo 1.1 SR-13 release notes
Email Us or call 212-462-4900
Knowledge Base
- Connect to an ODBC Source on a x64 Machine
- Connect to the ORACLE Database with DataDefractor SSIS
- Isolate a Header or Footer Based on the Contents of a Data Section
- Loop Through Multiple Excel Files Using DataDefractor
- Upgrade DataDefractor in Business Intelligence Studio’s Toolbox
- Ensure Changes are Reflected in Output
- SSIS Beta 1 release notes
- SSIS Beta 2 release notes
- SSIS 1.0 release notes
- SSIS 1.0 SR-1 release notes
- SSIS 1.1 SR-1 release notes
- SSIS 1.1 SR-2 release notes
- SSIS 1.1 SR-3 release notes
- SSIS 1.1 SR-4 release notes
- SSIS 1.1 SR-5 release notes
- SSIS 1.1 SR-6 release notes
- SSIS 1.1 SR-7 release notes
- SSIS 1.1 SR-8 release notes
- SSIS 1.1 SR-9 release notes
- SSIS 1.1 SR-10 release notes
- SSIS 1.1 SR-11 release notes
- SSIS 1.1 SR-12 release notes
- SSIS 1.1 SR-13 release notes
- Solo 1.1 release notes
- Solo 1.1 SR-1 release notes
- Solo 1.1 SR-2 release notes
- Solo 1.1 SR-3 release notes
- Solo 1.1 SR-4 release notes
- Solo 1.1 SR-5 release notes
- Solo 1.1 SR-6 release notes
- Solo 1.1 SR-7 release notes
- Solo 1.1 SR-8 release notes
- Solo 1.1 SR-9 release notes
- Solo 1.1 SR-10 release notes
- Solo 1.1 SR-11 release notes
- Solo 1.1 SR-12 release notes
- Solo 1.1 SR-13 release notes
Email Us or call 212-462-4900