Q

SSIS error message due to installation problem on SQL Server 2005

If you are receiving an error message in SQL Server Integration Services (SSIS), your problem might be with the installation of the SQL Server 2005 client tools.

I have recently begun using SQL Server Integration Services (SSIS). When I went into Business Intelligence Development Studio (BIDS) and tried to create a new project, I received this error message:

"Could not load or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies. The system could not find the file specified."

I searched on my computer for the necessary .dll file, and it was there. How can I fix this problem?

I have seen this problem a few times with the installation of SQL Server 2005 on a local machine. You have not specified which version of SQL Server you are running and I cannot attribute this solution to SQL 2000 or 2008. However, with SQL Server 2005, the most common fix for this is to reinstall SQL Server 2005 client tools. Usually what you have to do is go into the advanced set-up options to uninstall and then reinstall the client tools.
This was first published in September 2008

Dig deeper on Microsoft SQL Server 2005

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close