k*****n
发帖数: 361 | 1 从一个SQL server move 数据到另一个 SQL server，目的地SQL server有个database
owner dbo权限
但是存放SSIS package指定好目的地SQL server还是出错说没有SSIS execute
permission
是要和dba说加SSIS permission还是有另外的办法？
试过存在自己local 的PC上肯定不行，对不？ |
B*****g
发帖数: 34098 | 2 放jackrun
database
【在 k*****n 的大作中提到】
: 从一个SQL server move 数据到另一个 SQL server，目的地SQL server有个database
: owner dbo权限
: 但是存放SSIS package指定好目的地SQL server还是出错说没有SSIS execute
: permission
: 是要和dba说加SSIS permission还是有另外的办法？
: 试过存在自己local 的PC上肯定不行，对不？
|
j*****n
发帖数: 1781 | 3 did not quite understand your question.
are you saying permission issue for your package connection manager or the
server you want to have the package itself to be stored?
database
【在 k*****n 的大作中提到】
: 从一个SQL server move 数据到另一个 SQL server，目的地SQL server有个database
: owner dbo权限
: 但是存放SSIS package指定好目的地SQL server还是出错说没有SSIS execute
: permission
: 是要和dba说加SSIS permission还是有另外的办法？
: 试过存在自己local 的PC上肯定不行，对不？
|
i*****w
发帖数: 75 | 4 1) put the ssis packages in a local folder on the server, use configuration
file, this will make your promotion much easier
2) Be sure that the service account that is executing the job has the
correct access rights to your data sources specified in your configuration
managers (in the configuration file)
3) Or create a proxy account on Integration services after creating a
credential with a domain account that has the right to read the data source,
then run the job with the proxy account.
Since the data sources could be on remote servers so it's important to have
the right access setup.
HTH
database
【在 k*****n 的大作中提到】
: 从一个SQL server move 数据到另一个 SQL server，目的地SQL server有个database
: owner dbo权限
: 但是存放SSIS package指定好目的地SQL server还是出错说没有SSIS execute
: permission
: 是要和dba说加SSIS permission还是有另外的办法？
: 试过存在自己local 的PC上肯定不行，对不？
|
