Questions about flat-file
Read more about flat-file
python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
How to remove particular columns in SSIS package while doing transformation?
I want to remove a few columns from my flat file as I want to load in SQL server Data Warehouse using SSIS, How I can achieve this transformation using SSIS, see attachment for description. For e.g. I...
Dhananjay Tawar
Votes: 0
Answers: 2
SSIS import CSV file to existing table, using data type and sizes
I have an existing table in SQL Server to which a CSV file must be loaded. Using a Flat File Source comes up with the correct line endings and delimiter character. However, every column is configured ...
lit
Votes: 0
Answers: 1
Import multiple flat files in the same folder to SQL Server using flat file name as table name
I have been searching for an efficient way of uploading 100's of text files in the same folder to an SQL Server with one click of a button. I perform this every month, manually mapping the tables. It ...
pandasman
Votes: 0
Answers: 5