andash
Posts: 18
|
Posted: 01/09/2008, 3:53 PM |
|
Does anyone have any ideas how to handle this series of tasks.
1: Upload a customers csv data file (easy enough by itself)
2: Map the fields in the header of the CSV file to Appropriate fields in SQL table
3: Finally import the data to the Appropriate table in SQL
4 Return appropriate success or error code.
We are using ASP VB.net, MSSQL-2005, IIS etc..
Is there a 3rd party module that I can buy and incorporate? Would it be best to just upload the file and use a stored procedure to handle the rest and return an appropriate error or success code?
Thanks in Advance..
Andrew
_________________
Andrew Asher
www.it3.co.nz |
|
|
senolkural
Posts: 1
|
Posted: 01/21/2008, 6:27 AM |
|
I am working on a Human Resources project. I am doing now. I think I can answer in two days.
|
|
|
Mukul
Posts: 53
|
Posted: 01/22/2008, 9:37 PM |
|
We have done it in one project. it was importing access and excel files in mssql.
(Note the column name used to be same for repeated files)
Steps used:
1. DTS were created for importing data in tables created by DTS.
2. Stored Procedure was called to execute the DTS. This allowed the new data to be filled in the temp tables and button to call the DTS indirectly from CCS.
Declare @cmd varchar(1000)
select @cmd = 'dtexec /F "C:\DTS\Proj1\Import_dp.dtsx"'
exec master..xp_cmdshell @cmd
3. Another stored procedure to compare the existing data and according to business decisions update or insert data in regular tables.
4. Buttons were made in CCS to call the procedures.
--
Mukul
|
|
|
|
|
|
|
|