I have been given the task of creating a DTS package (SQLServer 2000) which has as a source an Excel workbook with several worksheets, and SQLServer tables as a destination. The Excel worksheet is not straightforward in that a certain column or columns contain different types of data, depending upon the row. The worksheet has been created to look like a form that a user can fill out, which is why different rows contain different types of data in a particular column. There are checkboxes in some cells, text in others, and dates in others. A straightforward column mapping obviously will not work, and cells need to be referenced differently. Would you please help me out with this and let me know if this is possible and the best way to go about this? I am new to DTS and am trying to read and research as much as possible to figure out the best way to handle this project.
Thank you for your help.