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
840 reads
Blog Posts
SSIS - Fast Parse
I had another chance last week to answer an email follow up question from the session Brian and I gave...
2009-11-07
852 reads
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,338 reads
SSIS – Avoid OLE DB Command
I decided to do a little performance testing on some common SSIS “Tricks” that increase speed and effectiveness of SSIS...
2009-11-07
2,754 reads
Tampa Code Camp 2009
I presented a 1 hr session at Tampa Code Camp 2009: PowerShell for Developers In this sesssion we will look...
2009-11-07
653 reads
Thursday at the PASS Community Summit
The last full day of the 2009 PASS Community Summit was the first day I have had at the conference...
2009-11-07
697 reads
Worldwide Operating System Market Share for October 2009
Ars Technica has a good post up showing that Windows 7, (which has been out for two weeks) has already...
2009-11-07
1,455 reads
Geek of the Week
I made geek of the week. I’m sorry, but I’m excited by that. I’m very proud to be a geek....
2009-11-06
647 reads
Great Post on Parallel vs.. Series SSIS
Mike Davis, Author and consultant extraordinaire recently posted a great new take on parallel vs. series SSIS packages. Some interesting...
2009-11-06
523 reads
Identity Issues
Have you ever received the following Error when developing your ETL or working with data cleanup?
Msg 544, Level 16, State...
2009-11-06
358 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers