Bulk insert / import csv

thanks, Its not the DTS that had a timeout its the website that couldn't access the SQL Server.

and about scripting...we are talking about 70,000 rows just for this csv table
and it will take a very long time and will cost time and time morethen and bulk insertprocess.
i did a test on my dev server i used SQLStatementGenerator to generate insert script
it generated a 20mb text file(took some while)theni tried using that simple 20mb scriptafter and1 hour my dev server crashed....

the csv file i need to import is about10mb and i have to import it daily without having website downtime.

 

Hello,

anyone has a solution for importing 10mb csv file daily into sql2005 ?

i have tried bulk insert but DiscountASP prohibits this operation so my sql login dont have bulkinsert permissions.
i have tried DTS from my computer but i takes over 15min and during that time the site connection to the sql is timeout

Thanks.