Saving Import Wizard Packages - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

Saving Import Wizard Packages

Author

Topic

Rach2009
Starting Member

37 Posts

Posted - 2010-01-25 : 04:48:17

Hi,

I am currently trying to save a package in the import wizard in SSIS but everytime I try I get the following error message:-

"TheExistsOnSQLServerMethod has encounterec OLE DB Error code 0x80040E09 (The EXECUTE permission was denied on the object 'sp_dts_checkexists', database 'msdb', schema 'dbo'). The SQL statement issued has failed.

Any ideas why this is happening?

Or am I better to save it to the file system? (I am looking at eventually scheduling the package to run daily)

Thanks

Rachel

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-01-25 : 05:33:25

SQL Agent can use packages stored either in MSDB or file system. It doesn't matter.

N 56°04'39.26"
E 12°55'05.63"