If you’ve ever built an SSIS package that utilizes the Microsoft Jet Driver for an Access or Excel data source or a package that executes a SQL 2000 DTS package, you know that you must set the Run64bitRunTime property in the SSIS project properties to False. This stinks if you’re executing these kinds of child packages from a master package that also executes child packages are not required to execute in 32 bit mode. Dry your eyes, my friend, because there is a work around for this. You can down...
Read More
The Bulk Copy Program Utility (BCP) is a very nifty little command line tool that allows us to bulk copy SQL Server data from or to a data file in a user specified format. The BCP is very useful when you need to copy large amounts of data into a data file for use in other programs or if you need to back up your data in a specified format for a third party. But the BCP is also very useful when you need to copy large amounts of data from one SQL Server table to another table. There are certain cas...
If you’re not familiar with the BIDS plugin by Pragmatic Works called BI xPress, you really should check out this tool. For the small amount of money you’ll spend on BI xPress, you’ll add a ton of powerful weapons in your SSIS/SSAS development arsenal that no serious developer should be without. Since I’ve been working for Pragmatic Works for the past couple years I’ve had many opportunities to work with BI xPress. I can definitively say without a doubt that the gigs I’ve been out where I have B...
This week's puzzle was pretty straight forward, but it required you to use the OpeningPeriod function . To show the count of customers on the first day of the year, we’ll create a calculated measure called “First Day Customer Count”. WITH MEMBER [Measures].[First Day Customer Count] AS (OpeningPeriod([Date].[Calendar].[Date],[Date].[Calendar].CURRENTMEMBER),[Measures].[Customer Count]) In the above calculated measure, the first argument of the OpeningPeriod function specifies at which level we w...