How to detect an empty flat file

FAQ

Profile

How to detect an empty flat file

Database Forums (Home) -> DTS

Next: Is there a way to make the "Show Table...&qu..

Author

Message

Mike

External

Since: Mar 15, 2006
Posts: 64

(Msg. 1) Posted: Thu Nov 13, 2008 12:23 pm
Post subject: How to detect an empty flat file
Archived from groups: microsoft>public>sqlserver>dts (more info?)

A DTS package that inputs a flat file. The file's name is set using dynamic
properties task. I need a task to detect if the file is empty and then
control execution of subsequent task(s). An example would be much
appreciated.
--
msf

>> Stay informed about: How to detect an empty flat file

Display posts from previous:

Related Topics:

Flat File import - Hello, I need to import data from a flat file into a sql server 2000 database. The Fate file has no delimiters. I have the specs for this file so I do knowthe layout of this file. Can somebody point me in the rigvht direction to accomplish this. ..

Flat File - Different row types - still confused - I'm trying to process header/detail lines in a flat file, something I've seen a few examples of, but still have some questions. I've seen Allan Mitchell's comments and an example on sqlis.com (thanks for the fine examples!), and tried an example from...

SSIS - Flat File Location - I have a SSIS package that imports data from a flat file into a table. The file is in a network share. The package itself is in my local machine. The sql server itself is running on my local machine. This will be changed later to a server. The packag...

Flat file src error-"The value could not be converted beca.. - Hello, I have a flat file source with ragged right format. It has three columns. My package fails when the last column has null values. It says "The value could not be converted because of a potential loss of data". I tried lot chang...

Flat file text delimiter - I am using SQL2005 management studio to export the data from a table to a flat file. If I include a text delimiter it adds it to every column, i have checked the columns with the edit transforms button and some of them are ints. Is there a setting..

	Database Forums (Home) -> DTS	All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum