I create a comma delimited flat file based on a view . Then if this process completes successfully, I read the file created into a table to do some processing. I do all this in a dts package
DB->Data Transformation Task -> Destination FlatFile -> On Completion -> Source Flatfile -> Data Transformation Task -> DB

This DTS runs inside a job

But the problem is, when the view returns nothing, a 0kb or empty flat file is created. And hence the reading back into the table fails. How can this problem be solved

I would really appreciate immediate repsonse

Thanks
Sunanda

You could use workflow.

Either

Check the file size and if it is 0 bytes then do not do your datapump
OR
Check the rowcount of a select from your view and if that is 0 then do not
do the datapump.

Workflow
(http://www.sqldts.com/default.aspx?103)
--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sunanda" <anonymous (AT) discussions (DOT) microsoft.com> wrote

some processing. I do all this in a dts package.
this problem be solved.