How to run an SSIS 2005 Package from the command line?

14 Jun 2010 - No Comments

In order to run an SSIS 2005 Package from the command line, do the following: 1. Open MS-DOS terminal (Start >> Run >> type: cmd [enter] 2. Navigate to C:Program FilesMicrosoft SQL Server90DTSBinn 3. Run the following command: DTExec.exe /F “<path-to-dtsx-file>” Typically you would want to set up a schedule for the packages to run, [...]

Creating terminal aliases for MS-DOS

14 Jun 2010 - No Comments

If you use the MS-DOS command line and find yourself frequently using the same commands in repeition, you can create aliases for the commands to help speed up your work environment. Here’s an example: 1. Navigate to C:WINDOWSsystem32 (this is your system path) 2. Create a file named home.bat 3. Inside the file add this: [...]

Window’s Services – starting/stopping services through the command line

14 Jun 2010 - No Comments

If you are like me (very command line oriented), then you hate having to look through the Services utility window to start or stop a service. Here is a quick tidbit on starting your windows services through the command line: – Open terminal: Start >> Run >> type: cmd [enter] In order to start or [...]

Command Line Tool – htop

14 Jun 2010 - No Comments

If you are interested in a more robust process viewer/analyzer than the traditional ‘top’ program, check out ‘htop’.  If you are running a debian-based system, execute the following command: sudo apt-get install htop To run the utility once installed, just type ‘htop’ in the shell. Here’s a quick comparison of top vs htop: http://htop.sourceforge.net/index.php?page=comparison

First Post…

14 Jun 2010 - No Comments

The long awaited blog… Time to rock.