Check content exists or not in the text file.

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  integration services   » Check content exists or not in the text file.

Check content exists or not in the text file.

Topic RSS Feed

Posts under the topic: Check content exists or not in the text file.

Posted: 4/25/2012

njc78
njc78
Padawan 172  points  Padawan
  • Joined on: 2/16/2010
  • Posts: 51

Hi, Before I upload to the ftp server, I want to make sure content/any data exists in the text file or not, if data is not in the file I don't want to upload file.

I know there are few ways like rowcount, script task etc.

what is the easiest/best why to check.

Thank you so much.

 

 

Posted: 4/25/2012

njc78
njc78
Padawan 172  points  Padawan
  • Joined on: 2/16/2010
  • Posts: 51
Answered  Answered

I found the solution.

http://www.sqlservercentral.com/blogs/tim_mitchell/2009/9/30/eliminating-empty-output-files-in-ssis/
Page 1 of 1 (2 items)