Tag Archives: 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

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