dynamiczip:install:mods:release:build72:sql_optimized_import
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
dynamiczip:install:mods:release:build72:sql_optimized_import [2015/12/14 23:04] – chuck | dynamiczip:install:mods:release:build72:sql_optimized_import [2021/10/27 16:29] (current) – [Access Denied] chuck | ||
---|---|---|---|
Line 6: | Line 6: | ||
In order for BULK INSERT to function properly: | In order for BULK INSERT to function properly: | ||
* The [[dynamiczip: | * The [[dynamiczip: | ||
- | * The [[dynamiczip: | + | * The [[dynamiczip: |
* The user running the import must be assigned the bulkadmin Server Role for the SQL Server. This roll must be assigned to the Microsoft Dynamics GP user's login ID. | * The user running the import must be assigned the bulkadmin Server Role for the SQL Server. This roll must be assigned to the Microsoft Dynamics GP user's login ID. | ||
**IMPORTANT: | **IMPORTANT: | ||
- | Although maintaining two versions will be extra work, we believe it will be a great way for us to catch errors in the import process. | + | The Non-Optimized Import provides our users with an alternative way to perform the [[dynamiczip: |
+ | ===== Access Denied ===== | ||
+ | The error message indicating that the import file cannot be opened such as: | ||
+ | < | ||
+ | Cannot bulk load because the file FipsCodes.txt could not be opened. Operating system error code 5(Access is denied.) | ||
+ | </ | ||
+ | seems to typically be related to the security context under which the SQL Server service is running. Switching the SQL Server login to Local System Account may eliminate the error. | ||
---- | ---- | ||
[[dynamiczip: | [[dynamiczip: |
dynamiczip/install/mods/release/build72/sql_optimized_import.1450134274.txt.gz · Last modified: 2015/12/14 23:04 by chuck