August 31, 2015 at 8:16 am
I've start a new job as a contractor for a company for a new project.
I'm setting up my development PC and everything here requires you to request software you want to install.
If it's not listed I need to put a request in for it.
The only thing available is SSMS. SQL Server is not on the list of installable software.
The problem is this project requires me to develop items using SSIS
I've put the request in to be allowed to install SQL Server 2008 so I can select SSIS and BIDS to be installed on my development PC.
But I still won't have local administrator access on my development PC.
Will this be a problem? Do I need to request to be a local administrator on my development PC?
From what I've been told it's not very easy or from what I heard, even possible to get admin rights.
Will this hinder my daily duties to perform and development SSIS packages?
August 31, 2015 at 9:21 am
joepacelli (8/31/2015)
I've start a new job as a contractor for a company for a new project.I'm setting up my development PC and everything here requires you to request software you want to install.
If it's not listed I need to put a request in for it.
The only thing available is SSMS. SQL Server is not on the list of installable software.
The problem is this project requires me to develop items using SSIS
I've put the request in to be allowed to install SQL Server 2008 so I can select SSIS and BIDS to be installed on my development PC.
But I still won't have local administrator access on my development PC.
Will this be a problem? Do I need to request to be a local administrator on my development PC?
From what I've been told it's not very easy or from what I heard, even possible to get admin rights.
Will this hinder my daily duties to perform and development SSIS packages?
It shouldn't though it will make life a little harder. You need to get the SQL Server client tools installed (all of them, includes BIDS and SSMS).
Gerald Britton, Pluralsight courses
August 31, 2015 at 9:35 am
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
August 31, 2015 at 9:40 am
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
September 8, 2015 at 8:00 am
I've finally finshed building my Development PC and did some preliminary testing of my permissions on my development box.
I ran into issue's as expected.
I did 4 tests
SourceDestination StatusError
ExcelOle DB Destination Failure[Excel Source [1]] Error: The "output column "Readout Call Comments" (114)" failed because truncation occurred, and the truncation row disposition on "output column "Readout Call Comments" (114)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
Sharepoint Ole DB Destination Success
ExcelSQL Server DestinationFailure[SQL Server Destination [966]] Error: Unable to bulk copy data. You may need to run this package as an administrator.
Sharepoint SQL Server DestinationFailure[SQL Server Destination [476]] Error: Unable to bulk copy data. You may need to run this package as an administrator.
The first one would require me to modify the TypeGuessRows in my registry. Unfortunately we as developers do not even have adminstrator rights on our development pc's So I can not modify this.
The last 2 would require me to run VS 2008 as adminstrator. Again same problem as above, I do not have administrative rights on my development PC.
So I'm trying to justify why as a developer I need administrative rights on my development PC
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply