![\"Varchar8000_Warning\"](\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2014\/12\/Varchar8000_Warning.jpg\")
<\/a>value is out of the allowed range for the “varchar” data type<\/p><\/div>\n
The other error was when I attempted the perform the import operation:<\/p>\n
Could not connect source component.<\/address>\nError 0xc0204016:: SSIS.Pipeline: The “Source – < file name >_csv.Outputs[Flat File Source Output].Columns[ < column name > ]”<\/address>\nhas a length that is not valid. The length must be between 0 and 8000.<\/address>\nAdditional information:<\/address>\nException from HRESULT: 0xc0204016(Microsoft.SqlServer.DTSPipelineWrap)<\/address>\n\u00a0<\/address>\n\u00a0<\/address>\n<\/a>Error 0xc0204016<\/p><\/div>\n
RESOLUTION:<\/strong><\/h1>\nTo resolve this issue, it started on the “Choose a Data Source” screen.<\/strong>\u00a0 After I had chosen the CSV file, in the left panel, I clicked on “Advanced”<\/strong>.\u00a0 Then I clicked on any of the columns<\/strong>.\u00a0\u00a0 Notice that I click on the “LastAction” column.\u00a0 In the right panel, the Data Type is “string [DT_STR]”, and the OutputColumnWidth is 50.\u00a0\u00a0 Next I Clicked on the “Suggest Type…” button.<\/strong><\/p>\n![\"ChooseADataSource\"](\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2014\/12\/ChooseADataSource.jpg\")
<\/a>Choose a Data Source screen<\/p><\/div>\n
A pop up box appears named “Suggested Column Types”<\/strong>.\u00a0 In the “Number of rows:” text box, enter the estimate number of rows<\/strong> in the CSV or text file.\u00a0 I had found the number of rows in my import file by previewing it in Excel.\u00a0 Then I clicked the OK button<\/strong>.\u00a0 This may take a while, depending on the number of rows.\u00a0 I have gone as high as 500,000 rows, which took a couple of minutes.\u00a0 This processes scans the file, and gives recommended data types with the size.<\/p>\n![\"SuggestColumnTypes\"](\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2014\/12\/SuggestColumnTypes.jpg\")
<\/a>Suggest Column Types Pop-Up Box<\/p><\/div>\n
I searched each of the columns to find any column with a width greater then 8,000 characters.\u00a0 In the example below, the “Last Action” column has a record with 14,409 characters in it.<\/p>\n
![\"Resolution03\"](\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2015\/02\/Resolution03.jpg\")
<\/a><\/p>\nTo resolve this issue, the Data Type is going to need to be changed, because the “string [DT_STR]” can hold at max 8,000 characters.\u00a0 By changing the Data Type to something like “text stream [DT_TEXT]”, allows for more then the 8,000 character limit.\u00a0 The Output column width will change to zero when I chose “text stream [DT_TEXT]”.<\/p>\n
![\"Resolution04a\"](\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2015\/02\/Resolution04a.jpg\")
<\/a><\/p>\nAt that point, I was able to continue on with the export process.\u00a0 I did have to watch the column sizes on my table being imported into.\u00a0 However my import was successful.<\/p>\n
<\/a>Choose a Data Source screen<\/p><\/div>\n
A pop up box appears named “Suggested Column Types”<\/strong>.\u00a0 In the “Number of rows:” text box, enter the estimate number of rows<\/strong> in the CSV or text file.\u00a0 I had found the number of rows in my import file by previewing it in Excel.\u00a0 Then I clicked the OK button<\/strong>.\u00a0 This may take a while, depending on the number of rows.\u00a0 I have gone as high as 500,000 rows, which took a couple of minutes.\u00a0 This processes scans the file, and gives recommended data types with the size.<\/p>\n Suggest Column Types Pop-Up Box<\/p><\/div>\n I searched each of the columns to find any column with a width greater then 8,000 characters.\u00a0 In the example below, the “Last Action” column has a record with 14,409 characters in it.<\/p>\n To resolve this issue, the Data Type is going to need to be changed, because the “string [DT_STR]” can hold at max 8,000 characters.\u00a0 By changing the Data Type to something like “text stream [DT_TEXT]”, allows for more then the 8,000 character limit.\u00a0 The Output column width will change to zero when I chose “text stream [DT_TEXT]”.<\/p>\n At that point, I was able to continue on with the export process.\u00a0 I did have to watch the column sizes on my table being imported into.\u00a0 However my import was successful.<\/p>\n<\/a><\/a><\/p>\n<\/a><\/p>\n