Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS tasks installation Expand / Collapse
Author
Message
Posted Friday, May 2, 2014 9:43 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:34 AM
Points: 4,613, Visits: 11,015
I'm seeking help from a real SSIS expert, which I'm not to any extent.
I recently developed an open source project called "Extended TSQL Collector" and can be found here https://extendedtsqlcollector.codeplex.com
The purpose of the project is to provide a new collector type to the built-in Data Collector collectors to work around some limitations.
Basically, a collector type is made of two SSIS packages: one to collect the data and one to upload it to the MDW database.
In my case, both packages are invoking an external application which takes care of everything. To invoke the application, I use an execute process task.
Everything works fine when the SSIS components are installed, but fails when SSIS is missing, which is understandable to some extent.
What puzzles me is that the other built-in collector types work flawlessly even if SSIS is not installed.

  • Which tasks are installed with the database engine services and don't need to be installed with SSIS?

  • Is there a way to install the Execute Process Task other than installing SSIS?

  • Can I programatically check if a SSIS task is installed?




--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1567091
Posted Friday, May 2, 2014 10:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:05 AM
Points: 2,419, Visits: 6,715
Chio, you could compare the installation logs from the different instances to track down the difference. I'll try out your component on a vanilla system and let you know the results.
Post #1567106
Posted Friday, May 2, 2014 11:03 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:34 AM
Points: 4,613, Visits: 11,015
Thanks for the hint.
Actually, everything in %programfiles%\Microsoft SQL Server\110\DTS\Tasks is missing in a system without SSIS components.
Searching the registry I found that each task has many entries and I suppose that they have to be registered.


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1567126
Posted Monday, May 5, 2014 2:13 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 13,562, Visits: 11,372
I would assume that if you want to run an SSIS package, SSIS needs to be installed.

What exactly do you mean with this?

other built-in collector types work flawlessly even if SSIS is not installed.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1567438
Posted Monday, May 5, 2014 2:40 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:34 AM
Points: 4,613, Visits: 11,015
All the built-in collector types use SSIS packages to collect and upload data, but you don't have to install SSIS to make them work.
Looking in the installation folder of SQL Server, I see some tasks DLLs. The "Execute Process Task" is not there.

I suppose that the tasks needed for the built-in collectors and the maintenance plans are installed with the "database engine" components, while all the other tasks are installed only with the SSIS components.


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1567441
Posted Monday, May 5, 2014 3:27 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 13,562, Visits: 11,372
spaghettidba (5/5/2014)
All the built-in collector types use SSIS packages to collect and upload data, but you don't have to install SSIS to make them work.
Looking in the installation folder of SQL Server, I see some tasks DLLs. The "Execute Process Task" is not there.

I suppose that the tasks needed for the built-in collectors and the maintenance plans are installed with the "database engine" components, while all the other tasks are installed only with the SSIS components.


Ah yes, you have the "basic" components needed for maintenance plans and the import/export wizard, but anything beyond that needs the installation of SSIS. Is the Execute Process Task needed? Can you start the process with a batch file?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1567445
Posted Monday, May 5, 2014 3:49 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:34 AM
Points: 4,613, Visits: 11,015
Thanks for the input.
I need the execute process task, unless there's another way to execute a process. How would a batch file help me here?


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1567454
Posted Monday, May 5, 2014 3:51 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 13,562, Visits: 11,372
A batch file can start a process, just like an Execute Process Task.
You have to call the batch file out of SSIS though.

How is the SSIS package currently started?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1567455
Posted Monday, May 5, 2014 4:15 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:34 AM
Points: 4,613, Visits: 11,015
I see what you mean...
It is started by a process named DCEXEC.EXE which controls the Data Collector collection sets.
DCEXEC is invoked by a SQL Agent job generated automatically by the Data Collector configuration.
I could change the jobs directly, but it wouldn't reflect the changes in the Data Collector configuration and it would be overwritten by changes in the Data Collector config window.


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1567459
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse