Count lines of a csv file

[Diogo]

Hello.

I have one file (*.csv) and i would like to count the lines of the file and insert that in one table on the database of the sql server.

Is that possible???

Thanks any way.

DR

 

[MaffewW]

Do you need to count the lines before it is imported into the database, or will after do?

 

[hubud]

depending on the size of your file it might be just as easy doing an import then select count(*) from yourtable. I haven't heard of dts being used to count from a csv before inserting

simmo

 

[Corran007]

you can count the rows using file scripting object

set objfso = server.createobject("Scripting.fileScriptingObject&quot
set objtstream = objfso.opentextfile("Filelocation",1)

do whiloe not objtstream.atendofstream
intlinenum = objtstream.line
loop

intlinenum will be your total number of rows.

hope this helps.

 

[Diogo]

I would like to know if the import was sucessuful, so i'd like to count the lines in the file and compare them after the import.

I have one table to insert the count of records, before and after the import and then i compare.

Thanks any way, and sorry my english...

DR

 

[VogonPoet]

The import should either succeed or fail. This is, either all or none of the data will be imported. If you are running the package from Enterprise Manager, you will receive immediate feedback. If you are running the package from some other source, you can have the status output to a text file and look at the results there.

Michael