Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sonu
Posting Yak Master
110 Posts |
 Posted - 2012-05-21 : 14:33:43
|
I am trying to import an SSIS package, however keep getting the following error message:quote:
The object name is not valid. The name cannot be empty.
Here is the full technical message:quote:
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 2008The file name or path has no dots or any other special characters in it. |
|
|
sonu
Posting Yak Master
110 Posts |
Posted - 2012-05-21 : 15:36:55
|
| Does anybody have any idea why this would happen? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-21 : 16:08:11
|
| can you explain how you're trying to import? is it from ssis instance using SSMS?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sonu
Posting Yak Master
110 Posts |
Posted - 2012-05-21 : 16:15:48
|
| It seems its related to my machine. I was able to import the same packages from a different workstation. |
|
|
|
|
|
|
|
|
SSIS - Import Object name is not valid.