i would suggest taking a look in the sysdtspackagefolders90 table in the msdb database

The Maintenance Plans in Sql Server 2005 only support compatibility level 80 or higher

I got an operator with 3 email addresses separated by a ; so this is of course working with the dbmail not smtp. In agent jobs where i want some...

Hello you can use a comma separated list as email in an operator but it still limited to a few characters so best practice would be to use an distributed...

INSERT INTO tablename

SELECT *

FROM

OPENROWSET ('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=C:\testfolder;', 'SELECT * from test.csv');

this should work work

INSERT INTO ...

SELECT ...

FROM OPENROWSET ( ....

Yes that's likely what they did. I would recheck all permissions now to try find out the problem but you say you can run the package without error but it...

just change the level in the properties of the database and there is sp_dbcmptlevel available in 2005 server see bol http://msdn.microsoft.com/en-us/library/ms178653.aspx or are you wondering about the effects...

there is a nice article on books online here http://msdn.microsoft.com/en-us/library/ms190615.aspx that might help you sorting it out

think your agent service user does not have the right permissions to use dbmail try making a profile public to confirm that

hmm books online? http://msdn.microsoft.com/en-us/library/ms186865.aspx

you should not have to shrink at all and consider looking why it is growing like that any bad code open transactions not getting closed etc etc etc but anyways...

see if there are server listed under linked server tab in enterprise manager check security settings for them and the remote servers

not talking about that i was wondering if your windows authentication is just local to some user accounts on your database machine or remote to some ad controller

it will not make any problems and run on whichever server you execute it