how to create a DTS package in SQL Server 2000

ravitunk

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

BHTanna

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

ravitunk

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

BHTanna

Ok.

You can create window based application using .net.

Nov 13 '08 #4

ck9663

Start by reading this

Happy coding!


-- CK

Nov 13 '08 #5