.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

SSIS Project Build - Command Line

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
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.

View Complete Post

More Related Resource Links

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?    

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.          

Deploying SharePoint 2010 VS Project form the Command Line



Visual Studio 2010 does a great job deploying when you right click on the project and select the deploy menu item.  It removes and redeploys appropriately if it is already deployed and is fairly robust for the most part.  However, there doesn't seem to be an msbuild /t:deploy target.  How does one run the deploy command that Visual Studio is using from the command line as part of the build (to run a unit test for example)?  I am not looking to lauch Visual Studio, but instead, execute the underlying command that Visual Studio is executing.



Silverlight: Build Line-Of-Business Enterprise Apps With Silverlight, Part 2


Here we wrap up the call center client application we began last month. The techniques we illustrate will help you build real-world enterprise solutions using Silverlight.

Hanu Kommalapati

MSDN Magazine February 2009

Silverlight: Build Line-Of-Business Enterprise Apps With Silverlight, Part 1


Take a walk through the creation of a call center client application to learn how to build real-world enterprise solutions using Silverlight.

Hanu Kommalapati

MSDN Magazine January 2009

Video: How to Build SharePoint 2010 Project Items, Features, and Solutions

This video describes how to build SharePoint 2010 artifacts with Visual Studio 2010. (Length: 2:17)

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

.NET 2.0 Project won't build when targeting .NET 4.0

Hi, I'm in the process of giving a .NET 2.0 application a brand new UI using WPF. I created a whole new solution but there are a few .NET 2.0 class library projects from the original that I have copied in. They build fine by default. I want to change them to target the .NET framework 4.0 though so that this application won't require two different versions to be installed. When I change it to target .NET 4.0 client profile it gives me a big list of errors saying that references to a another custom 2.0 library (not in the solution) don't exist (E.G. The type or namespace 'x' could not be found (are you missing a using directive or an assembly reference?)). I'm not missing either. In fact the very first error is complaining about the line containing my using directive. Can you not reference a 2.0 library from a 4.0 project?

Using a Variable in SSIS - Error - "Command text was not set for the command object.".

Hi All, i am using a OLE DB Source in my dataflow component and want to select rows from the source based on the Name I enter during execution time. I have created two variables, enterName - String packageLevel (will store the name I enter) myVar - String packageLevel. (to store the query) I am assigning this query to the myVar variable, "Select * from db.Users where (UsrName =  " + @[User::enterName] + " )" Now in the OLE Db source, I have selected as Sql Command from Variable, and I am getting the variable, enterName,. I select that and when I click on OK am getting this error.   Error at Data Flow Task [OLE DB Source [1]]: An OLE DB error has occurred. Error code: 0x80040E0C.An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E0C  Description: "Command text was not set for the command object.". Can Someone guide me whr am going wrong? myVar variable, i have set the ExecuteAsExpression  Property to true too. Please let me know where am going wrong? Thanks in advance.

Integrate SSIS project in Windows Form

I have a windows form project in which I would like call a SSIS project passing 2 variables simlutaneously...How do I accomplish this?

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?

SSIS to MS Project

Hi All, My requirements are that I am supposed to export a lot of data from a work tracking system (MS SQL based) to MS Project 2003 or higher. Can any one guide me how I'll accomplish this? Thanks!GBM

SSIS Package returns the error - The command execution generated errors.

SSIS Package returns the error - 'The command execution generated errors'. Please let us know the cause for this error if anyone encountered this error before. Require a solution for this.   Thanks
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