Browse by Tags

Solve some common pain points in BIDS

Published 16 March 9 3:46 PM | dougbert

Here are a few suggestions for some of the things that may be tripping you up while you're working on SQL Server Integration Services packages in Business Intelligence Development Studio (BIDS). Thanks to my buddy Jason Howell, who's an SSIS whiz...

Filed under: known issues, BIDS

Debug your packages in 32-bit or 64-bit mode

Published 16 March 9 12:28 PM | dougbert

At run time, you decide the "bitness" of Integration Services package execution on a 64-bit computer by running the 32-bit or the 64-bit version of the dtexec.exe command prompt utility. At design time in Business Intelligence Development Studio...

Filed under: 64-bit, BIDS

Profiles, Settings, and More Settings

Published 18 June 8 12:26 PM | dougbert

MVP Matthew Roche blogged the other day about the joys of discovering some useful but little-known design-time options for Integration Services in the Options dialog box for Visual Studio/Business Intelligence Development Studio. I suspect that many of...

Filed under: settings, BIDS, options, designer