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 |
|
SMerrill
Posting Yak Master
206 Posts |
 Posted - 2004-12-11 : 01:17:23
|
| - I receive 85,000 e-mails per year.- Each e-mail contains one attached XLS file.- Each XLS contains one row that I must import to SQL 2000.- The customer I'm writing this for loves using DTS if possible.- I am very well acquainted with the OutlookXP object model in VB.NET.- I must traverse the Outlook XP object model and get it to save the attachments. That is easy for me in VB.NET, but I'm suspecting that it is near impossible in DTS.Question: Has anyone implemented a successful OOP programming effort in DTS?I'm a VB programmer. I can't develop in VBScript well without Intellisense. So I must write things in VB and translate them to VBScript? Or I must write an Extended Stored Procedure DLL in VB?What's the best implementation choice here?~ Shaun MerrillSeattle, WA |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-11 : 04:48:35
|
| Rather than an extended xp why not make it an app.I would probably go with the app rather than dts but it really depends on the environment.>> So I must write things in VB and translate them to VBScript?That's what I always do when I'm dealing with objects.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-11 : 08:50:18
|
quote:
I'm a VB programmer. I can't develop in VBScript well without Intellisense.
I'd find this sad, but I'm laughing and shaking my head in amazement too much. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-11 : 09:18:35
|
quote:
- Each e-mail contains one attached XLS file.- Each XLS contains one row that I must import to SQL 2000.- The customer I'm writing this for loves using DTS if possible.
It would be better to have your code process each Excel file, take only the one row needed from it, and copy it into a separate file. You'll end up with one file containing only the data to be imported. Once that's done you can bcp, BULK INSERT, or use DTS to import that one file into SQL Server. This will be much faster and have less impact on SQL Server. |
|
|
|
|
|
|
Can DTS do OOP?