Mar
16
2009

Solve some common pain points in BIDS

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 in Microsoft Support, for sending us this list recently. 1. Make that "Visual Studio is busy" message go away! Validation happens often in BIDS and can be slow, especially if you're connecting to slow or unavailable data sources. Possi... [More]
Mar
16
2009

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

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, you can also specify the "bitness" for running the package from within BIDS. The default setting is 64-bit execution. (This setting is ignored on a 32-bit computer, or if you've only installed 32-bit SQL Server on a 64-bit computer.) But on a 64-bit computer, ... [More]
Jun
18
2008

Profiles, Settings, and More Settings

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 us haven't looked closely at all the options in VS that affect our design-time experience. We tried to summarize everything that's SSIS-specific in this Books Online topic: Integration Services in Business Intelligence Development Studio. But let's do a quick... [More]