Query Optimizer

Technical Article

RE: Yukon Delayed Again and Named

  • Reply

Given the importance of data in the corporate environment I think Microsoft have made a good call.If YUKON is as big a jump forward as VS.NET then it will have been worth the wait.Hopefully it will be stable and secure with no "buffer overrun" security glitches.

You rated this post out of 5. Change rating

2004-03-12

Technical Article

RE: DTS-DOS-FTP Connection Question

  • Reply

What about using the DTS FTP task with on success/failure, especially since you're already using DTS? Alternatively, if you want to check if the file is there, you could use something like this in an ActiveX task:Set objFSO  = CreateObject("Scripting.FileSystemObject") If objFSO.FileExists("c:\Downloads\filename") Then ... 

You rated this post out of 5. Change rating

2004-02-24

Technical Article

crc error in transaction log

  • Topic

Hi, The scheduled back up of my transaction log is failing because the log file is failing a crc check. (OS Error 23)I tried to backup the transaction log manually but ran into the same error. It's not throwing an error writting to the log and I guess this has been going on for awhile because teh […]

2004-02-13

3 reads

Technical Article

RE: problem with DTS package

  • Reply

If you are fighting with Excel, this doesn't have error trapping for when the table DOES NOT exist but (if you're not too concerned about that scenario happening), this works pretty well without activex... Using normal DTS Execute SQL Tasks (connected with On Success workflow): Task 1 a) Set existing connection to your XLS connection […]

2003-08-22

Technical Article

RE: MS. Access to SQL Server 2000

  • Reply

Hi malb, quote: I have been doing this sort of thing professionally for the past 3 years and its a big job, there's no quick way to do it properly. If you opt for the quick and dirty solution of linking tables by odbc then renaming the dbo_XXX back to the original table names so […]

2003-08-20

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers