Re: crashing DTS on table import
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/02/04
- Next message: David Gray: "Linked Server (Oracle 9i)"
- Previous message: IT Dep: "Re: crashing DTS on table import"
- In reply to: IT Dep: "Re: crashing DTS on table import"
- Next in thread: IT Dep: "Re: crashing DTS on table import"
- Reply: IT Dep: "Re: crashing DTS on table import"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 02 Nov 2004 06:14:47 -0700
Since this is an ODBC data source, you can try to turn on
ODBC tracing on the box where the package runs. Make sure to
turn the trace off after you have crashed with tracing
turned on. You can then go through the tracing log file and
look for ODBC errors.
-Sue
On Tue, 2 Nov 2004 09:34:59 -0000, "IT Dep"
<it@isslimREMOVE_TO_REPLYited.co.uk> wrote:
>MDAC 2.8 doesn't seem to have made any difference. Any ideas?
>
>Thanks
>
>Dan
>
>"IT Dep" <it@isslimREMOVE_TO_REPLYited.co.uk> wrote in message
>news:e6wXQ2LwEHA.1296@TK2MSFTNGP10.phx.gbl...
>> Change of plan, going to install Microsoft Data Access Components (MDAC)
>> 2.8, didn't see the newer version at first. I already have SP3 of SQL, it
>> does advise that SP3a is only for versions below SP3, and as such I
>> shouldn't install it? Looked in the event log to see if there is any log
>of
>> an error, but there is nothing whatsoever. Thanks.
>>
>> Dan
>> "IT Dep" <it@isslimREMOVE_TO_REPLYited.co.uk> wrote in message
>> news:OgXbKTBwEHA.3976@TK2MSFTNGP09.phx.gbl...
>> > Hi
>> >
>> > I am having some trouble importing certain tables from an odbc database
>> > (Sage Line 50). Most of the tables import without any trouble
>whatsoever,
>> > however there are 2 tables (SOP_items and POP_items) that always crash
>dts
>> > when it tries to import them. The DTS screen simply dissappears from
>the
>> > screen with no error. I realise that it is beyond the scope of this
>> > newsgroup to ask about the specific odbc database. However I was
>> wondering
>> > is there a log somewhere which might help me to shed light on what in
>the
>> > tables is making it crash. To note I can import and link to the tables
>in
>> > access with no trouble whatsoever. Thanks for your time.
>> >
>> > Dan
>> >
>> >
>>
>>
>
- Next message: David Gray: "Linked Server (Oracle 9i)"
- Previous message: IT Dep: "Re: crashing DTS on table import"
- In reply to: IT Dep: "Re: crashing DTS on table import"
- Next in thread: IT Dep: "Re: crashing DTS on table import"
- Reply: IT Dep: "Re: crashing DTS on table import"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
