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 |
|
ocla
Starting Member
2 Posts |
 Posted - 2009-02-06 : 15:06:14
|
| Hi,I am learning to use SSIS (french version) for creating packages. I am getting the following validation error on the flat file component ...[Source du fichier plat [18002]] Erreur : « Le type de données de « colonne de sortie « Colonne de sortie d'erreur de source de fichier plat » (18090) » est DT_NTEXT. Ce dernier n'est pas pris en charge par les fichiers ANSI. Utilisez DT_TEXT à la place et convertissez les données au type DT_NTEXT à l'aide du composant de conversion de données. »I'd appreciate if someone can help me. |
|
|
dhumphries
Starting Member
18 Posts |
Posted - 2009-02-06 : 16:45:14
|
| Would it be possible to post a translated version of the error? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-07 : 09:19:58
|
| please pot error in english. from waht i see, i think it might be problem with NTEXT datatype. are you sure your data types of flat file and destination match? |
|
|
|
ocla
Starting Member
2 Posts |
Posted - 2009-02-09 : 11:17:01
|
| I've got a script component that splits the output column error. Itseems like this : ' ' Add your code here ' Dim Error_Data As String Dim Buffer As Byte() Buffer = Row.ColonnesErreur.GetBlobData(0, CInt(Row.ColonnesErreur.Length)) Error_Data = System.Text.Encoding.ASCII.GetString(Buffer) Dim Split As String() = Error_Data.Split(CChar(",")) Row.Split1 = CInt(CStr(Split.GetValue(0))) Row.Split2 = CInt(CStr(Split.GetValue(1))) Row.Split3 = CStr(Split.GetValue(2)) Row.Split4 = CInt(CStr(Split.GetValue(3)))Thank you. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-09 : 11:23:19
|
| whats the error? |
|
|
|
|
|
|
Flat File Source Error