Viewing 15 posts - 46 through 60 (of 72 total)
Have you considered linking the access tables after you first run your DTS package. That way anything entered into access automatically goes into SQL in real-time.
September 26, 2002 at 3:38 pm
Another twist on that could be to rename each SP as suggested in #1. Then create another SP of the same name that runs the logging code that Andy mentioned,...
August 24, 2002 at 6:27 pm
Is there a reason why you can't just Create 2 DTS packages? One for each destination table.
August 23, 2002 at 10:45 am
I really like the snitz board too. We have recently been looking for a message board system, but unfortunately one of the requirements was that it needed to be threaded(this...
August 15, 2002 at 3:15 pm
I seem to recall having problems with this wizard the last time I tried to use it. Whilst it did copy the database correctly it failed to keep auto incrementing...
July 28, 2002 at 2:13 pm
Try checking that you have correct NTFS permissions on the folder where the Access database is stored.
May 22, 2002 at 3:20 pm
Thanks Antares. That looks like it might do the trick.
May 16, 2002 at 5:51 pm
Andy,
I think we are going to have to agree to disagree on that one. I still believe that only the latest version...
May 13, 2002 at 6:57 pm
OK, my point of view is this:
You should only ever query the database for truely dynamic data, otherwise you are wasting roundtrips and degrade performance. By 'truely dynamic' I mean...
May 13, 2002 at 5:14 pm
Glad to see someone trying to address this. I don't agree with changing the name of the stored procs for the same reasons others have stated above, I think the...
May 12, 2002 at 1:42 pm
Is there any reason why you must use linked servers?
It looks to me like they are just complicating matters.
Why not specify the Oracle database as the DTS source, and...
May 7, 2002 at 4:00 pm
The most useful feature I have found to date is the enhanced DTS in 2000 over 7.
See this link for a comparison of all the other features.
http://www.microsoft.com/sql/evaluation/features/choosing.asp
May 7, 2002 at 3:33 pm
Try backig up your destination table(as a precaution), then remove any unique indexes including primary key. Run your DTS, does it still fail? If the answer is no, then it...
May 1, 2002 at 4:50 pm
I don't think there is much to choose from between the 2 if you just want an easy way to enter a bit of data, maybe access has the edge,...
April 22, 2002 at 2:08 pm
Viewing 15 posts - 46 through 60 (of 72 total)