| Author |
 Topic  |
|
|
opan
Starting Member
4 Posts |
 Posted - 04/23/2013 : 03:12:35
|
Hello,
I am trying to export to a flat file a column of varchar(6000).
Can someone help?
Thanks.
note: a left(4000) is the highest I can go. |
|
|
MIK_2008
Flowing Fount of Yak Knowledge
Pakistan
1054 Posts |
Posted - 04/23/2013 : 08:20:23
|
Is there any issue coming in while you're exporting the data to flat file? Or its just that you're looking for a solution as how to export it?
Cheers
MIK |
 |
|
|
opan
Starting Member
4 Posts |
Posted - 04/23/2013 : 08:50:53
|
quote:
Originally posted by opan
Hello,
I am trying to export to a flat file a column of varchar(6000).
Can someone help?
Thanks.
note: a left(4000) is the highest I can go.
Yes there is a reason, I already have a table with long text in it that I need to export. I am and would only be using a ssis to create the file. |
|
|
|
James K
Flowing Fount of Yak Knowledge
3873 Posts |
Posted - 04/23/2013 : 09:15:11
|
| You may be using DT_WSTR in SSIS. See if you can change that to DT_STR, which would then allow you a maximum of 8000. Since your source data is VARCHAR (rather than NVARCHAR), you don't need DT_WSTR. |
|
|
|
opan
Starting Member
4 Posts |
Posted - 04/23/2013 : 09:29:27
|
Thank you James for your response.
I was using DT_WSTR and I used DT_TEXT and DT_STR,
in a data conversion.
Still have the same issue. Here is the error message:
Error 1 Validation error. Create csv file: Create csv file: The data type for "Flat File Destination.Inputs[Flat File Destination Input].Columns[myColumnName]" is DT_NTEXT, which is not supported with ANSI files. Use DT_TEXT instead and convert the data to DT_NTEXT using the data conversion component. Packagename.dtsx 0 0
|
|
|
|
opan
Starting Member
4 Posts |
Posted - 04/23/2013 : 10:15:59
|
Thank you for all your responses...
James, I went again to my data conversion and were able to view what columns were input/output and I saw that I still had DT_ntext,
so, I changed that to DT_text and hover over to make sure my input/output had the right data type.
So, Its working now... thank you. |
|
|
|
James K
Flowing Fount of Yak Knowledge
3873 Posts |
Posted - 04/23/2013 : 10:53:04
|
| You are very welcome - glad to help. |
|
|
| |
Topic |
|
Export flat file varchar(6000)