Showing posts with label packages. Show all posts
Showing posts with label packages. Show all posts

Wednesday, March 21, 2012

Install DTS packages on development machine

I would like to install the components I need to develop a SSIS custom component. Is there an SDK or install option for just the visual studio components?

There is no seperate redistributable or SDK for SSIS. There is actually an SDK folder that gets installed, normally C:\Program Files\Microsoft SQL Server\90\SDK which has SSIS related assemblies for referencing, but I am not sure which install option gives you this. I suggest you run setup and select "Integration Services" and also "Workstation Components..."

A nice blog post about installing SSIS and some of the options-

Michael Entin's WebLog : Why do I get "product level is insufficient..." error when I run my SSIS package?
(http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx)

Friday, March 9, 2012

Inside a project you lose the control?

I've got a project with 12 packages. One of them runnning and at the same time when I try to alter another one or even add a new task I see that all the tasks on toolbox are disabled.

Why?

I would like to hear a good reason for this behaviour, afaik I don't get the point...

Often the packages in one project call into each other, so if one of them is currently executing - there is a good chance others will be running as well. Although I agree this might be too restrictive sometimes - please file a suggestion to relax this behavior for next version.|||

Michael Entin - MSFT wrote:

please file a suggestion to relax this behavior for next version.

suggestions may be submitted here: https://connect.microsoft.com/feedback/default.aspx?SiteID=68