自动将数据从.csv文件迁移到SQLServer

本文介绍了自动将数据从.csv文件迁移到SQLServer的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我需要帮助.我是C#和MS SQL Server的新手.我需要完成这些步骤顺序； 1.开发一个程序以连接到.csv文件 2.建立连接后，将数据自动传输到SQL Server. 3.最后，删除.csv文件中的数据，以便准备好获取下一组新数据. 任何帮助将不胜感激.

解决方案

您可以看到此链接 点击 单击

这几乎是一个经典的ETL [ ^ ]任务 根据您的SQL Server版本，您应该考虑创建DTS程序包(旧版，SQL2000)还是SSIS程序包 在SSIS包中，您可以在Visual Studio中设计步骤，然后再部署到SQL Server中-可以很容易地实现您所描述的内容. 看看SSIS.您是否拥有使用此工具所需的所有工具?如果是这样，我建议使用此

一个简单的程序，在此处 [ ^ ].

I need help. I am very new to C# and MS SQL Server. I need to get these sequence of steps done; 1. Develop a program to connect to .csv file 2. Once connection is established transfer the data onto an SQL Server automatically. 3. Finally delete the data in the .csv file so that it is ready to get the next fresh set of data. Any help would be highly appreciated.

解决方案

You can see this links Click Click

This is pretty much a classic ETL[^] task Depending on your version of SQL Server, you should look at either creating a DTS package (legacy, SQL2000) or an SSIS package In an SSIS package, you design the steps within Visual Studio before deploying to your SQL Server - something like you''ve described could be achieved very easily. Have a look into SSIS. Do you have all the tools required to use this? If so, I''d recommend using this

A simple program described here[^].