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.

5 (2)

2005-04-12

12,244 reads

Blogs

Generating Unicode Characters in Power Query

By

You may have used the UNICHAR() function in DAX to return Unicode characters in...

Daily Coping 29 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 28 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Getting count from Scheduled job procedures

By Brad Allison

I have a new requirement to create a Power BI Dashboard that shows current...

Create Multiple XML Files using SSIS

By Jobs90312

Hi community, I have a table in my database which consists of 100,000 rows....

Performance problem

By Jonas Jisendal

Hi I have one server running SQL server 2017 and one running SQL server...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers