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.
| Author |
Topic |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2012-09-06 : 12:47:50
|
| Hi,We have a tables with 5 columns (bigint, int, int, int, int) and have 6 Billion rows and we are writing a simple export using SSIS:Source: OLE DB Data SourceOutput: Flat file destination (csv output file)Error: Flat file destination (csv output file)Somehow all the rows after around 1B are going to error file (64GB flat file), Is there any limit on rows that can be exported using SSIS and output to text file or known issue?Following is the error code information for all the failed rows in error .txt file:Error code: -1071607691Error Column: 17Note: Since all the columns are bigint or int so we are assuming output file as unicode/ansi/UTF-8 etc should not matter but we tried all the 3 types of output files anyhow and still same errorThanks--Rubs |
|
|
|
|
|
SSIS export of large table not working