Another SSIS issue 1

[aalmeida]

I have a SSIS package that is giving me a weird error message:

Error Message: Executed as user: DEV\SQLAgent. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Option " /SERVER" is not valid. The command line parameters are invalid. The step failed.

Command Line: /SQL "\Maintenance Plans\User DBs" /SERVER "DevCL01VirDB01\INST01, 1433" /X86 /CHECKPOINTING OFF /SET "\Package\BAK cleanup.Disable";false /REPORTING E

This Package was developed on the same machine it's running it's a Windows 2K8 server running SQL Server 2k8 all enterprise edition 64 bit. I already tryed the check box to use 32 bit version but to no avail, any ideas?

AL Almeida
CIO

http://www.artdigitalonline.com/

May all those that come behind us, find us faithful

 

[mrdenny]

Try removing the ", 1433" from the /SERVER switch.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[aalmeida]

mrdenny,

That did the trick.

Thanks.

AL Almeida
CIO

http://www.artdigitalonline.com/

May all those that come behind us, find us faithful

 

[mrdenny]

No problem.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog