Dts_CommerceDB_Transaction_SecurityRole.sql Script
Run this script against the Transaction database. For instructions, see Scripts for Securing Databases Accessed by DTS Tasks.
This script creates the DTS_ImportRole on the Transaction database. Add the user who is going to run the Transaction data import DTS task to this role.
The Dts_CommerceDB_Transaction_SecurityRole.sql script grants the DTS_Import role Select permissions on the following Transaction database tables:
OrderFormHeader
OrderFormLineItems
OrderGroup
OrderGroupAddresses
TransCategory
TransDimension
See Also
Permissions Required to Run DTS Tasks
Copyright © 2005 Microsoft Corporation.
All rights reserved.