We were trying to setup an SSIS Package on a SQL Server, when we would try to open one of the Data Flow tasks we would get the following error:
The designer could not be initialized. (Microsoft.DataTransformationServices.Design)……..
There was more to the error, but I didn’t get a screen shot.
Basically here’s what happened:
Systems affected: 64bit SQL 2005 SP2
When we installed SP2 it uninstalls the 32bit DTS.dll file and replaces it with the 64 bit version. The BIDS tool uses the 32bit version. So the fix was to re-registar the 32bit dll using the following command: %windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll"
Here’s the link to the Microsoft article: