var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Ignoring a Column in During DTS
I'm importing from an Excel spreadsheet into an SQL Table using DTS.
1. I don't want anything imported into Column 1 of the table as this has been designed to automatically increment (creating a primary key). I haven't worked out how to do this.
2. How can I get the DTS package to ignore the top 2 rows of the Excel spreadsheet (header information)?
An answer to one will be great but both will be tremendous!!
Are you using the DTS wizard, or the package designer?
If at first you don't succeed, call it version 1.0