June 9, 2003 at 8:04 am
Hi
I am writing a web app where the user must upload and excell file onto a server. I am looking to search the server for new or updated excel files. I the server finds a file, it must be converted to a database file.
How can I do this through ASP.NET using C#, and how do I set this up through SQL Server 2000?
Any help will be appreciated.
Thanx
Ruan
June 12, 2003 at 8:00 am
This was removed by the editor as SPAM
June 12, 2003 at 11:44 am
I am not an ASP programmer, so I will try to help on the DB side. You need to create DTS package (easiest way is wihtin EM) which contains a SQL server connection, an excel connection and a transformation step. Once you create it you can either save it locally on the DB server or save it a structured file (*.dts) in the form an operating system file. In the first case , the DTS DLL files shipped with SQL server 2000 will expose the DTS to your application. In the second case , you execute the DTS from the cmdline with the appropriate arguments ( see Online Doc for on executing DTS). For error handling , I find it easier to define an error file within the DTS package then trying to capture errors in the applcation. Hope this helps.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply