Skip to content Skip to sidebar Skip to footer
Showing posts with the label Flat File
Add Special Charachter In Ssis Flat File Column Header

Add Special Charachter In Ssis Flat File Column Header

Post a Comment
I am generating a Flat file from OLEDB Source using SSIS. I have specified column headers and mappe… Read more Add Special Charachter In Ssis Flat File Column Header
Text Column Not Storing More Than 8000 Characters

Text Column Not Storing More Than 8000 Characters

Post a Comment
I researched this and found that a text column in SQL Server can store a lot more than 8000 charact… Read more Text Column Not Storing More Than 8000 Characters
Importing A Txt File Into Sql Server With A Where Clause

Importing A Txt File Into Sql Server With A Where Clause

Post a Comment
I have a .txt file which is 6.00 GB. It is a tab-delimited file so when I try to load it into SQL S… Read more Importing A Txt File Into Sql Server With A Where Clause
Record Only Certain Rows Of A Text File In Ssis

Record Only Certain Rows Of A Text File In Ssis

Post a Comment
I'm having a hard time trying to do a simple loading of data from a flat file to a database. Th… Read more Record Only Certain Rows Of A Text File In Ssis
Ssis Mysterious Error

Ssis Mysterious Error

Post a Comment
I got only these 2 errors when converting flat files to database tables. The dataflow seems to work… Read more Ssis Mysterious Error
Ssis 2005 - How To Import A Fixed Width Flat File?

Ssis 2005 - How To Import A Fixed Width Flat File?

Post a Comment
I have a flat file that looks something like this: junk I don't care about \n \n columns name… Read more Ssis 2005 - How To Import A Fixed Width Flat File?