1

Topic: It is necessary the general-purpose loading of their data EXCEL in MS SQL

The general task - exists a permanent job on loading of the data in SQL it is required to automate it
Files different, given different the file structure and loadings also changes.
It is necessary  the general-purpose loading of their data EXCEL in MS SQL
Requirements:
- The interface of the manager and the user
*The user - loading on the created templates
*The manager - creation of templates, determination of fields, the job of checkout scripts
- The interface of check of the data
*Check of data types with a template
*Automatic coercion of data formats EXCEL according to formats MS SQL
*The filter by data which it was not possible to lead to demanded formats with possibility of change of the data in the interface
*Check of the data on scripts, output of errors with filtration possibility (the possible: doubles of the data, mandatory fields,
*Errors at coercion of the data to reference manuals, etc.)
- Operation with more than 1 data file
- Operation with files is more 50 than lines
- Operation with files csv

2

Re: It is necessary the general-purpose loading of their data EXCEL in MS SQL

Naturally not it is for nothing)

3

Re: It is necessary the general-purpose loading of their data EXCEL in MS SQL

Grinbel;
Such program already is, is called SSIS

4

Re: It is necessary the general-purpose loading of their data EXCEL in MS SQL

bideveloper;
Very much can be that this program works how is described in my job.
But it seemed to me that it is simply package output agent. You adjust also it drives packets without the user interface

5

Re: It is necessary the general-purpose loading of their data EXCEL in MS SQL

Grinbel;
The user interface there, really, no
But actually, and what for it is necessary?
It is possible to put simply a file of a certain format in a certain folder and the job under the schedule it will process
And to spread there lines with an incorrect format which did not manage to be processed

6

Re: It is necessary the general-purpose loading of their data EXCEL in MS SQL

bideveloper;
That's it because "... Files different, given different the file structure and loadings also changes..."
In one folder can  different files, and before pushing on to "load", the person should see that loads.
Now in operation of 5 file formats for loading. Sends a file the client. File formats are similar also the most widespread error of loading - not that file and not there.

7

Re: It is necessary the general-purpose loading of their data EXCEL in MS SQL

There was an experience of similar operation
Write on mail qwertehok@gmail.com
It is desirable to specify periods and the budget

8

Re: It is necessary the general-purpose loading of their data EXCEL in MS SQL

Grinbel wrote:

in one folder can  different files, and before pushing on to "load", the person should see that loads.

Regular "the Master of import and export" and works.