CODEWITHSUNDEEP
foreachssis
Doppelganger
Doppelganger

Reputation: 189

How do I change flat file source format in SSIS when it's inside a foreach loop?

My flat file connection manager has no file name selected because it's inside a foreach loop. With no file name selected, I can't add any new columns. These questions don't have the "no file name" issue, so they didn't work for me:

Add extra external column to flat file source

How to change flat file source using foreach loop container in an SSIS package?

How do I add a new column to my file format?

Here are my flat file connection manager and foreach loop:

Upvotes: 0

Views: 539

Answers (1)

mr.Reband
mr.Reband

Reputation: 2430

Just select a file name in your Abc flat file connection manager, then setup the structure.

If you're using a foreach loop container to cycle through filenames, then the file you choose won't matter -- it's used for design only.

If you get a run-time error because the file doesn't exist, then change the DelayValidation property in your Abc connection manager to True.

Upvotes: 1

Related Questions