Post reply

Argument “SMTP” for option “connection” is not valid. The command line parameters are invalid. The step failed

  • May 21, 2010 at 8:01 am

    #221887

    My SSIS package is run and sent email successfully if I run it from Stored package from Integration Service. So, I schduled as a job in SQL Server agent using proxy account (service account)..If I run the package as a job. I have the following error..

    Argument “SMTP” for option “connection” is not valid. The command line parameters are invalid. The step failed

    I can't figure out..

    Please help..

  • May 21, 2010 at 9:20 am

    #1170910

    sorry about this post. I found that my remote password to the link server is not valid. it resolved the error.

  • November 22, 2010 at 12:46 pm

    #1253968

    Hi,

    I get the same error

    Executed as user: NT AUTHORITY\NETWORK SERVICE. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Argument "SMTP" for option "connection" is not valid. The command line parameters are invalid. The step failed.

    Please if you can detail how did you solved the problem.

    david

    nahmiastech@yahoo.com

  • May 5, 2011 at 9:01 am

    #1320483

    Hi, I am having the same problem.

    Argument "SMTP" for option "connection" is not valid. The command line parameters are invalid. The step failed.

    what am I doing wrong. When I try this in debug mode it works fine.

  • May 5, 2011 at 11:35 am

    #1320593

    talha kamran (5/5/2011)

    Hi, I am having the same problem.

    Argument "SMTP" for option "connection" is not valid. The command line parameters are invalid. The step failed.

    what am I doing wrong. When I try this in debug mode it works fine.

    There are two ways to fix it one is to use the account used to run the proxy as the account used for the Windows authentication in SMPT or use a Script Task to send the email which lets you define the account used for SMTP connection because it uses System.NET SMTP classes.

    Kind regards,
    Gift Peddie

  • August 20, 2012 at 5:38 pm

    #1527893

    Argument "xyz" for option "connection" is not valid. The command line parameters are invalid. The step failed.

    I solved this issue by following

    http://www.sqlserverbox.com/ssis-package-in-sql-server-agent-job-fails.html

    http://sqlism.blogspot.com/2012/08/ssis-package-in-sql-server-agent-job.html

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply