SSIS - Send Errors to Message Box
While in the process of developing SSIS packages it’s likely you will deal with errors occasionally unless you’re the Superstar...
2009-11-07
1,357 reads
Devin Knight
SSIS - Data Provider Does Not Allow Parameters in OLE DB Source
I recently worked on a project that involved loading a Data Warehouse from a DB2 source. In this project we...
2009-11-07
848 reads
SSRS - Setting Default Parameter Values for Analysis Services Datasets
When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult...
2009-10-23
7,086 reads
Post SQL Saturday #21 Orlando
Today I gave a two part session at SQL Saturday in Orlando. When originally planning this years event Andy Warren said many people who...
2009-10-17
1,323 reads
SQL Saturday #21 Orlando
It’s that time again! SQL Saturday has returned to Orlando with an all star group of speakers http://www.sqlsaturday.com/schedule.aspx. The event...
2009-10-07
742 reads
SQL Server 2008 Change Data Capture
SQL Server 2008 has a new Change Data Capture feature that allows you to track Inserts, Updates, and Deletes on...
2009-10-05
2,384 reads
Adding a folder to the SSIS Package Store
The SSIS Package Store is a nice option available for storing SSIS packages. The Package Store lists packages stored on...
2009-09-28
6,341 reads
SSIS - Data Provider Does Not Allow Parameters in OLE DB Source
I recently worked on a project that involved loading a Data Warehouse from a DB2 source. In this project we...
2009-09-23
1,835 reads
Error Importing DTS package in SQL Server 2008
Opening DTS packages on a 2008 SQL Server requires several steps to be able to view the packages in a...
2009-08-26
1,582 reads
Does File Exist Check in SSIS
A very common need in SSIS is to check to see if a file exist before you run what could be...
2009-08-11
15,180 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers