SSIS is a pretty useful tool for designing ETL processes, but one of the transformations I was disappointed with in 2005 was the lookup. It was a little better than the lookup functionality in DTS, ...

Then SSIS will use the cache to satisfy the actual lookups giving a significant performance gain. Of course, there must be enough memory available to store the results of the lookup query and it must ...

Our parts and finished goods inventory is managed by an ERP system built on a SQL Server back end and a .NET/Access Runtime client that runs on Windows. Sometimes I need to wander through the ...

I need to return a query set that contains username, organizationname, and rolename for a given userid. Can someone give me a shove in the right direction? I've been out of full time dev for way too ...