May 22, 2014 at 5:56 pm
I have a personal project that performances analytics on a SQL Server (express) Db thru SSMS. I connect via an ODBC to SQL Server and create Access 2013 queries and reports of web traffic to my Web portal. The source data is from Google Analytics of various webpages, which I import to SQL Server and link to the Access Db.
I wanted to automate some of the manual extractions thru SSIS with a package that would pull in the Xcel sheets from SQL Server (or even Access). I started SQL Data Tools (SSDT) and here is my problem. When I attempt to open Package.dtsx I have an error that indicates SSDT must be installed on one of several SQL Server installation. Mine is Evaluation which I have and SSDT is installed in it.
I used SSDT to open Visual Studio 2010 and then it indicates I must have SSDT in SQL Server 2012.
Apparently I have to run SQL Server Setup and install SSDT in it. But, I don't have a setup of this type. Or at least I have not found it by searching my Windows 8.1 machine. This seems like a very elementary problem that can be fixed by a MSDN download or some pointer to where I need to go to install SSDT within SQL Server 2012.
May 23, 2014 at 1:26 am
If you want to develop SSIS in Visual Studio 2010, you need to install SSDTBI from the SQL Server setup.
Be aware that SSIS doesn't work in SQL Server express (meaning you cannot run SSIS from a SQL Server express engine).
You can however also develop SSIS packages in Visual Studio 2012 (in a shell-version) and that is a seperate download:
http://www.microsoft.com/en-us/download/details.aspx?id=36843
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 23, 2014 at 5:07 am
Just the answer I was hoping not to get. This means I'll have to buy something. I downloaded VS 2012, but it didn't seemed to be written to allow the kind of of data transfer package I described, so I uninstalled. I might have been premature in concluding this. A good u-tube tutorial just might show how VS 2012 can be used to create a data transfer package.
Koen thanks for this advice it saved me hours of time searching for what I can't have.
May 23, 2014 at 5:38 am
robleh741 (5/23/2014)
Just the answer I was hoping not to get. This means I'll have to buy something. I downloaded VS 2012, but it didn't seemed to be written to allow the kind of of data transfer package I described, so I uninstalled. I might have been premature in concluding this. A good u-tube tutorial just might show how VS 2012 can be used to create a data transfer package.Koen thanks for this advice it saved me hours of time searching for what I can't have.
SSDTBI for VS2012 is free. If you don't have visual studio 2012, it will install just a shell.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 28, 2014 at 12:03 pm
Let me clarify once again. I do have Data Tools and SQL Server 2012 (evaluation) installed. I can access Integration Services in SSMS. What I can't do is access from Data tools in Visual Studio 2010 (VS 2010) shell the Package.dtsx.
I want to be able to use the Biz Intelligence module of VS 2010 to create a data transfer package. One poster indicated the VS 2012 shell can do this. I fail to see this. I did download and install VS 2012 and didn't find I could use the shell to create a package.dtsx. Clearly, I've missed an installation or configuration procedure.
Additionally, I checked my current install of SQL Server 2012 to verify I had all the components I need to perform the project indicated and it seems fine. I have SSIS. I switched connections from Db engine to integration services with no problem. My guess is to performance an automated op, to move large datasets from external progs like Access and Xcel you must have this running thru VS 2012 (can't in 2010).
So, I'm looking for some detailed walk-thru on how I could do this with VS 2012. If so, I'll download and install it again.
May 28, 2014 at 12:40 pm
There is SQL Server Data Tools (SSDT) for database projects, and SSDT for BI projects.
Two different products, but with the same name (mostly).
With the first one, you cannot edit SSIS packages. You can only do this with SSDTBI.
For VS2010, SSDTBI is installed using the SQL Server set-up. SSDT is a seperate download.
For VS2012/13, both products are seperated downloads.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 29, 2014 at 1:56 am
Worth noting that the VS2013 version only supports SQL 2014 at the moment
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 29, 2014 at 4:46 am
Andy Hyslop (5/29/2014)
Worth noting that the VS2013 version only supports SQL 2014 at the moment
According to a comment from MSFT on this blog post, they started a project to make VS2013 backwards compatible.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 29, 2014 at 6:02 am
Koen Verbeeck (5/29/2014)
Andy Hyslop (5/29/2014)
Worth noting that the VS2013 version only supports SQL 2014 at the momentAccording to a comment from MSFT on this blog post, they started a project to make VS2013 backwards compatible.
Good to know that they will be sorting this out (although I notice there is no firm release date) as is causing me a right headache working in VS2012 for SSIS & SSRS and VS2013 for other projects
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 29, 2014 at 7:25 am
Koen, I can download SSDT for BI separately somewhere I guess? I know when I check my SQL Server 2012 configuration SSIS is installed, but I don't see any way to install SSDTBI in the SQL Server setup interface.
This may be a question of many acronyms confusing the issue, but you seem to be indicating that SSDT BI is a separate download that can then be included in VS 2010.
May 30, 2014 at 1:09 am
When you run the SQL Server set-up, SQL Server Data Tools is mentioned in the list of features you can install. That is the one you need for VS2010.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 30, 2014 at 8:05 am
To Koen and all other responders. My problem is solved!!
I simply performed another download and installation of SQL Server 2012 on my 2nd computer which is a win 7 not win 8 device and carefully indicated to include SSIS BI during the installation process and I now have a working package in VS 2010.
Thanks to you Koen for the helpful advice along the way.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply