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 .

   

- Advertisement -