Integration Services (SSIS)

Technical Article

File Watcher Task

  • Article

The File Watcher Task does what it says really, it watches a folder waiting for files. When an available file is found the task completes, returning the name of the file for later use.

The task will detect changes to existing files as well as new files, both actions will cause the file to be found when available. A file is available when the task can open it exclusively. This is important for files that take a long time to be written, such as large files, or those that are just written slowly or delivered via a slow network link.

2005-09-28

3,505 reads

SQLServerCentral Article

SSIS - Code Reuse and Complex Control Flows

  • Article

SQL Server 2005 Integration Services is an incredibly powerful, but complex environment for creating ETL packages. Kristian Wedberg brings us a new article on reusing some of your code and some complex looping structures that you might want to use in your applications.

(5)

You rated this post out of 5. Change rating

2005-09-06

16,186 reads

Blogs

5 Starter Projects for Your AI and Data Engineering Portfolio

By

Reading tutorials is fine. Shipping something is better. If you are trying to break...

The Book of Redgate: Taking Breaks

By

We work hard at Redgate, though with a good work-life balance. One interesting observation...

Database AI Agents: The Read-Only Rule

By

Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...

Read the latest Blogs

Forums

Displaying Money

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Displaying Money

The Slow Growing Problems

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Slow Growing Problems

Calculating the Harmonic Mean in Power BI

By Dinesh Asanka

Comments posted to this topic are about the item Calculating the Harmonic Mean in...

Visit the forum

Question of the Day

Displaying Money

I want to get the currency sign displayed with my amount stored in a money type. Does this work?

DECLARE @Amount MONEY;
SET @Amount = '?1500';

SELECT CAST( @Amount  AS VARCHAR(30)) AS Euros

See possible answers