SQL Server Performance Forum – Threads Archive
problem in transfering excel file data to SQLHello <br /><br />we want to create a DTS package which will transfer all the contents of excel file to a table in SQL server.<br /><br />There are approx 200 excel files, whoes data has to be transfered to SQL. <br /><br />these files contains yearly data of the company. the filename is same as company name.<br /><br />every year 5 column are appended to the files.<br /><br />we have to create a package which will transfer the data from all these files to a table in sql server.<br /><br />We have created 2 packages, one parent and another is child. parent packages retrives the file name from table( we have stored all the file names in a table) and passes it to the child package. the child package then transfer the data from excel file to the table named ‘ExcelData’.<br /><br />The main problem is : while transfering the data by default the packages takes the first row entries as column names, and in all the excel files the first row is company name as heading. <br /><br />so when the data comes to the SQL server, we can not make out which data is for which column. <br /><br />Can any one help me in this matter. if u have any other suggestions pls do let me know.<br /><br />Thanks in advance<br /><br />Pallavi<br /><br />[<img src=’/community/emoticons/emotion-6.gif’ alt=’‘ />]<br />
I’ve moved to right forum.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
As an alternative, try this
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=8440 Madhivanan Failing to plan is Planning to fail