I am writing a generic data import routine in Cold Fusion. I'm fine with the file upload and transferring data from an import table into the final table in my SQL 2000 database.
What I need is a routine that will take a flat file (.txt tab delimited or .csv comma separated), that will take a table name and that will import the contents of the file into the table name probably using DTS (Data Transformation Services). It should take the contents of the first column and put them into a field called Col1, the contents of the second column into a column called Col2, etc. There will be n-columns where n could vary from file to file.
I'll handle creating the temporary table you put the data into (although it's a real table, not a "temp" table) and naming and sizing the columns. I need you to write the ASP or whetever to call the DTS.
Am open to interface, but I'd like to call your script using HTTP and passing the table name in the URL e.g. [login to view URL], your script should be ASP.NET that'll run on IIS5 - Win2k with .NET framework AND IIS6/Win2003. I'd also like you to return some data when the import has suceeded or with a basic error code if it failed.
I'm looking for a thin wrapper around DTS because I have some data which includes chr(10) and chr(13)'s within double quoted text areas and I know DTS can handle that whereas my old "parse for line breaks and parse for tabs" doesn't work any more!
This is perfect for someone comfortable in .NET and DTS.
Let me know if any questions!
Thanks,
Peter
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Win2k Server + IIS 5.0 + .Net framework
AND
Win2003 Server + IIS 6.0
Must work on both