August 5, 2005 at 4:50 am
Hello everyone,
I am trying to design a DTS that backups my database tables into a single Excel file, for this purpose I made a connection using OLEDB for SQL server and a destination Excel file, and several tasks from the source connection to destination Excel file that transforms the data tables into Excel File, it works fine for the first time, but as that Excel file is removed/Deleted from its hard coded location the DTS stops working n generates error on every task, on viewing the properties of the tasks the destination table shows the following error
Error Source : Microsoft Jet Database Engine
Error Description : The Microsoft Jet Database Engine could not find the object 'Authors_Table'. Make sure the object exists and that you spell its name and the path name correctly.
So is there anything i can do to remove this error so that everytime I access this DTS through my I can easily backup that database in a different Excel files? as I did the same using the FAT files which is working absolutely fine as from the source connectino there are equal number of connections as they are in my database.
MNS
August 8, 2005 at 8:00 am
This was removed by the editor as SPAM
August 8, 2005 at 8:54 am
MNS, You could create an Excel application object in a VB script task before you export the database and modify your connections and files before you begin the datapump.
Is this what you are looking for?
August 8, 2005 at 10:50 am
I've experimented with a couple of ways to deal with this. One way that is kind of messy, but works is
1) Create a blank file for to use as a target for dts.
2) Save this file with a different (hard-coded) name.
3) Use vbscript to rename the second file to it's permanent location.
This way the original file never gets overwritten or moved.
August 8, 2005 at 11:42 am
as a workaround, you may try to create a ascii TAB delimitered file with .xls extension.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply