1

Topic: Import excel is possible, csv is immediate in basis on sql the server with remote ?

The people, are what  a method  to import excel, csv files immediately to basis on mssql with  being in a network?
Earlier I at first drove files through ftp on a local computer on which is installed sqlserver, pushing all commands in  using xp_cmdshel.
Then imported through bulk csv files or xls on columns using . excel the provider on mssql.
Now it is all not .
Is what  other variants?

2

Re: Import excel is possible, csv is immediate in basis on sql the server with remote ?

Alex123F wrote:

is what  other variants?

ssis?

3

Re: Import excel is possible, csv is immediate in basis on sql the server with remote ?

It is possible still in filestream filetable to load, and then  the data any CLR .

4

Re: Import excel is possible, csv is immediate in basis on sql the server with remote ?

wrote:

it is passed...
ssis?

In ssis all to a campaign is calculated on local .

5

Re: Import excel is possible, csv is immediate in basis on sql the server with remote ?

Generally I load in the sql-server excel a file with 3000 lines through  where  thrust in  the container.
At the same time I fulfill handling line by line all 15 minutes last. It long therefore the task was to separate loading from handling.
Handling thrust in procedure on the server.
But pure loading through  all the same lasts about 5 minutes.
If to do loading in procedure on sql the server through bulk that loading goes any second.
But it is possible only from a local disk.
Therefore there was a question how still to make fast loading in sql the server.

6

Re: Import excel is possible, csv is immediate in basis on sql the server with remote ?

Alex123F wrote:

generally I load in the sql-server excel a file with 3000 lines through  where  thrust in  the container.
At the same time I fulfill handling line by line all 15 minutes last. It long therefore the task was to separate loading from handling.
Handling thrust in procedure on the server.
But pure loading through  all the same lasts about 5 minutes.
If to do loading in procedure on sql the server through bulk that loading goes any second.
But it is possible only from a local disk.
Therefore there was a question how still to make fast loading in sql the server.

And you do not load on 1 line. And load bulk.
http://blog.devart.com/using-batch-oper … nents.html

7

Re: Import excel is possible, csv is immediate in basis on sql the server with remote ?

Alex123F wrote:

it is passed...
In ssis all to a campaign is calculated on local .

network  a folder
Or
Fulfill the first  cmd copying of a remote folder in the local

8

Re: Import excel is possible, csv is immediate in basis on sql the server with remote ?

Alex123F;
If you in the domain, start up service MSSQL from the user or a service account (Managed Service Account), having the right to access to the network directory. Without the domain it is possible to get on each server on the local user with an identical name and the password, and on a source to grant the rights of reading to the directory ( and network), and on the receiver to start up from the appropriate user service.

9

Re: Import excel is possible, csv is immediate in basis on sql the server with remote ?

rnk wrote:

Alex123F;
If you in the domain, start up service MSSQL from the user or a service account (Managed Service Account), having the right to access to the network directory. Without the domain it is possible to get on each server on the local user with an identical name and the password, and on a source to grant the rights of reading to the directory ( and network), and on the receiver to start up from the appropriate user service.

. I will try so.

10

Re: Import excel is possible, csv is immediate in basis on sql the server with remote ?

I in thoughts, whether am possible similar implementation through java-web application of type excel-import to basis with  what  a servlet of the container of type glassfish.

11

Re: Import excel is possible, csv is immediate in basis on sql the server with remote ?

Alex123F wrote:

I in thoughts, whether am possible similar implementation through java-web application of type excel-import to basis with  what  a servlet of the container of type glassfish.

me, ...

12

Re: Import excel is possible, csv is immediate in basis on sql the server with remote ?

the server for example

13

Re: Import excel is possible, csv is immediate in basis on sql the server with remote ?

[quote =] but pure loading through  all the same lasts about 5 minutes.
If to do loading in procedure on sql the server through bulk that loading goes any second.

And ? It is a pity another's 5 minutes? smile Let wait, .
To interpose line by line it it is normal, if it not  records. It is possible to check valuably an insertion and to react to errors.