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.
| Author |
Topic |
|
srinivas.alwala
Starting Member
30 Posts |
 Posted - 2008-02-26 : 09:23:06
|
| Hi,Curently I am using a DTS package which is used to import data from Excel sheet into sql dollar table.Now, the no. of Excel sheets is more than one and everytime the DTS package and VB Code has to be updated and sql dollar tables has to be increased to the no. of Excel sheets available.The DTS package being executed by VB Code(.EXE).How can I modify the DTS package and VB Code so that the import can be done dynamically irrespective of no. of Excel Sheets.If anybody have a solution for this ,Kindly let me know.Regards,Srinivas Alwala |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2008-02-27 : 10:20:56
|
| Is this SSIS or DTS?Mark |
 |
|
|
srinivas.alwala
Starting Member
30 Posts |
Posted - 2008-02-29 : 01:00:43
|
| It is DTS.Regards,Srinivas Alwala |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2008-02-29 : 05:22:35
|
| You might get a better response posting in the Import/Export (DTS) and Replication (2000) forum.Mark |
|
|
|
|
|
|
Import Data from Excel Sheet Dynamically.