SSIS - Import Object name is not valid. The name cannot be empty

1
votes

I am trying to import an SSIS package, however keep getting the following error message:

The object name is not valid. The name cannot be empty.

Here is the full technical message:

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral) at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events) at Microsoft.DataTransformationServices.Controls.PackageProtectionUtils.<>c_DisplayClass4.b_3(String password, IDTSEvents events) at Microsoft.DataTransformationServices.Controls.PackageProtectionUtils.LoadPackageWithPassword(PackageLoader loader, IWin32Window dialogParent, String packageName, Boolean askOptionalPassword, String& packagePassword, DtsProtectionEventListener errorListener) at Microsoft.DataTransformationServices.Controls.PackageProtectionUtils.LoadPackageFromFile(String file, IWin32Window dialogParent, Boolean askOptionalPassword, PackageUpgradeOptions packageUpgradeOptions, String& packagePassword, DtsProtectionEventListener errorListener) at Microsoft.DataTransformationServices.Controls.PackageLocationControl.LoadPackage(DtsProtectionEventListener errorListener, PackageUpgradeOptions packageUpgradeOptions, String& packagePassword) at Microsoft.DataTransformationServices.Controls.PackageLocationControl.LoadPackage(DtsProtectionEventListener errorListener, String& packagePassword) at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)

I am not sure why I am getting this message. I have imported other packages several times without any issues.

SQL Server: 2008 SSIS was created in VS 2008

The file name or path has no dots or any other special characters in it.

2
sql-server-2008ssis

2 Answers

1
votes

For anyone else having this problem, I'll post the solution for us.

I was having the same problem on one of our partners servers. We only had SQL Server 2008 R2 and SSIS installed.

We resolved the problem by installing BIDS (Business Intelligence Development Studio). I was then able to import the packages.

0
votes

It seems its related to my machine. I was able to import the same packages from a different workstation.