 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Integration Services / February 2010how to export table to multiple csv files with size limitation
Hi there, I'm using SSIS 2008 and I need to export a table into multiple CSV files The requirement is the file can not be bigger then 60MB My table contain few millions raws How do I export into multiple csv files < 60MB each? Thanks, Oded Dror Easy - count the size of 1 record and make export by bunch of records that will less then 60Mb. Regards, Gennadi > Hi there, > [quoted text clipped - 5 lines] > Thanks, > Oded Dror Gennadi, There is no way to specify someware in the task itself? Thanks, Oded > Easy - count the size of 1 record and make export by bunch of records that > will less then 60Mb. [quoted text clipped - 11 lines] >> Thanks, >> Oded Dror No idea. I would do this as I described earlier- count length of one record and limit number of records in one export operation. Regards, Gennadi > Gennadi, > [quoted text clipped - 17 lines] > >> Thanks, > >> Oded Dror |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.