Using a Union All transformation with a Flat File

gravatar

cell

In this snippet, a union of the SurveyResponses and JuniorSurveyResponses is stored to disk via a flat file connection.

published 09.09.12

last updated 09.09.12


Share

                            


<Biml xmlns="http://schemas.varigence.com/biml.xsd">
	<Connections>
		<OleDbConnection Name="SportsData" ConnectionString="Provider=SQLNCLI10.1;Data Source=Localhost;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=SportsSurvey" />
		<FlatFileConnection Name="FlatFileConnection" FilePath="C:\users\paul\desktop\sportsOutput.txt" FileFormat="SportsSurveyFormat" />
	</Connections>
	<FileFormats>
		<FlatFileFormat Name="SportsSurveyFormat">
			<Columns>
				<Column Name="ID" Delimiter="Semicolon" TextQualified="false" />
				<Column Name="Sport" Delimiter="Semicolon" DataType="StringFixedLength" Length="40" />
				<Column Name="Team" Delimiter="Semicolon" DataType="StringFixedLength" Length="60" />
				<Column Name="City" DataType="StringFixedLength" Length="100" Delimiter="Semicolon" />
			</Columns>
		</FlatFileFormat>
	</FileFormats>
	<Packages>
		<Package Name="My Package" ConstraintMode="Linear">
			<Tasks>
				<Dataflow Name="My Dataflow Task">
					<Transformations>
						<OleDbSource Name="SurveyResponses" ConnectionName="SportsData">
							<DirectInput>select * from SurveyResponses</DirectInput>
						</OleDbSource>

						<OleDbSource Name="JuniorSurveyResponses" ConnectionName="SportsData">
							<DirectInput>select * from JuniorSurveyResponses</DirectInput>
						</OleDbSource>

						<!-- Does a union of the SurveyResponses and JuniorSurveyResponses to the flat file specified by FlatFileConnection. -->
						<UnionAll Name="Union All Transformation">
							<InputPaths>
								<InputPath OutputPathName="SurveyResponses.Output" />
								<InputPath OutputPathName="JuniorSurveyResponses.Output" />
							</InputPaths>
						</UnionAll>

						<FlatFileDestination Name="OutputFile" ConnectionName="FlatFileConnection" />
					</Transformations>
				</Dataflow>
			</Tasks>
		</Package>
	</Packages>
</Biml>
                        
You are not authorized to comment. A verification email has been sent to your email address. Please verify your account.

Comments

There are no comments yet.