Ask the Expert

SSIS error message due to installation problem on SQL Server 2005

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: