Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 importing a csv file

Author  Topic 

rookie_sql
Constraint Violating Yak Guru

443 Posts

Posted - 2008-12-17 : 10:41:40
Hi i've a csv file and i need the last row of data from it. When i load it into my table i get the last row as as date format as ddmmyyy, 12,340.09


The line i need is the last line 2ddmmyyy, 12,340.09"


sample of the file is
a, 3334,1101,33
s, 3334,1101,33
h, 3334,1101,33
f, 3334,1101,33
v, 3334,1101,33
01/12/08, 12,0125.39
ddmmyyy, 12,340.09

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-17 : 10:49:48
i think you need to use script task for this
Go to Top of Page
   

- Advertisement -