SQLTeam.com | Weblogs | Forums

SSIS seeking Suggestion


#1

How can we configure our source and destination,
when name of the source file is keep changing, even though have fix header.

i am trying to design a SSIS package where folder contain two files, and the two file need to load on two different table

Can any one please share there expertise. i am new to SSIS.

Thanks


#2

use a For Each File loop (then you can pattern match, even if there's only one file)