Actually, the question in naming the topic. Once a month, it is necessary to transfer part of the data to Access (a connected server or via OPENDATASOURCE is not considered). It is necessary for teams to be in automatic mode. What options are there?

    4 answers 4

    I can offer another option - the BatchAccess utility can import into the MSAccess table from a CSV file.

    https://rsdn.ru/article/files/progs/BatchAccess.xml

    Sources also have (C #), so you can finish to the desired functionality.

      An elementary application is written on Aktsess, which, without user interaction, copies data from the SQL server to anywhere and terminates, the application is launched from the command line, or by the time scheduler. With this scheme, no user interaction is required.

      • Under the conditions, it was "not to use a linked server" - nzeemin
      • Restrictions are not absolutely clear. Linked servers cannot, OPENDATASOURCE is impossible, i.e. from stored procedure cannot be accessed. What is allowed? SQL server is spinning on some server, can you use it not only as a host for database north and run, for example, a batch file outside the database? What teams do you mean? Specify the condition. - Sergey S.

      Included with SQL Server is the "Import and Export Data" wizard - this is one-time, but as I understand it (I did not try it myself) it allows you to create an SSIS package from a complete import / export - which you can already run as many times as you like.

      • Well, I wrote some kind of command, this master will be no clap - Stolborez
      • @mamuted Did you miss the part about the SSIS package? - nzeemin 4:08 pm

      Make the SSIS integration package and create a job that will run the package when you need it.