Either put the two logins in the same Windows group, or if they're SQL logins, use roles within the databases to assign permissions. This won't help you with the...

If you're allowed to modify the package, you could enable logging and see where it's up to when it hangs. Otherwise, you'll probably need to keep a close eye...

What is the overall size of your database? How often do you do full and log backups?

John

Read about Package Configurations. If you have all your changeable properties in variables, all you have to do is set the value of those variables in your configuration file...

Or you can do it like this. I've used spt_values in master for my numbers, but if you prefer you can generate a numbers CTE on the fly or...

I would cheat and create a table with StartDate and EndDate that listed all the periods.

John

Debbie

Create a table in your database that holds the years you are going to use as parameters. In your package, select from this table into an Object variable. ...

It's what you get when you press the "Return" or "Enter" key on your keyboard.

John

Looks correct. The only thing I can think of is that you have a carriage return character in your command.

John

Probably best to export from a SQL statement instead of directly from the table. Include a case statement that converts the Boolean values into 'True' and 'False'. You...

Remove the path from the target name for the file, so that you specify only the file name itself.

John

Is that syntax error coming from SQL Server or from the Cmd Exec? Please post the exact error message.

Thanks

John

1. You must know the file name and path in order to import it in the first place, mustn't you?

2. You'll need to set the task so it doesn't cause...

Here is your clue:

EXEC @retVal = xp_cmdshell @TmpPurgeCommand, no_output;

IF (@retVal = 1) -- Error occured

BEGIN

RAISERROR (50001, -- Message id.

16, -- Severity,

1, -- State,

N'xp_cmdshell call in [dbo].[adminManagePartition_Trace] failed. Purge not complete.');...

Have you looked in the default trace?

John