SSIS switchboard/menu/dashboard ... ?

[BrooksMT]

I'm working on an application that will have about a dozen SSIS packages. These will be run manually on different days and times.

What are the options for putting these onto one screen with 12 buttons (1 per package) that can be clicked to launch the package?

Thx.

 

[fredericofonseca]

Thats just a straight winform (or web based) interface that you will have to build yourself

Nothing on plain SSIS to do that.

If they can run on their own without intervention then a SQL Server agent job probably the best for you

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[BrooksMT]

Thanks for the post, Frederico.

What project or template type do I need in Visual Studio to create a winform?

Is Visual Basic or Visual C# required? They do not seem to be installed on my VS.

Brooks

 

[fredericofonseca]

Any language will do - Winform - Windows Forms application - will be in any version of VS except the one supplied with SQL Server which is a cut down version just to work with SSIS.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886