I have some questions about importing data from Excel/CSV File into SQL Server. Let me first explain the overall scenario.
我有一些关于将数据从Excel / CSV文件导入SQL Server的问题。首先让我解释一下整体情况。
We receive data from multiple sources and in either Excel/CSV format. This data is to be imported into SQ Server into a table. Because we receive the data from multiple sources we have a requirement to map the columns in the Excel files to the columns in our SQL Server table.
我们从多个来源以Excel / CSV格式接收数据。此数据将导入SQ Server到表中。因为我们从多个源接收数据，所以我们需要将Excel文件中的列映射到SQL Server表中的列。
I understand that either DTS or the Import / Export wizard is the way to import this data if we were to do this import manually. But I have the following questions
我知道如果我们手动执行此导入，DTS或导入/导出向导是导入此数据的方法。但我有以下问题
-
Are there alternatives available to DTS/Import export wizard?
DTS / Import导出向导是否有其他选择？
-
If I were to write an application for importing data what are the .net framework classes that I would or could use? For some reason I don't want to use or build a SQL script within the application. What would be the best way of going about doing this?
如果我要编写一个导入数据的应用程序，我会或可以使用哪些.net框架类？出于某种原因，我不想在应用程序中使用或构建SQL脚本。这样做的最佳方式是什么？
-
Is there any way we can reduce the effort involved in mapping data?
有什么办法可以减少映射数据的工作量吗？
Any suggestions, help would be most welcome
任何建议，帮助将是最受欢迎的
Regards
问候
Romi
罗米
1 个解决方案
#1
2
Are there alternatives available to DTS/Import export wizard? -- bulkinsert.
DTS / Import导出向导是否有其他选择？ - bulkinsert。
If I were to write an application for importing data what are the .net framework classes that I would or could use? For some reason I dont want to use or build an SQL Script within the application. What would be the best way of going about doing this? -- SSIS.
如果我要编写一个导入数据的应用程序，我会或可以使用哪些.net框架类？出于某种原因，我不想在应用程序中使用或构建SQL脚本。这样做的最佳方式是什么？ - SSIS。
Is there any way we can reduce the effort involved in mapping data? -- ?
有什么办法可以减少映射数据的工作量吗？ - ？
SSIS is a very powerful tool. May want to explore that option first. You can even build custom component using .net as well.
SSIS是一个非常强大的工具。可能想先探索这个选项。您甚至可以使用.net构建自定义组件。
#1
2
Are there alternatives available to DTS/Import export wizard? -- bulkinsert.
DTS / Import导出向导是否有其他选择？ - bulkinsert。
If I were to write an application for importing data what are the .net framework classes that I would or could use? For some reason I dont want to use or build an SQL Script within the application. What would be the best way of going about doing this? -- SSIS.
如果我要编写一个导入数据的应用程序，我会或可以使用哪些.net框架类？出于某种原因，我不想在应用程序中使用或构建SQL脚本。这样做的最佳方式是什么？ - SSIS。
Is there any way we can reduce the effort involved in mapping data? -- ?
有什么办法可以减少映射数据的工作量吗？ - ？
SSIS is a very powerful tool. May want to explore that option first. You can even build custom component using .net as well.
SSIS是一个非常强大的工具。可能想先探索这个选项。您甚至可以使用.net构建自定义组件。