SSIS error - Argument "SMTP" for option "connection" is not valid

I have built an SSIS package that works just fine in BIDS.  I would like to schedule the package in SQL Server Agent.  After I set it up I get the following error:

Argument "SMTP" for option "connection" is not valid

I also ran it using using command line DTExec and I get the same error.  Not sure why.  The command line created by DETexecUI is below.

/FILE "D:\SSIS\Packages\SageDataTransfer.dtsx"  /CONNECTION DestinationConnectionOLEDB;"\"Data Source=EVERESTDA;Initial Catalog=AGC_PROD;Provider=SQLNCLI10;Integrated Security=SSPI;Auto Translate=false;\"" /CONNECTION "SMTP Connection Manager";"\"SmtpServer=10.0.8.14;UseWindowsAuthentication=True;EnableSsl=False;\"" /CONNECTION SourceConnectionOLEDB;"\"Data Source=AGCCRMDB;User ID=sa;Initial Catalog=CRM58;Provider=SQLNCLI10.1;Persist Security Info=True;Auto Translate=false;Application Name=SSIS-SageDataTransfer-{7FE010B9-6D29-4D58-9784-448A4CC9F4FE}SourceConnectionOLEDB;\"" /CHECKPOINTING OFF /REPORTING E

Thanks for the help,
Miguel
agcsupportAsked:
Who is Participating?
 
Megan BrooksConnect With a Mentor SQL Server ConsultantCommented:
Focus on the part of the command line adjacent to "SMTP Connection Manager." Instead of inserting quotes, you can try removing spaces altogether in various places (e.g. "SMTPConnectionManager"). The resulting command lines won't work, but doing this may clarify where the problem is by producing different error messages.
0
 
Reza RadCommented:
check the account who sql server agent started under that has permission? it can be network service or administrative account
0
 
agcsupportAuthor Commented:
I thought it would be permissions myself but it is not.  I already cheked.
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
Megan BrooksSQL Server ConsultantCommented:
This is likely a problem with the quotes on the command line. Here's a similar case:
http://www.sqlservercentral.com/Forums/Topic388545-148-1.aspx 
It looks like you have the right idea, but something is slightly off. Just a guess, maybe /CONNECTION "SMTP Connection Manager" should be /CONNECTION "\"SMTP Connection Manager\""? I haven't had to solve one of these quote puzzles in years and I am rusty.
0
 
agcsupportAuthor Commented:
I did google my problem and saw that article.  I made those exact changes and it did not work for me.  
0
 
agcsupportAuthor Commented:
Thanks rscowden.

I finally eneded up not choosing the connection strings as part of my command line and it worked fine.  My batch file executes the following command and it runs fine.

DTexec /FILE "D:\SSIS\Packages\JDEtoEverest.dtsx" /CHECKPOINTING OFF  /REPORTING EWCDI
0
All Courses

From novice to tech pro — start learning today.