Category Archives: SSIS

All things SSIS

Import tab delimited data files directly into SQL Server via SSMS

Recently, I wanted to bring data into a SQL Server table, and I wanted to do so w/o SSIS. I know that I had done this before, but, of course, I had forgotten the details. I found the best answer … Continue reading

Posted in SQL 2000, SQL 2005, SQL 2008, SQL 2012, SQL Administration, SSIS | Tagged , , | Leave a comment

SQL Saturday May 2016, Jacksonville, FL

Hey, Everyone… our annual get-together of SQL professionals is happening on May 7th, at UNF, here in Jacksonville.  I will be speaking at 9 AM on breaking into the world of Azure & PowerBI, using (mostly) the skills you likely … Continue reading

Posted in Azure, Career, Performance Tuning, PowerBI, SQL Administration, SSAS, SSIS, SSRS | Leave a comment

Direct query to excel (AceOleDb.dll)

So, often you need to get excel data into SQL ‘in a hurry’ for analysis.  After you’ve done a base case analysis you can go about getting the data in a more ‘regular’ fashion.  What’s the fastest way to get an … Continue reading

Posted in SSIS | Tagged , , , , | Leave a comment

Importing (old) SSIS packages into VS 2012

SQL 2012 introduced a new deployment model.  Many of us, for various reasons didn’t move along with Microsoft…and continued to use and deploy the old SSIS Packages (.dtsx) … even to SQL 2012.  So, that being the case, how do … Continue reading

Posted in SQL 2012, SQL Administration, SSIS | Tagged , , | Leave a comment

New 2008 r2 Install SSIS “Failed to retrieve data for this request.”

You might also get: “The SQL Server instance specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer.”  To resolve this…

Posted in SQL Administration, SQL Clustering, SSIS | Leave a comment

Ways to run SSIS packages (and their 64/32 bit impact):

There are many ways and twists and turns on how to get an SSIS to run and 64/32 makes even more… Continue reading

Posted in SSIS | Tagged , | Leave a comment