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...

[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.

[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.

[BHTanna]

Ok.

You can create window based application using .net.

[ck9663]

Start by reading this

Happy coding!


-- CK