admin管理员组

文章数量:1122832

I have read-only access to a Microsoft SQL Server 2022 instance - that is, one database within the instance that I have permissions to connect to with SSMS and run queries against - and I would like to routinely (once a day would suffice) copy a handful of tables (or really a subset of the data therein, using dates to limit the results) to a local SQL Server which I have full control over.

The local SQL Server would act as a data warehouse of sorts which I use for SSRS and Power BI.

Before I go down the path of using SSIS to import .csv files every day, is there an easier way? I don't believe linked servers are an option for me due to permissions.

本文标签： ssisReplicate tables from readonly SQL Server instance to local SQL ServerStack Overflow

版权声明：本文标题：ssis - Replicate tables from read-only SQL Server instance to local SQL Server - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736307509a1933335.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。