Number of rows in flat file

  • How we can count number of rows in a flat file without loading it in the table?.I want to know it just from flat file.because i just want to make sure in my table i have same number of rows as of flat file after loading.

    thanks

  • With PowerShell you can get a count of rows in a flat file using

    (Get-Content "file.txt").Count



    Shamless self promotion - read my blog http://sirsql.net

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply