Deploy SSIS package error (BIDS 2005 and BIDS 2008 side by side)

Topics: Resolved
Feb 10, 2009 at 2:53 PM

I've got both BIDS 2005 and BIDS 2008 installed on my system. I've Installed BIDS HELPER 2005 and 2008.

When I try to deploy a package in BIDS 2008 I get the following error:

Microsoft (R) SQL Server SSIS Package Utilities

Version 9.00.1399.06 for 32-bit

Copyright (C) Microsoft Corp 1984-2004. All rights reserved.

Error (0xC001404A) while checking for the existence of folder "DWH\" on SQL Server.

Description: While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80040E14 (Could not find stored procedure 'msdb.dbo.sp_dts_getfolder'.).

 So it seems like it is running the SQL Server 2005 dtutil.exe. Did I miss someting or is there something I need to configure to get this scenario working?

Feb 10, 2009 at 3:50 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Feb 10, 2009 at 3:51 PM
You're absolutely right. The Deploy SSIS Packages code just makes a call to "dtutil" without specify the full path. Sounds like we need to fix that code to call the correct version (2005 vs. 2008) depending on your environment.

If you want to run Deploy on the entire project, then you can look in the bin directory and see a .bat file that BIDS Helper created. You can then modify that to use the correct dtutil path for SSIS2008. Try that and let us know if the SSIS2008 dtutil works in your situation.
Feb 11, 2009 at 9:14 PM
If I run Deploy on the project (or solution) I get the same error message. The bin directory remains empty.