dynamiczip:install:mods:release:build72:sql_optimized_import
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
dynamiczip:install:mods:release:build72:sql_optimized_import [2015/04/06 21:05] – external edit 127.0.0.1 | dynamiczip:install:mods:release:build72:sql_optimized_import [2021/10/27 16:29] (current) – [Access Denied] chuck | ||
---|---|---|---|
Line 5: | Line 5: | ||
The SQL Optimized Import((Introduced with [[dynamiczip: | The SQL Optimized Import((Introduced with [[dynamiczip: | ||
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. | + | * 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 beleive 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.1428354334.txt.gz · Last modified: 2015/12/14 23:00 (external edit)