Welcome to VSTSC's Community Server Sign in | Join | Help

Browse by Tags

Tuesday, November 25, 2008 6:50 PM

PrimeFinder

Alright everyone has written the obligatory "Hello World!" program when they start to learn a new language. I have my own variety of that practice and its PrimeFinder. Whenever I start to learn a new language I write a program that finds primes. I know
Posted by steve | 0 Comments
Monday, November 03, 2008 9:52 AM

SSIS Execute SQL Task and RaisError (Using a OLEDB Connection)

This is a relatively short post about raising an error in T-SQL and having SSIS not recognize that error. If you have an SSIS package that calls a SQL Task and that T-SQL for whatever reason ends up raising an error the SSIS package that called the T-SQL
Posted by steve | 0 Comments
Tuesday, September 02, 2008 9:15 AM

dtexec.exe what are you doing? (part II)

This is the second part in a very short series covering dtexec and how to see exactly what package it is executing. Last time we covered how to see what dtexec was doing using PowerShell and WMI . This was great for checking all the different packages
Posted by steve | 0 Comments
Filed under: , ,
Sunday, August 31, 2008 5:14 PM

dtexec.exe what are you doing?

dtexec.exe is the program that is executed to run dtsx packages in SSIS 2005. This executable is called if you call a Integration Services package through SQL Server Agent or through the command line directly. The problem I am trying to solve today is
Posted by steve | 0 Comments
Filed under: , ,
Tuesday, July 08, 2008 5:07 AM

space_used_sp vs. sp_spaceUsed

Ok I'm not one to re-write standard system stored procedures for SQL Server. That being said I have been working a good deal with files and file groups within SQL Server over the past few days moving data and indexes to files and file groups other than
Posted by steve | 2 Comments
Wednesday, May 28, 2008 5:19 PM

Ordering SSIS packages in Visual Studio 2005 (part II)

Ok the first post on Ordering SSIS packages in Visual Studio received a large number of hits...no comments but a good number of hits so I figured a follow up was due. After my first post I found myself ordering all of my SSIS packages with the order-ssisProj.ps1
Posted by steve | 1 Comments
Friday, May 16, 2008 5:45 PM

Ordering SSIS packages in Visual Studio 2005

Problem: SSIS Packages in Microsoft Visual Studio 2005 are ordered in the order of package creation by default, or more precisely the order they have been added to that solutions/projects folder. What this means is that if you have an SSIS project that
Posted by steve | 0 Comments
Monday, April 14, 2008 6:33 PM

trap [exception] { #insert code here} .... -ea stop

First off I'm not The PowerShellGuy (if you want tons of powershell information go there first)...I'm just getting started with PowerShell but I can already see how it can be extremely useful to a database developer and database administrator. I plan
Posted by steve | 0 Comments
Filed under:
Saturday, February 16, 2008 6:55 PM

theSystem part X

Well one of my topics, "theSystem" listed in a previous post TwoProjects has moved over to SQL Server Central . I may have some more background information on this project from time to time but the majority of the writing will take place at SQL Server
Posted by steve | 0 Comments
Filed under:
Saturday, February 16, 2008 6:45 PM

Connecting to an iSeries for SSIS Users (this pertains to any .Net connection)

There are a number of useful pieces of information to be gleaned from reams and reams of documentation on both sides of the house when it comes to connect SSIS to an IBM iSeries. I will try to present as much of it as I can in an easy to read fashion
Posted by steve | 0 Comments
Friday, January 25, 2008 10:26 AM

Data Dictionary Part II

Ok, after putting up my first post on the Data Dictionary I had posters remorse. There is a simple change that makes the script shown in the previous post a little more user friendly. First the view metadata.columnsDataDictionary need to be changed from
Posted by steve | 0 Comments
Attachment(s): DataDictionary.sql.txt
Tuesday, January 15, 2008 10:26 AM

Data Dictionary part I

Having a data dictionary is an invaluable resource for not only for the DBA but for anyone, report writers or developers who need to work on a database that you have to manage or have developed yourself. A good amount of time can be saved from answering
Posted by steve | 0 Comments
Friday, January 04, 2008 10:18 AM

Output Clause

Alright have to give credit for this post to Andy because he is the one who pointed out how useful the Output Clause on an insert statement could be. Starting in SQL Server 2005 you could add an output clause to an insert, delete, or update statement
Posted by steve | 0 Comments
Filed under:
Wednesday, December 19, 2007 5:55 AM

The Third Project - Obscure T-SQL commands

Ok so maybe this isn't a project so much as a topic. This will be the first in a series of post dealing with obscure t-sql commands from SQL Server 2000 thru 2008 that I find, that may be useful to other people. Hopefully this will be a weekly series
Posted by steve | 0 Comments
Filed under:
Wednesday, November 28, 2007 10:21 AM

Two Projects

I have decided that the best way to have a more interactive community blog is to have posts that follow a project from start to finish. To accomplish this goal and because I know I get board if I only have one project I decided to start posting about
Posted by steve | 1 Comments
Filed under: ,
More Posts Next page »