Tuesday, August 4, 2009

DTS to SSIS Migration

Using SQL Server Business Intelligence Development Studio, you will need to install the SQLServer2005_DTS.msi (otherwise known as Microsoft SQL Server 2000 DTS Designer Components) found here (last time I looked).

Once that's done (oh no, ur not done yet) you'll need to find and drop 3 files into C:\Program Files\Microsoft SQL Server\[version mine was 100 because 2008 was installed]\Tools\Binn\VSShell\Common7\IDE.

If you don't do this, the designer will complain that it needs the files in IDE/1033, but installing them at the higher level described above (IDE vs IDE/1033) worked for me.

The files seemed to be semsfc.rll, sqlgui.rll and SQLSVC.RLL.

Good luck!

No comments:

Post a Comment