How do you specify an Unspecified Error??

Question

How do you specify an Unspecified Error??

fhtapia

SSC Eights!

Points: 994
More actions
December 30, 2002 at 3:50 pm

#158803
I have a table out of Access that I want to import to SQL Server but I keep getting an unspecified error, I did nothing to the script which looks just like this...I double checked the datatype for all columns, how do I fix this? how can I get the script to echo back a response such as this "EngDispo" or whatever the column name is could not be imported?
Thank you for your help
and excerpt of the script follows
```
DTSDestination("EngDispo") = DTSSource("EngDispo")

Main = DTSTransformStat_OK

End Function
```
-Francisco

-Francisco

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

Unfortubnately this snippet isn't much to go on. Try rebuilding the transaformation from scratch or build a new copy of the page and see if the problem persists.

David Burrows SSC Guru Points: 65143 More actions · Answer 2

I use SQL7 and found this sometimes as I import data from 3rd party DB via ODBC and normally I find it's due to data conversion, e.g. date overflow etc. Also I have found that trying to convert Access databases to SQL difficult as well and found that the mapping of field types does not always go according to plan.

Normally I find a description of the error is somewhere in the output of DTS. I do DTSRUN from DOS to get full output or schedule the job with a log file, run it once and view the output.

Are you extracting from an Access database? If so, does your workstation and/or the server have the correct version of access. I seem to recall this error if you try to use Access2000 DB on a server with version prior to Access2000.

Hope this helps.

Far away is close at hand in the images of elsewhere.
Anon.

David Burrows SSC Guru Points: 65143 More actions · Answer 3

More info. One of my DTS today got 'Unspecified error' and was due to the file missing and then the file was in use (being created). Once the file had been created and available, job worked.

Far away is close at hand in the images of elsewhere.
Anon.

fhtapia SSC Eights! Points: 994 More actions · Answer 4

Thanks to all for the replies,

I didn't include more of the script as it was basically just



Function Main()

   DTSDestination("MyFields") = DTSSource("MyFields")

   Main = DTSTransformationStat_OK

End Function

I kept working on the problem and was able to determine that there was a corrupt record in the Access database, and while this sort of thing is inevitable with most Access Databases I was left to wonder why I couldn't code around the problem to say N records could not be imported..

Thanks again

-Francisco