.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Does dtsinstall.exe Accept any Command Line Parameters?

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
The question is in the title.

View Complete Post

More Related Resource Links

sqlexpr.exe command line parameters to show progress bar and not show OK confirmation at the end


Using SQL Server 2008 Express SP1 (sqlexpr.exe)

My command is sqlexpr.exe /X:C:\SQLInstall\

It works fine but shows the "Extraction Complete" message box at the end. If I change it to /Q /X:C:\SQLInstall\ then I do not see the progress bar or message box.

I wanted to set the parms such that I see the progress bar but do not see the Extraction Complete OK messagebox. How does one do that?


Output parameters in OLEDB Command component - SSIS 2008

I have a package that I developed in SSIS 2005 and recently ported to 2008. Everything runs great except an OLE DB Command component that calls a stored procedure that uses output parameters. When I try to run this, I get this error: Error: 0xC0202009 at Data Flow Task, OLE DB Command [100]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Syntax error, permission violation, or other nonspecific error". Error: 0xC004701A at Data Flow Task, SSIS.Pipeline: component "OLE DB Command" (100) failed the pre-execute phase and returned error code 0xC0202009. When I do the same thing in SSIS2005, it works fine. So I setup a new package with 1 data flow. In that data flow, I added a source component, an OLE DB Command, and a destination.  I then tested this with a stored procedure that took no parameters. It worked fine. I then tested it with a stored procedure with 1 parameter defined as OUTPUT. This generated the error.   Is there an issue with output parameters in an OLE DB Command in SSIS 2008?   Thanks!http://bobp1339.blogspot.com

sql command line

i have a problm about mysql command line;it is desapeared at once when i enter the password to my sql command line how is that happening?

Specify Instance Port Number on Command Line Install

Is there a way to specify which port we want our named SQL Express instance to run on during a command line install with no interaction from the user?  If not, is there a way we can change the dynamic port selected after the install without any user interaction?Nick's Programming Tips


Platform:   2 servers (clustered) with windows server 2008 x64 r2 (enterprise) Application: sql2008 x64 enterprise with SP1 (slip streamed) Problem: sql2008 new cluster install fails using the COMMAND LINE with a CONFIGURATIONFILE.INI The install starts but stops with the log file in the setup bootstrap folder  => (Detail_ComponentUpdate.txt) below. Bottom lines indicate a REBOOT is required; did a reboot on both nodes and still have the same problem. Used the following command line to launch sql2008 setup: Setup.exe /Q /SQLSVCPASSWORD="**********" /AGTSVCPASSWORD="**********" /ASSVCPASSWORD="**********" /ISSVCPASSWORD="**********" /RSSVCPASSWORD="**********" /ConfigurationFile=ConfigurationFile.ini Anyone has any success installing sql2008 using command line and command file? thanks john ------------------------------- tail end of the Detail_ComponentUpdate.txt file ----------------------------------------------- 2010-09-01 15:59:44 Slp: ------------------------------------------------------------ 2010-09-01 15:59:44 Slp: C:\SQL2008 Enterprise with SP1\x64\FixSqlRegistryKey_x64.exe exit code: 0 2010-09-01 15:59:44 Slp: Launching external tool: C:\SQL2008 Enterprise with SP1\x64\FixSqlRegistryKey_x86.exe 2010-09-01 15:59:44 Slp: ------------------------------------------------------------ 2010-09-01 15:59

Error on install : The INSTANCESHAREDWOWDIR command line value was not specified.

Hi,I'm trying to upgrade my dev pc for SQL Server 2008. I've removed all previous installations of sql server 2005, then installed Business Intelligence Studio & Management Tools.During setup (when selecting features), I received the following error : "The INSTANCESHAREDWOWDIR command line value was not specified. This value must be specified when the INSTANCESHAREDDIR value is specified."I plan to install sql server 2008 on another drive (D:\Microsoft Sql Server\).I'll try to set manually parameters (D:\Microsoft Sql Server\...) in the command-line arguments. FailAny hint from the team ?

How do I obfuscate .Net IL code using command line program?

How do I obfuscate .Net IL code using command line program? I want free tool that can be deployed to obfuscate DLL generated from compiled tool?

How to know when a process run through the command line is finished - C#

Hi , I'm developing a web application in asp.net using  C# and running a .bat file from the command line. The .bat file runs another 3rd party software which resides in the server.Need to know whether the 3rd party software ran successfully to the end.Here is the code I used to run .bat file through the command line.bool RunBat(){            bool success= false;          try{            System.Diagnostics.Process proc = new System.Diagnostics.Process();           proc.StartInfo.WorkingDirectory = @"E:\test";                      proc .StartInfo.FileName = "ABC.bat";                               proc .Start();                     proc .Close();               success= true;          }       

Command line publish

HiI am new to DOT NET web publishing (not to software development).  We need through command line to build our site (which we already do using msbuild.exe), but the resulting files are way too many and it takes our to ftp it to the server.I am able to publish the website and reduce its size by ~90%; however, we need to do this through command line not manually using the GUI.I have read many postings but noone is clear on how to do it (and msbuild seems to no be able to do this). Can anyone provide me a link.Thank youPS. We are using Visual Studio 2010 and DOT NET4.0

.Net 1.1 Command Line Compile

Hello. I need to use Notepad to make changes to an old .Net 1.1 app. I then would like to use the command line compiler. Can someone tell me the syntax (and where I need to navigate to in my cmd) to compile the changes I make in the code behind pages into the DLL?Thanks in advance!

Driving install of standard web install project from command-line

I have a VS project (web service) for which I created a standard VS Web Setup project.  That project creates the typical setup.exe and project.msi files.  When run interactively, the setup prompts the user to select an IIS Site, a Virtual directory and the Application Pool.  I'd like to drive this setup silently from a script, passing the necessary args on the command-line such that the user isn't prompted.  I've played some with the args in an attempt to set those three prompts using properties, but without luck. Can anyone tell me if there are public properies on the MSI that would allow me to set those prompts via the command-line?    

ReportBuilder 2.0: open server report via command line?

Hello,is it possible to launch ReportBuilder 2.0 and pass the server report to open via command line?Searching the forums I have found this blog-entry (Launching Report Builder from the command line), but I think it is for ReportBuilder 1.0, because SQL Server 2005 is mentioned. I have tried it anyway, but ReportBuilder 2.0 just starts with an empty report.If I specify a rdl-file from the local file system the report will open fine:MSReportBuilder.exe d:\temp\samplereport.rdlthanks in advance and best regards,Gerald

Report Builder 2.0 command line

Hiare there any command line switched for the new report builder?I like to export a report directly (say, in a pdf file) without further user interaction.Any clues?RegardsKlaus

SSIS Project Build - Command Line

We are trying to automate our Build and Deployment process for SSIS Packages. Can some one suggest me the way to perform the build and deployment using Command Line.

How to generate service reference for Workflow service from command line?

Is there a way to generate service reference for Workflow service from command line using just dll file (without metadata, without wsdl). I tried using svcutil but i didn't succeed. just error without any meaningful message. udione

Maintenace Plan not executing properly from command line.

I am running SQL 2005 Standard SP3 on Microsoft Windows NT 5.2 (3790) This is a two node active/active cluster. I had a maintenance plan that was called from the command line by a third party scheduler (Tidal) and everything ran fine.  Then a new copy of the maintenance plan was created with additional code and named with _new at the end.  The new plan ran fine interactively (right click and execute).  The old plan was renamed to _old and the new plan renamed to remove the _new.  The scheduler will no longer run the maintenance plan.  I have attempted to run the plan manually from the command line, as the scheduler would do.  It finds the plan, says its starting and then runs for 6 seconds (should be about 50 minutes) and says it completed successfully, but obviously did not.  The history of the plan does not show any execution.  I have tried exporting the plan, dropping it and reimportng (jiggling the handle), I have also exported he old plan and dropped it, thinking there might be some internal name glitch.  I have no idea what is going on, but need to get the plan to run from the command line--forgetting the scheduler for the moment, the manual run from the command line does not work.  (I'll worry about the scheduler later).  The command that is being run is: dtexec /SQL “Maintenance Plans\ProvDUpeCln_CKN

Command Line Build

Is there a command line way of performing the Build of a SSIS Package which we will be doing through the Visual Studio environment through the Build option ? Please advice on the procedure.          
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend