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 here:

The solution requires putting a “Schema.ini” file in the same directory as the file you are attempting to upload, and the file HAS TO BE NAMED “schema.ini” (case insensitive). The contents of the simple text file should be as follows:

Continue reading “Import tab delimited data files directly into SQL Server via SSMS”

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 already have in SSMS.  From 9 to 5 PM it is one of your very best opportunities to learn a lot of new things, develop professionally, meet new people, enjoy a free lunch and…have a great time!

SQL Saturday, Jacksonville 2016

Come to this FREE learning opportunity!
Come to this FREE learning opportunity!

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 you get to these old packages?

VS 2012 is looking for “Project Deployment Files”…or for “Integration Services” catalogs.  We didn’t have those things before 2012.  And, we can operate without them, still.  But, how? Continue reading “Importing (old) SSIS packages into VS 2012”