agcsupport
asked on
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\SageData Transfer.d tsx" /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;Use WindowsAut henticatio n=True;Ena bleSsl=Fal se;\"" /CONNECTION SourceConnectionOLEDB;"\"D ata Source=AGCCRMDB;User ID=sa;Initial Catalog=CRM58;Provider=SQL NCLI10.1;P ersist Security Info=True;Auto Translate=false;Applicatio n Name=SSIS-SageDataTransfer -{7FE010B9 -6D29-4D58 -9784-448A 4CC9F4FE}S ourceConne ctionOLEDB ;\"" /CHECKPOINTING OFF /REPORTING E
Thanks for the help,
Miguel
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\SageData
Thanks for the help,
Miguel
check the account who sql server agent started under that has permission? it can be network service or administrative account
ASKER
I thought it would be permissions myself but it is not. I already cheked.
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.
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.
ASKER
I did google my problem and saw that article. I made those exact changes and it did not work for me.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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\JDEtoEve rest.dtsx" /CHECKPOINTING OFF /REPORTING EWCDI
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\JDEtoEve