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 excel into SQL? AceOleDb…that’s how. Continue reading “Direct query to excel (AceOleDb.dll)”
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”