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)