Hello All,
I have issues regarding DTS in SQL 2000 in comparison to the Integration Services in SQL 2005.
In SQL 2000 the way I used to import data from a Microsof Excel file
was through DTS where I could mention row number from the Excel file to
start extraction into the SQL DB. (Transform Data Task Properties > Options > Data Movement: First Row)
Whereas, in SQL 2005 I cannot specify anywhere from which row number
the extraction should start. I am new to SQL server 2005, any help
regarding above issue will be much appreciated.
Thanks
Umer
see SSIS forum
Flat File Connection Manager Editor (General Page)
http://msdn2.microsoft.com/en-us/library/ms187017.aspx
Header rows to skip
Specify the number of header rows or initial data rows to skip, if any
No comments:
Post a Comment