okay, this works.

Thanks for the help

This code would check for State = 'MN'

AND ProdCodes NOT IN ('Kl', 'Kjh') )

I need it to exclude ProdCodes NOT IN ('Kl', 'Kjh')  When the state is MN.

That may work but I need something a little different:

I need the if it is State = MN then Exclude ProdCodes IN ('Kl', 'Kjh')  Else if State not = MN...

Thanks for the reply, but that is not what I need.

I need a way to write this that when the state is MN then these ProcCodes are Excluded, but in...

thank you

Thank you

This is great.

As far as the file path in the script it has a path like this C:\scripts\file.bat.

the file has Service account permissions in it.

Thank you

Okay, that will work.

Thnaks

thanks, everyone this is really great.

Thank you this really helps.

Hi and thanks for the reply.

I am also trying to learn exactly how you set this up.

So in my example:

Full backup every day

Differential backup every hour.

And a log backup every...

Thanks for the reply, can you please tell me how do you set a backup for the transaction log backup?

Thank you

Hi,

Oaky thanks.

Hi,

I apricate everyone's help here. I think I got this to work, at least for this anyway.

Someone asked if I rebuild it, and yes I also had packages that do...

HI Jeff,

I apricate your wanting to know I did not want to bother you with it, but I would like to get the SSIS  to work. As I said above,...