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-07-23 : 07:33:20
|
| Hi,Curently I am using a DTS package which is used to import data from Excel sheet into sql dollar table (sql server 2000).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 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-07-23 : 10:09:34
|
| Hi,that seems to be not a question for SSIS because it is DTS and SQL Server 2000.But anyway...Google told me:http://www.sqldts.com/246.aspxHope that helps.GreetingsWebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
 |
|
|
|
|
|
Import Data from Excel Sheet Dynamically.