Hi All, I am trying to execute a ssis package through command file using dtexec.I am getting the following error.."login failed for the user metnet/Rkrishna".The connection string I am using looks like this "c:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtexec" /file "T:\MIS\SSIS\SBO\MIS_SBOExtract.dtsx" /Set \Package.Connections[MIS_CONNECTION].Properties[ConnectionString];"\"Data Source=AV-RISCDCSQL143\SQL143,1446;Initial Catalog=B0116PMS;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;\"" I am not giving any username or password here.Do anybody has idea as how to make it work?

The issue seems is in improper use of the escape char \ in the end of the command line. Use "c:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtexec" /file "T:\MIS\SSIS\SBO\MIS_SBOExtract.dtsx" /Set \Package.Connections[MIS_CONNECTION].Properties[ConnectionString].Value;"\"Data Source=AV-RISCDCSQL143\SQL143,1446;Initial Catalog=B0116PMS;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;"\" But the error is security related, so may be if the above does not work use a UDL to test the connection.Arthur My Blog

It could be a permission issue as this is using Windows authentication. Can you connect to the SQL Server (AV-RISCDCSQL143\SQL143) using Windows authentication from SSMS?

You need to first perform a connection test to your database with that domain account as ArthurZ pointed. If the connection still failed, you need to first ensure that the login existed in your SQL Server and has permissions to access to your database. The Q15 in this FAQs ebook http://blogs.msdn.com/b/sqlforum/archive/2011/06/10/sql-server-faqs-ebook-with-database-engine-ssrs-ssis-ssas-.aspx may be helpful for you. BTW, in the error message it shows "metnet/Rkrishna", however for a domain user account, it should be expressed like this "metnet\Rkrishna". Is it a typo error? or you explicitly specify the windows user account in some place of your SSIS package or configuration file etc?Please remember to mark the replies as answers if they help and unmark them if they provide no help

I dint have permission connecting to database with windows authentication.So,I tried connecting using sql server authentication and it worked.The new connection string I am using is this one. "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtexec" /file "T:\MIS\SSIS\SBO\MIS_SBOExtract.dtsx" /Set \Package.Connections[MIS_CONNECTION].Properties[ConnectionString];"\"Data Source=AX-SISCDCSQL112\SQL112,1440;Initial Catalog=B0116XMS;Provider=SQLNCLI.1;User ID=RETECH;Password=RETECH;Auto Translate=False;"\"

I dint have permission connecting to database with windows authentication.So,I tried connecting using sql server authentication and it worked.The new connection string I am using is this one. "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtexec" /file "T:\MIS\SSIS\SBO\MIS_SBOExtract.dtsx" /Set \Package.Connections[MIS_CONNECTION].Properties[ConnectionString];"\"Data Source=AX-SISCDCSQL112\SQL112,1440;Initial Catalog=B0116XMS;Provider=SQLNCLI.1;User ID=RETECH;Password=RETECH;Auto Translate=False;"\"