InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 08:40:44 GMT20http://www.sqlservercentral.com/Forums/Topic1383213-1292-1.aspxFirst of all, is it really neccessary to export the BLOB column to a flat file? this will be huge.an alternative is to use SSIS...Tue, 13 Nov 2012 07:38:08 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1383213-1292-1.aspxHi all,What is the best (fastest) way to export data into a flat file if one of the columns is varbinary(max)?I am trying the following:[code="sql"]DECLARE @table VARCHAR(128),@file VARCHAR(255),@cmd VARCHAR(512)SET @file = 'C:\temp\' + @db_in + '.' + @schema_in + '.' + @table_in + '.dat'SET @cmd = 'bcp ' + @db_in + '.' + @schema_in + '.' + @table_in + ' out ' + @file + ' -n -T 'EXEC master..xp_cmdshell @cmdEND[/code]but it is taking some time and I am suspecting BLOB column being the offender.Is there another way?Thanks,Fri, 09 Nov 2012 13:04:21 GMTrightontarget