issues adding exising SSIS to package

[swoodring]

I have some DTS I have using the migration wizard to bring them over to SQL 2005. I have created a package and can sucessfully import them on the server but if i try to do it on my laptop I get a very generic error one or more errors occurred. there should be more specefic errors proceeding this one that explains the details of the error. any ideas on what is causing this or where I can find these additonal error info to give me an idea on what is going on here?

 

[swoodring]

ok I found a little more detail on this message. I clicked on show techincal details and it gave me the following. I don't see anything here that tells me what is wrong. I though maybe it was my security on MSDB. I pretty much gave myself all roles with exeption of denydatereader and denydatwrite since I know I need those. Any ideas what is wrong on why I can't import a package from MSDB when connected from my laptop? I initially tried it from the server with my admin account and that worked fine. So I connected to server with my regular account via remote desk top and I could add SSIS packages to project. So it is not my id it's something with doing it from my laptop. any ideas?

===================================

One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.
(Microsoft Visual Studio)

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.LoadFromSqlServer(String packagePath, String serverName, String serverUserName, String serverPassword, IDTSEvents events)
at Microsoft.DataTransformationServices.Controls.PackageProtectionUtils.<>c__DisplayClassa.<LoadPackageFromSql>b__9(String password, IDTSEvents events)
at Microsoft.DataTransformationServices.Controls.PackageProtectionUtils.LoadPackageWithPassword(PackageLoader loader, IWin32Window dialogParent, String& packagePassword)
at Microsoft.DataTransformationServices.Controls.PackageProtectionUtils.LoadPackageFromSql(String packagePath, String server, String sqlUserName, String sqlServerPassword, IWin32Window dialogParent, String& packagePassword)
at Microsoft.DataTransformationServices.Controls.PackageLocationControl.LoadPackage(String& packagePassword)
at Microsoft.DataTransformationServices.Project.Controls.AddExistingPackageForm.AddExistingPackage()
at Microsoft.DataTransformationServices.Project.Controls.AddExistingPackageForm.AddExistingPackageForm_FormClosing(Object sender, FormClosingEventArgs e)

===================================

One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.


------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.LoadFromSQLServer(String bstrPackagePath, String bstrServerName, String bstrServerUserName, String bstrServerPassword, Boolean bLoadNeutral, IDTSEvents90 pEvents)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadFromSqlServer(String packagePath, String serverName, String serverUserName, String serverPassword, IDTSEvents events)