Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > DTS Package using Excel Spreadsheets

Thread Tools

DTS Package using Excel Spreadsheets

Posts: n/a
I will start off by giving you a background of the process I am taking.
The nature of my DTS package is that I recieve an Excel Spreadsheet, run
it through the DTS Package applying validation to the records, create an
excel file that contians the records that do not pass the validation,
send this Excel file back to the person who sent me the original
spreadsheet. They will send the Excel Spreadsheet back once they correct
the records. Then the process starts over and keeps going until there
are no records left.

The problem I have ran into is that I have to create an excel file using
an ActiveX script, the DTSPump will not, as far as I am aware of, create
an Excel file automatically. So, I have created a ActiveX script that
will create an Excel object using Set
objExcel=CreateObject("OWC10.spreadsheet") . I do not add any data to
the spreadsheet at this point, just the column headings. A few steps
later in my DTS package I attempt to use a data pump and process
information from a table into the Excel worksheet that was just created.
However, when I choose the file and click on the OK button it throws an
erro "The External table is not in the expected format".

The problem lies in that I HAVE to use Excel files to complete this
DTS package, but the excel files that I create are not compatible with
the Excel 97-2000 connections in DTS. The object that I have created
using the ActiveX script shows as an Excel Spreadsheet in My Computer
and will open with Microsoft Excel. I have also tried to use the other
DTS Connect formats for Excel such as 5.0 and 6.0, these did not work

Does anyone know how I can work around this problem? If I need to clear
things up or provide more information just let me know.


* * * Sent via DevBuilder * * *
Developer Resources for High End Developers.
Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Last Day! DTS Criterion DAZED & CONFUSED dvd, Ltbx THE SHADOW DTS LD, Criterion BOOGIE NIGHTS ld J Rusnak DVD Video 0 01-02-2007 11:30 PM
FA: DTS THE SHADOW ltbx LD, DTS DAZED & CONFUSED Crit. DVD, Criterion BOOGIE NIGHTS LD J Rusnak DVD Video 0 12-28-2006 05:30 PM
FA: DTS ANACONDA Superbit, Factory-Sealed DEEP RISING dvds, DTS CARLITO'S WAY ld J Rusnak DVD Video 0 04-11-2006 02:30 AM
The Jackal (1998) DTS vs non-DTS Aphelion DVD Video 2 04-07-2005 01:44 AM
Re: Matrix DTS and Matrix 2 DTS? PeterTHX DVD Video 0 08-03-2003 05:46 AM