Glad to hear you got it working...

Glad to hear you got it working...

SCORE!!!!!!!!!! ...as expected, it was a permissions issue. The organization recently upgraded to SQL Server 2008 R2 from SQLServer2005. The security policy changes between the two have been wreaking havoc on our processes. I was able to get hold of some...

Hi, You need to put a space before /CHECKPOINTING to separate it from your server name as the compiler is interpreting /CHECKPOINTING as your instance name. N'/SQL "\Maintenance Plans\MyPackage.dtsx" /SERVER ' + @SERVER + ' /CHECKPOINTING OFF /SET \P...

Hi, You need to put a space before /CHECKPOINTING to separate it from your server name as the compiler is interpreting /CHECKPOINTING as your instance name. N'/SQL "\Maintenance Plans\MyPackage.dtsx" /SERVER ' + @SERVER + ' /CHECKPOINTING OFF /SET...

Hi Jeff. I ran across your post here while researching an error I'm getting while trying to do **almost** exactly what you outlined in your article. The *major* difference between what you posted and what I am trying to do is that I am not passing my pack...