March 26, 2012 at 1:40 pm
Hi All ,
I have created an SSIS package for the maintenance plan & it will run on every sunday. I am getting an errro when the job is running
Executed as user: NASA\sqlexec_chsales. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Argument "Local" for option "connection" is not valid. The command line parameters are invalid. The step failed.
Command file :
/SQL "Maintenance Plans\Rebuild Indexes & Update Statistics On All the DB" /SERVER "EASOHSBMSQLDEV1\D1" /CONNECTION "Local server connection";"\"server='EASOHSBMSQLDEV1\D1';Trusted_Connection=true;Application Name='Microsoft SQL Server Management Studio';Pooling=false;Packet Size=4096;multipleactiveresultsets=false;\"" /CHECKPOINTING OFF /SET "\Package\Subplan_1.Disable";false /REPORTING E
I am new to SSIS . I am not sure why I am getting this error.
Thanks
March 26, 2012 at 2:08 pm
Hi,
Check the version (32 or 64) of the server(where you were deployed)
March 26, 2012 at 3:11 pm
I have created the package in the same server
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply