July 13th, 2011 
When working with meta data tables it can be very useful to track when people make changes to the data. How do you track any change against any number of columns for any table? I have implemented a fairly simple solution that uses triggers and stores all changes as XML into one change log table. [...]
Archive for the ‘SQLServerPedia Syndication’ Category
Parse XML in SSIS
One of the built in data sources in in SSIS is an XML document. I started writing a package to pull data from XML stored in a SQL table. I noticed that there were several little gotchas that I had to work around to get the data the way I wanted. The XML file can [...]
Posted in SQLServerPedia Syndication, SSIS 
Tags: Microsoft, SQL, SQL 2008, SQLServerPedia Syndication, SSIS, XML, XML Source 
No Comments »Looping through files on an FTP server
I have always know that that SSIS has an FTP control Flow task, but I have never tried to use. Turn out that the task is fairly limited and can be a pain to work with. I am attempting to get a list of all files, in a folder, on an FTP server. The FTP [...]
Posted in SQLServerPedia Syndication, SSIS Tags: FTP, Microsoft, SQL, SQL 2008, SQLServerPedia Syndication, SSIS 1 Comment »Advance Search – SQL Server
As a BI Consultant, I am frequently going into new databases and writing queries against unfamiliar data sources. I have created a stored procedure that goes against the system views to help quickly find a key word in a Table, View, Columns or Stored Procedure. Once the procedure has been created you can execute it [...]
Posted in SQLServerPedia Syndication, T-SQL Tags: SQL, SQL 2008, SQLServerPedia Syndication, T-SQL No Comments »SQL Custom Keyboard Shortcuts
Keyboard shortcuts play an important role to increase the productivity, in any development environment . There are tons of shortcuts that are beneficial in SQL Server Management Studio. SSMS 2005/2008 also allow you to easily add your own keyboard shortcuts. The two shortcuts that I always create are the SELECT TOP 1000 * FROM and [...]
Posted in General, SQL, SQLServerPedia Syndication Tags: Management Studio, SQL 2008, SQLServer, SQLServerPedia Syndication 2 Comments »Reporting Services – Dynamic SQL
I am working on creating some auditing reports on our current SSIS framework. I would like to create a Reporting Services report that I can have a standard looking report and change the query based on the Package Name. To do this I created a table that contains the Package name and the validation query. [...]
Posted in SQLServerPedia Syndication, SSRS Tags: Business Intelligence, SQLServerPedia Syndication, SSRS Comments Off