See the companion tutorial video, Format Multiple SSRS Table Fields Edit: I have been proven wrong! Which is a good thing! Mark Bradbourne points out that there IS a way to format multiple fields within the dialogue, using the Properties dialogue (instead of Textbox Properties), and he has provided this handy video. I love the hivemind. […]
Category: sql server
Tip: Connect to dBASE files in SSIS
This has come up several times in the course of the last TWO jobs, so I’ll put it here for my reference (and yours). To use a dBASE file as a source in SSIS (and I know you want to), in your new connection manager: Select Native OLE DB\Microsoft Jet 4.0 OLE DB Provider . […]
The Right Level of “Right”
…or, How I Learned to Stop Worrying and Love the Bomb I had a SQL dev’s dream come to me via email yesterday: a high-urgency, high-profile request for data that was both interesting and doable. I spent a few hours on it last night and this morning, and handed over a beautiful solution that was […]