“Errors in the metadata manager. The ‘Report Metrics’ (some name) measure group has more than one distinct count measure.”   When you create a new measure that uses ‘Distinct Count’, Business Intelligence Development Studio (BIDS) automatically creates a new measure group for you. But when you try to change the usage of an existing measure... » read more

Flat File Splitter

At work the other day, I needed to write a program for splitting a text file (.txt) to smaller pieces. The file that we received from our client was a flat file of size of about 2.5 GB. I needed to import the contents of the file to our SQL Server database.  Since the file... » read more