KampData Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
======SQL Optimized Import======

The original [[dynamiczip:features:import:rate_and_boundary_import|Rate & Boundary Import]] was done using native Dexterity code and local c-tree temporary tables. This import could take a substantial amount of time particularly when using the [[dynamiczip:features:Zip4 Option|Zip+4 Option]]. This prompted us to create the SQL Optimized Import to minimize the time required for this process. 
 
The SQL Optimized Import((Introduced with [[dynamiczip:install:mods:release:build72:build72|Build 72]]. )) starts out by using the Transact SQL BULK INSERT command to quickly read some of the larger files included in the [[dynamiczip:glossary:rate_and_boundary_database|Rate & Boundary Database]]. 
In order for BULK INSERT to function properly: 
  * The [[dynamiczip:glossary:rate_and_boundary_database|Rate & Boundary Database]] must be located on a local drive on the SQL Server machine.
  * The  [[dynamiczip:glossary:path_on_server|Path on Server]] must be properly set in the [[dynamiczip:windows:dz_rate_and_boundary_import_window|DZ Rate And Boundary Import window]].
  * 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:** If BULK INSERT fails, the [[dynamiczip:glossary:rate_and_boundary_database|Rate & Boundary Database]] files will be read in the traditional (and slower) way. Failure of the BULK INSERT process will __not__ slow down the other import process that have been optimized. 

The Non-Optimized Import provides our users with an alternative way to perform the  [[dynamiczip:features:import:rate_and_boundary_import|Rate & Boundary Import]] should the SQL Optimized Import fail for any reason. 

===== Access Denied =====
The error message indicating that the import file cannot be opened such as:
<code/>
Cannot bulk load because the file FipsCodes.txt could not be opened. Operating system error code 5(Access is denied.)
</code>
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:install:mods:modifications|Modifications]]