2005 SSIS ETL Package Execution Question

[ease20022002]

Techinically, I work in the IT department, but I am in the Financial Operations side which has a lot more business people than IT people.

I was wondering if someone who were granted rights to the sql server db would be able to initiate an SSIS ETL package without having any sql server 2005 software loaded on their pc.

Could they initiate the package via the sqlcmd utility?Any

information would be helpful.Thanks

 

[mrdenny]

No they wouldn't be able to. In order to run the package they'd need to have either the management tools, or the SSIS service installed on there computer.

Also running an SSIS package which is stored on a remote computer (a machine not your workstation) requires some extra rights on the server which the normal user wouldn't have.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog