By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

how to create a DTS package in SQL Server 2000

P: 88
hi all...I have to create a DTS package in SQL Server 2000....it should be able to import all the data from the Excel files(there are many excels)....Please tell me how to do this and the best way to do this....Will appreaciate any help...
Nov 9 '08 #1
Share this Question
Share on Google+
4 Replies


P: 31
Pls let us know,
Your many excel files are stored at one location or different location?

Another thing, using DTS Package, you can import data from particular single excel file.. Stored at particular location on PC Where you are making / designing this DTS Package.

Cant you use some programming along with? If your many excel files are stored in particular folder, then you can make small utility, which takes folder's address/location and imports all the file to particular table.
Nov 10 '08 #2

P: 88
thks for reply...all my excel files are stored in a folder at a particular location....I have VS.net 2005 installed...I can use C# or VB.net....plz let me know the steps to create a DTS package....will be thankful for ur help...

Pls let us know,
Your many excel files are stored at one location or different location?

Another thing, using DTS Package, you can import data from particular single excel file.. Stored at particular location on PC Where you are making / designing this DTS Package.

Cant you use some programming along with? If your many excel files are stored in particular folder, then you can make small utility, which takes folder's address/location and imports all the file to particular table.
Nov 10 '08 #3

P: 31
Ok.

You can create window based application using .net.
Nov 13 '08 #4

ck9663
Expert 2.5K+
P: 2,878
Start by reading this

Happy coding!


-- CK
Nov 13 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.