data from CSV to sql server

Hi,
Best way to get your CSV files onto a DASP SQL Server is to import them locally then Export to the remote.
There are several ways to do this.
I wouldn't recommend importing records from CSV anyway other than manually.
SQL Server 2000 does a nice job of it but I've seen flat file "issues" many times.</o>
This is the way I once got Oracle records into a remote SQL Server 2000 DB:</o>

1. 
   <LI style="MARGIN: 0in 0in 0pt; BACKGROUND: white; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in" class=MsoNormal>Export CSV from Oracle as comma delimited.</o>
   <LI style="MARGIN: 0in 0in 0pt; BACKGROUND: white; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in" class=MsoNormal>From SQL 2000 MS import CSV files.</o>
   <LI style="MARGIN: 0in 0in 0pt; BACKGROUND: white; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in" class=MsoNormal>Use a local Trigger to filter the records then place them into a temp DB.</o>
   <LI style="MARGIN: 0in 0in 0pt; BACKGROUND: white; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in" class=MsoNormal>Use a Stored Procedure to check the records then migrate then into the production DB.</o>
   <LI style="MARGIN: 0in 0in 0pt; BACKGROUND: white; COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in" class=MsoNormal>Use local DTS packages to Export the final records, same as production, to the remote SQL Server.</o>

In that scenario the remote SQL Server did not need to perform any tasks, all work is done locally.</o>
Having said all that...If however you will be creating flat files programmatically you may want to consider LINQ.
Salute,
Mark</o>

 

Hi all
I want to send data from a .csv file to my sql server 2000.
I have already done it on my offline server, but when I hosted it on on my discountasp.net based application, it doesn?t work.
I contacted their support team and they told me that the interop assembly which i am trying to reference is not installed on their server.
Can anyone gave me any example for it, which can run on discountasp.
</o>
Thanks
Baljit