jimitladha
Technical User
Hi,
I am a Newbie to SQL DTS and need some help is finding a solution to import Dynamically Generated (in an external system) Multi-Sheet Excel Files or CSV file.
The CSV file works fine for small imports but there are times when the export breaks the 8060 bytes per row limitation (so I feel as there is a error message not enough storage is available to complete this operation), I added space to the DB and also the DB is on Automatically Grow file is selected....
The Excel file is dynamically generated and consists of different column headers per export, and also it is a multi sheet export for the data which is horizontally partitioned.....
Other way to do this i think would be to get the data into predetermined temp tables and then parse them but the issue in that is how do i get the column names from the Excel if i am importing them to predetermined tables, also i will need as many temp tables as the number os sheets....
Please let me know if someone has a solution to import this data using DTS and not having to parse the file out side the DB as it will be a very long tedious process....
Thanx,
Jimit
I am a Newbie to SQL DTS and need some help is finding a solution to import Dynamically Generated (in an external system) Multi-Sheet Excel Files or CSV file.
The CSV file works fine for small imports but there are times when the export breaks the 8060 bytes per row limitation (so I feel as there is a error message not enough storage is available to complete this operation), I added space to the DB and also the DB is on Automatically Grow file is selected....
The Excel file is dynamically generated and consists of different column headers per export, and also it is a multi sheet export for the data which is horizontally partitioned.....
Other way to do this i think would be to get the data into predetermined temp tables and then parse them but the issue in that is how do i get the column names from the Excel if i am importing them to predetermined tables, also i will need as many temp tables as the number os sheets....
Please let me know if someone has a solution to import this data using DTS and not having to parse the file out side the DB as it will be a very long tedious process....
Thanx,
Jimit