SSIS 2005 - How to check a file to see if a files does not exist

Posted by GordyII on Stack Overflow See other posts from Stack Overflow or by GordyII
Published on 2010-03-30T21:08:41Z Indexed on 2010/04/01 23:13 UTC
Read the original article Hit count: 260

Filed under:

ssis

How do you check to see if a file does not exist in SQL Server Integration Services 2005?

Is there a native SSIS component which will just do this for you?

Related posts about ssis

SSIS packages incompatibilities between SSIS 2008 and SSIS 2008 R2

as seen on SQL Blog - Search for 'SQL Blog'
When you install SQL 2008 R2 workstation components you get a newer version of BIDS (BI Developer Studio, included in the workstation components) that replaces BIDS 2008 version (BIDS 2005 still live side-by-side). Everything would be good if you can use the newer version to edit any 2008 AND 2008R2… >>> More
Parsing flat files using SSIS : SSIS Nugget

as seen on SQL Blog - Search for 'SQL Blog'
Often when using SQL Server Integration Services (SSIS) you will find there is more than one way of accomplishing a task and that the most obvious method of doing so might not be the optimal one. In the video below I demonstrate this by way of an experiment using SSIS’s Flat File Source component;… >>> More
Introducing SSIS Reporting Pack for SQL Server code-named Denali

as seen on SQL Blog - Search for 'SQL Blog'
In recent blog posts I have introduced the new SSIS Catalog that is forthcoming in SQL Server Code-named Denali: What's new in SSIS in Denali Introduction to SSIS Projects in Denali Parameters in SSIS In Denali SSIS Server, Catalogs, Environments and Environment Variables in SSIS in Denali… >>> More
New SSIS tool on Codeplex – SSIS Log Analyzer

as seen on SQLIS - Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice… >>> More
New SSIS tool on Codeplex – SSIS Log Analyzer

as seen on SQLIS - Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice… >>> More

Developer IT

SSIS 2005 - How to check a file to see if a files does not exist - Developer IT

SSIS 2005 - How to check a file to see if a files does not exist

ssis

Related posts about ssis

SSIS packages incompatibilities between SSIS 2008 and SSIS 2008 R2

Parsing flat files using SSIS : SSIS Nugget

Introducing SSIS Reporting Pack for SQL Server code-named Denali

New SSIS tool on Codeplex – SSIS Log Analyzer

New SSIS tool on Codeplex – SSIS Log Analyzer

Categories cloud