Lab Sql

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

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

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

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

I got only these 2 errors when converting flat files to database tables. The dataflow seems to work… Read more Ssis Mysterious Error

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?

using SSIS 2012. My flat file connection manager I have a delimited file where the row delimiter is… Read more Ssis Reading Lf As Terminator When Its Set As Crlf

When I attempt to import a .csv comma-delimited flat file into a Microsoft SQL server 2008R2 64-bit… Read more SQL Server Import Wizard Treats NULL As Literal String 'NULL'