Helpful information and examples on how to use SQL Server Integration Services.
In this pre-release version of SQL Server 2014, SSDT BI is no longer included in setup. For SQL Server 2014 CTP1 no new version of SSDT BI been released, however you can use the existing version of SSDT BI to create and deploy projects for SQL Server 2014 CTP1.
The Visual Studio 2012 version of SSDT BI can be download from Microsoft Download Center. This same link is also provided in the Tools section of SQL Server 2014 CTP1 setup.
Please note the following while installing SSDT BI:
· SSDT BI cannot be installed on the same machine as SQL Server 2014 CTP1.
· To deploy to a SQL Server 2014 CTP1 Server, install SSDT-BI on different machine.
I installed SSDTBI just fine on the same virtual machine as SQL Server 2014 CTP1.
Unfortunately the version of SSDT BI can not connect to SQL Server 2014 CTP1. So it is a bit looking at all the new stuff but you can not use them. And that is a shame.
I have SQL 2014 CTP1 installed on new VM environment. Then, on another new VM I have installed SSDT BI (downloaded from www.microsoft.com/.../details.aspx).
From that SSDT BI, in new SSIS package, I tried new connection manager pointing to SQL 2014 CTP1 instance But it's not connecting. I tried it with SQL Server native client 11.0.
Checked firewall, TCP/IP port, SQL browser service etc. I am not sure if I missed anything. Could you pl help.
inclined to assume same recommendation for CTP2
Looks like VS 2013 can't deploy to 2014.
Why are you guys making this stuff such a big mess, SSDT, SSDT-BI, once is part of VS once is part of SQL Server. Compatibility issues here and there. What is the roadmap for these products ?
Please be aware that there are people out there that use this stuff in enterprise productive environments and hence a consistent transparent approach and update path would be very much appreciated.
I agree with nojetlag, this is a total mess. All I want to do is use our enterprise version of Visual Studio (2013) with our enterprise version of SQL Server (2012) but I can't do this. Why are you releasing tools for 2014 when you haven't finished the ones for 2012? The installers are terrible -- I get error messages in Visual Studio 2012 because of conflicting DLLs in the GAC (IsVisualStudio2012ProInstalled() method not found) but I can't uninstall the tools because of some strange was that the x86 installer works on the instance.
I wasted hours (days actually) trying to reinstall Visual Studio 2012 and SQL Server 2012 trying to get it all to work.
I have VS 2013 with SSDT-BI. Can I deploy a integration services project to SQL 2008 R2?
Where is this documented?
Yes, i agree with nojetlag, Microsoft has made a total mess of VS SSDT & SQL 2014. Tons of metadata issues with SSIS Designer.