David Jackson

  • Interests: Geek stuff

SQLServerCentral Article

Importing The Latest File In A Folder Via DTS

Using the Dynamic Properties Task in SQL Server 2000 DTS is a great way to build a flexible package that can handle a variety of situations. Things are much improved in SQL Server 2005 Integration Services, but many of you will need to solve a common problem until you can upgrade. New author David Jackson brings us a technique for finding and processing the latest file in a folder.

(2)

You rated this post out of 5. Change rating

2005-04-12

12,299 reads

Blogs

Catching Up On SQLOrlando

By

Somehow two years have elapsed since my last update; hopefully it won’t be that...

Advice I Like: Pyramid Schemes

By

If someone is trying to convince you it’s not a pyramid scheme, it’s a...

Using Prompt AI for a Travel Data Analysis

By

I was looking back at my year and decided to see if SQL Prompt...

Read the latest Blogs

Forums

Switch partition: NULL boundary id

By vpolasa

I have table: t1 in schema1 with 19 billion records. I have another table...

Minimally Viable Security

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Minimally Viable Security

Encoding NULL

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Encoding NULL

Visit the forum

Question of the Day

Encoding NULL

What is returned from this code in SQL Server 2025?

SELECT BASE64_ENCODE(NULL)

See possible answers