InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 22:51:37 GMT20http://www.sqlservercentral.com/Forums/Topic792329-148-1.aspxWell what part isn't clear?You can't use the easy way in Agent to run it, but you can use that to get most of the command line.You need to find DTExec.exe, it will likely be somewhere under:C:\Program Files (x86)\Microsoft SQL Server\90You will use the full path to the DTExec.exe and the command line you got from Agent in the operating system command from agent..CEWIIWed, 23 Sep 2009 01:38:53 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic792329-148-1.aspxI need additional detail. Thank you so much.Wed, 23 Sep 2009 01:16:01 GMTKicking_Fish0713http://www.sqlservercentral.com/Forums/Topic792329-148-1.aspxTo make it work you can't use the Integration Services Package type. You have to use Operating System type..You need to find the full path to the 32-bit version of the DTExec.exe file. It will be down a path like C:\Program Files (x86)You (unfortunately) have to spell out the entire command line including the full path to DTExec.exe, you can get most of the path by initially setting it up as an Integration Services type..Do you need additional detail?CEWIITue, 22 Sep 2009 23:20:50 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic792329-148-1.aspxI'm using 64-bit.Thank you very muchTue, 22 Sep 2009 21:37:49 GMTKicking_Fish0713http://www.sqlservercentral.com/Forums/Topic792329-148-1.aspxI'm using 64-bit.Thank you very muchTue, 22 Sep 2009 21:33:22 GMTKicking_Fish0713http://www.sqlservercentral.com/Forums/Topic792329-148-1.aspx[quote][b]Kicking_Fish0713 (9/22/2009)[/b][hr]Hello,Can somebody help me on how to solve my problem in SSIS?I've created SSIS,when I try to run this on the development,it works.But on the job,the error is:Argument "XLS" for option "connection" is not valid[/quote]Let me guess..Your server is 64-bit...You have to call the 32-bit version of DTExec..If your server is 64-bit, reply back and I can go into further detail.CEWIITue, 22 Sep 2009 21:07:11 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic792329-148-1.aspxHello,Can somebody help me on how to solve my problem in SSIS?I've created SSIS,when I try to run this on the development,it works.But on the job,the error is:Argument "XLS" for option "connection" is not validTue, 22 Sep 2009 20:33:02 GMTKicking_Fish0713