Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 A challenge

Author  Topic 

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2014-03-05 : 03:57:00
We have a team member who is keen to improve their SQL server skills. The main areas that we need her to work in involve SSIS and SSAS with some SSRS.

Here is the challenge, the person concerned is blind and so has problems using SSMS and other graphical tools. So I am wondering if anyone is aware of any good approaches that I could adopt. In particular is there any way of creating ssis using scripting or the command line?

TIA

steve

-----------

Insanity: doing the same thing over and over again and expecting different results.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2014-03-05 : 06:43:03
BIML is a declarative language for creating SSIS packages. Varigence offers some tools to manipulate BIML more easily, such as: http://www.varigence.com/Products/Mist/Capabilities

They have scripting capabilities but I haven't used them to know how well they'd work for your coworker. You could try contacting Varigence and see if they could help, I've met a number of the folks who work there and they're awesome.
Go to Top of Page

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2014-03-07 : 04:19:42
Thanks Rob I'll give that a try

-----------

Insanity: doing the same thing over and over again and expecting different results.
Go to Top of Page
   

- Advertisement -