RE: Importing a DTS from Sql 2000 to Sql 2005

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi DC,

Thanks for the reply.

Well, my problem solved; but I think its just one of the cause of this kind
of error. I found that the TempDB and the user DB that I was working on were
not set to Autogrow and also there was a bit of disk space issue too. I set
them to autogrow and cleared some space on the data and log drives of these
DB's and I could get the package working.

In another environment, they fixed it by adding the service account running
the package into the SQL Logins explicitly (meaning, though this account was
a local admin; inspite of that) of that server to which this 2000 DTS package
was connecting.

You may want to try these..

Thanks,
Manoj Deshpande.

GC wrote:
Hi Manoj,

Sorry for the delay for answering to your message but I stop for a while
working on this issue. I decide to learn more about security and context to
understand what is exactly happening.

Thanks for the hint.
I tried both of your suggestion and still does not work.

I am searching a way to log everything of what is executed by the job to see
exactly where it fails and for what reason.

So I'm still working on my problem.
I am not an expert so thats is why it is long to find the problem :)

What about you did you find something on your side?

Thanks in advance and have a nice day!

HI GC,

[quoted text clipped - 22 lines]

Thanks in advance

--
Message posted via http://www.sqlmonster.com

.

Relevant Pages

  • Re: Immediate:TOLAS Programmer in McHenry, IL - DIRECT CLIENT Requirement
    ... , MCBA, and Cyborg I would have to say insistence on package ... BASIC programmer to come up to speed in such an environment. ... I had somewhat better luck with an MCBA descendent which can be blamed ... I could get some disk space back was to change from static to dynamic ...
    (comp.os.vms)
  • Re: smalltalk libraries
    ... neither disk space, memory, or bandwidth are limited in ... gb of memory and 250 gb of disk on the 2 year old macbook pro I'm ... Compared to Smalltalk this is very efficient since it helps keep by ... from some package then I include the package in my image and use the ...
    (comp.lang.smalltalk)
  • Looking for hosting.
    ... I'm looking for an ASP host which has a package which fits all following ... 3000-5000MBdisk space ...
    (microsoft.public.inetserver.asp.general)
  • Re: Linux
    ... Using rpm to remove packages is very safe. ... It won't remove a package that another package needs, ... Once you find out the biggest directory, cd to that directory and repeat. ... find big files and big directories that consume disk space. ...
    (rec.crafts.metalworking)