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!
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”
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… Continue reading “New 2008 r2 Install SSIS “Failed to retrieve data for this request.””
What ARE the ways to run SSIS packages? Actually, I can think of 5…