467,915 Members | 1,225 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

how to create a DTS package in SQL Server 2000

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
  • viewed: 3599
Share:
4 Replies
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
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
Ok.

You can create window based application using .net.
Nov 13 '08 #4
ck9663
Expert 2GB
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.

Similar topics

1 post views Thread by Prashanth Uppunda | last post: by
1 post views Thread by Jagannathan Santhanam | last post: by
2 posts views Thread by Marios Koumides | last post: by
2 posts views Thread by Anantha | last post: by
reply views Thread by ShrimpBoy | last post: by
9 posts views Thread by itmags | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.