Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dylanmendes
Starting Member
7 Posts |
 Posted - 2005-06-01 : 01:28:19
|
| Here is a detailed description of my problem:My ASP.NET application has a screen where the user must import an Excel/MS Access file into the SQL Server database. The following parameters should be dynamic and the user should be able to change these at runtime:1) the source file path 2) the mapping of the column names on the source files to a "friendly name". e.g. the Excel column may be called vol_0234 but the user wants this to be called "volume" in the database.NOTE: the number of columns also is not fixed. I expect that the import will be done multiple times with differing number of source file columns.Is a DTS package appropriate for this? If yes, how do I go about implementing this via a stored procedure?Please help!!!Dylan |
|
|
|
|
|
Column mapping info passed dynamically