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.

All Forums  SQL Server 2012 Forums  SSIS and Import/Export (2012)  transferring data from single column in excel

Author  Topic  Naureen Starting Member 1 Post Posted - 2015-02-25 : 15:26:31 Hi, I need to transfer data from a excel report to sql. I am using sql 2008. my excel data is beginning from row 5, row 1-4 has information related to report criteria. My problem is that i want the information in row 3 column 1 and column 2 to be part of data transfer. i-e Start date and end date should be part of every row being transferred to sql. Can someone please advice how can i attain this task. Please note this is my very first project with SSIS .