SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS - Import Object name is not valid.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sonu
Posting Yak Master

110 Posts

Posted - 05/21/2012 :  14:33:43  Show Profile  Reply with Quote
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 2008

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

sonu
Posting Yak Master

110 Posts

Posted - 05/21/2012 :  15:36:55  Show Profile  Reply with Quote
Does anybody have any idea why this would happen?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47182 Posts

Posted - 05/21/2012 :  16:08:11  Show Profile  Reply with Quote
can you explain how you're trying to import? is it from ssis instance using SSMS?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

sonu
Posting Yak Master

110 Posts

Posted - 05/21/2012 :  16:15:48  Show Profile  Reply with Quote
It seems its related to my machine. I was able to import the same packages from a different workstation.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000