SSIS Tutorial Part 05-How to Load Fixed Width Text File to SQL Server Table in SSIS Package

The video tutorial explains how to load fixed width text file to SQL Server table by using SQL Server Integration Services( SSIS ) Package.

The video also shows
how to create ssis package from start
how to use data flow task in ssis package
how to use flat file source to read data from fixed width text file in ssis package
how to load data to sql server table by using ole db destination in ssis package
how to rename an ssis package in SSIS Project

Check out our SQL Server Integration Services ( SSIS ) Tutorial Step by Step

[krismaly]

It's nicely explained.

Refresh functionality explained well which is an interesting point.

Thanks for educating the community.

Questions:
You are demonstrating Fixed Width.
I see you chose Ragged Right instead Fixed Width in Format why? any reason?

Thanks a lot

[NavSingh-bw]

Hey TechBrothersIT, Thank You for such a great video.
What if I have multiple fixed Width Text files, how can we import that. I tried using For Each Loop container but its throws an error.
Thank You

[vaio]

Good demo ! however in case you have more then 100 columns is there any auto insert way to create the description of the column positions ?

[krismaly]

Topic explained well but at one point our aim was to move Fixed Data Length but you chose RaggedRight inspite of FixedWidth option was there. Was there any reason? In such cases you should explain why do you changed the subject.

I enjoyed watching this video and recommend others.

Thanks

[ericsos]

What about if the column are delimited by “/“ how to come up with a data row lengths

[dragonballsupere]

And why we are creating connextion manager again again .. ? Is there other option for one time connection..

[krismaly]

Revisiting.

I enjoyed watching this video and recommend others.

Question
Your demo is for Fixed Width.
Why did you choose Ragged when you have Fixed Width option?
Any reason?

Thanks for educating the community and your volunteership.

[krismaly]

I could create the sample on my machine works fine.
Thanks

[krismaly]

Question:

Demo is on Fixed Width data

Format you chose is Ragged Right

But there are two options
FixedWidth and RaggedRight in the Dropdown Box

What is the real reason to choose RaggedRight instead of FixedWidth.

Then When to use FixedWidth option from the dropdown box?

Thanks

[dragonballsupere]

What if column count is more than 50 or more... Then ...