• joepacelli (8/31/2015)


    One of the items I know I am tasked to perform will be designing the backend database, creating the SSIS scripts to extract the data from existing xls and sharepoint site.

    Since this is a new project, no DB currently exists, so my role is sort of a Database Administrator/Developer

    So I would most likely want to build tables, test the SSIS packages without impacting the other developers on the DEV server.

    From my point of view this has always been easier to perform on your local development system, before deploying it to the DEV server

    If you have appropriate permissions on the DEV server, you should be fine.

    Gerald Britton, Pluralsight courses