Dear All, I am having a excel sheet to load into sql table using SSIS. I dont want first 5 line for excel to load it should start from 6th row please suggest how can i achieved the same. Please suggest is SSIS support pdf file. ? Regards, Vipin jhaThankx & regards, Vipin jha MCP

1) To select a range of data from an excel sheet you can use SQL command on an excel connection and specify the range of interest. Check this and this for reference. Or you can alternatively assign a row number to each data row coming from the excel and then use a conditional split to remove all rows which have a row number <= 5 i.e. the top 5 rows. Or you can Open a rowset on your excel connection to skip some rows. Check this which has a similar discussion. 2) SSIS can support pdf's but pdf import are prone to errors as they are basically images of documents. So parsing a pdf can be error ridden. Change your data from a pdf to some other form and keep it simple in SSIS. But even if you want to parse pdfs consider using a script component to parse the file. Check this which is a handy code for converting pdf files to text.http://btsbee.wordpress.com/

Hi, You can take Excel source and use the SQL command to build the logic for ignore any no of rows. SSIS does not support PDF files.*Regards*<\br> *Samay Shrivastava* *Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.*

You can set the OpenRowset property of Excel Source to achieve the same. You can follow the steps referred here: SSIS: Read and Export Excel data from nth Row

check this link http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/20944506-5276-41e7-8b65-7f36d6e4bdaa/Sincerely Nik -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).