How To Write An Sql Statement Output To A Csv File?

We have a script task that processes a flatflat, inserts data into the database, then records any duplicates (via a stored proccedure) into a SQL table, which then passes it to a w

Solution 1:

You could try this..put a script before the task is executed to check the file size, and the add a "Precedence Constraint"...when TRUE, then proceed. with

Dim FileInfo As System.IO.FileInfo

you can obtain the file length like...FileInfo.Length.