x

ssis for free?

Hi all. I want to study some ssis at home. Few questions. If I download SSDTBI 2012 at home, can i get this to work with SQL 2012 express? Or is it a requirement as a bare minimum to have SQL 2012 developer to be able to use SSIS? Thanks!

more ▼

asked Aug 31, 2013 at 02:50 PM in Default

avatar image

jhowe
1.1k 56 60 66

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You will be able to create and develop SSIS packages with SSDT. You don't have to have Developer Edition installed to create the packages. If you wanted to test deploying and running from within SQL then you would need at least Developer Edition to do so.

more ▼

answered Aug 31, 2013 at 02:56 PM

avatar image

Tim
40.6k 39 88 167

so just to clarify, if i wanted to build an ssis package to test importing data locally to a sql DB on my machine i would definitely need SQL 2012 developer installed... this will not work with 2012 express.

Aug 31, 2013 at 03:32 PM jhowe

I am not 100% but I would think you could specify the SQL Express database as the destination within SSDT and while validating the package it could push the data into the express database.

Aug 31, 2013 at 10:13 PM Tim

ok thanks Tim i will try it.

Sep 02, 2013 at 08:38 AM jhowe
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x367
x15
x9

asked: Aug 31, 2013 at 02:50 PM

Seen: 778 times

Last Updated: Sep 03, 2013 at 12:56 PM

Copyright 2016 Redgate Software. Privacy Policy