What do I need to develop with SSIS on a new machine?
I would: Remove the Express Edition of the SQL Server;Install (if you can, in full) the SQL Server 2008 R2 Developer Edition and patch it (if you cannot install the full, then make sure you take the shared components complete); At this stage you must be able to use the Business Intelligence Development Studio (found in the SQL Server 2008 install folder under the Start menu) to develop both, the SSIS projects and SSRS reports. VS2010 will be able to let you develop against the SQL Server 2012 but you also need to install the shared components then at least. Arthur My Blog
March 28th, 2012 4:21pm

I currently have numerous SSIS packages that have been developed in VS 2005. My databases are all Sql Server 2008, and will be migrated to Sql Server 2012 some time this year. I have SSRS reports that are developed in VS 2008, and I have Sql Server 2008 Express on my local (old) machine. When I try to do an SSIS package in VS 2008, it states, "To design Integration Services packages in Business Intelligence Development Studio, Integration Services has to be installed by one of these editions of Sql Server 2008: Standard, Enterprise, Developer, or Evaluation." We just got new computers (Win 7, 64-bit), with VS 2010 only. I know that VS 2010 does not do BI type projects. What do I need to install on my new machine to be able to work with both SSRS and SSIS Packages? thanks
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2012 9:20am

Hi, For SSRS and SSIS you need Business Intelligence Development Studio, which is also known as BIDS. You can install it from the SQL Server install disks and it is a part of the Management Tools. You don't need a separate licence to use BIDS. Seth http://lqqsql.wordpress.com
March 31st, 2012 9:30am

I would: Remove the Express Edition of the SQL Server;Install (if you can, in full) the SQL Server 2008 R2 Developer Edition and patch it (if you cannot install the full, then make sure you take the shared components complete); At this stage you must be able to use the Business Intelligence Development Studio (found in the SQL Server 2008 install folder under the Start menu) to develop both, the SSIS projects and SSRS reports. VS2010 will be able to let you develop against the SQL Server 2012 but you also need to install the shared components then at least. Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2012 9:31am

Any idea how I obtain the Developer edition? Also, I was reading about the 2008 Dev version, and it talks about limitations in regards to production vs test environments. My plan is to develop on my local machine, against a test database on another machine. Once working, I copy the dtsx package to the production machine, and add the job there. Does this flow still work with the Dev edition? The Developer Edition is an exact equivalent to the Enterprise edition (w/o the go live/production rights) which is possible to obtain using at least two methods: The MSDN subscription (e.g. if you or your company has it then typically, the SQL Server Dev is part of it), orYou can find a MS authorized reseller (e.g. in the US: https://partner.microsoft.com/us/40014697).Arthur My Blog
April 2nd, 2012 8:49pm

We decided to go with Sql Server 2012, and my network guy installed 2012 Express on my system, along with SSDT. I have successfully migrated my SSRS project to VS2010, but I still cannot do SSIS. What do I need to get BIDS or SSDT to work on SSIS at this point?
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2012 7:58am

SSIS Designer and runtime is not included/supported by 2012 Express. You need to install those tools from one of the other editions. http://msdn.microsoft.com/en-us/library/cc645993.aspx#SSIS Insight: The ability to see a thrilling adventure where others see only a near-death experience
April 8th, 2012 8:50am

Ok, so I need to get 2012 Standard then? Also, will my SSIS packages work against a 2008 instance of Sql Server? I just saw another thread talking about that.
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2012 8:53am

Dev edition would be fine, or any other 2012 edition other than Express. Your 2012 packages would need to run on a 2012 Integration Services instance but could use 2008 databases as source/destinations. Insight: The ability to see a thrilling adventure where others see only a near-death experience
April 8th, 2012 8:55am

Any idea how I obtain the Developer edition? Also, I was reading about the 2008 Dev version, and it talks about limitations in regards to production vs test environments. My plan is to develop on my local machine, against a test database on another machine. Once working, I copy the dtsx package to the production machine, and add the job there. Does this flow still work with the Dev edition?
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2012 9:21am

As long as your production machine has a non-Dev, non SSIS Express edition installed on it. Just make sure that if you are creating packages with developer edition and running on standard edition that you realize which features are only available for Enterprise. Dev = Enterprise and you can get a rude suprise when you attempt to deploy on standard sometimes. Insight: The ability to see a thrilling adventure where others see only a near-death experience
April 8th, 2012 9:36am

Any idea how I obtain the Developer edition? Also, I was reading about the 2008 Dev version, and it talks about limitations in regards to production vs test environments. My plan is to develop on my local machine, against a test database on another machine. Once working, I copy the dtsx package to the production machine, and add the job there. Does this flow still work with the Dev edition? The Developer Edition is an exact equivalent to the Enterprise edition (w/o the go live/production rights) which is possible to obtain using at least two methods: The MSDN subscription (e.g. if you or your company has it then typically, the SQL Server Dev is part of it), orYou can find a MS authorized reseller (e.g. in the US: https://partner.microsoft.com/us/40014697).Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2012 2:00pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics