Create an SSIS Data Flow Task for each of the four flat files $($attached above$).$ Each Data Flow task needs to contain a Flat File Source and an OLE DB Relational Destination.

The standards at XVS Pharmacy are to load data to the staging tables with no data transformations. The staging tables are a one$-$to$-$one correlation to the four file layouts.

Requirements:

When creating your staging tables, make sure you use VARCHAR instead of CHAR data types.

Add a SQL Task to the Control Flow to truncate the staging tables.

Make sure you add precedent constraints between the SQL Task and the Four Data Flow Tasks. I need help with a step by step on howw to do this. I have four files with information I need help with.

Patient:$1258$ Matt Smith $203$ Norht Hazel Glenwood IA

$2258$ John Blue $40$ South Omaha NE

$2245$ Pete Jones $78$ North Maple Chicago IL

$2236$ Bill Powers $10$ Dodge Chicago IL

$2367$ Mark Bagg $234$ Elm Manhattan KS

$5523$ Jim Dau $445$ Oak Street New York NY

$3335$ Luke stier $999$ Maple Tabor IA

$3369$ Emma Dier $3349$ Happs Omaha NE

$2228$ Colleen Riek $3999$ Sams Carroll IA

Drug: $12958$ Heart Clear $2345$ B$44561995$ Cardioloty F$4456$ Whole Body $34\mathrm{.}561078\mathrm{.}56$

$12958$ Heart Clear $2345$ B$44441995$ Cardiology F$4456$ Whole Body $34\mathrm{.}564078\mathrm{.}56$

$12958$ Heart Clear $5555$ B$11111995$ Cardiology F$4456$ Whole Body $34\mathrm{.}56578\mathrm{.}56$

$13333$ Lung Guard $2345$ B$14521556$ Pulmanary B$3458$ Lung Health $10\mathrm{.}56234123\mathrm{.}56$

$13333$ Lung Guard $5555$ B$33331556$ Pulmanary B$3458$ Lung Health $10\mathrm{.}5634123\mathrm{.}56$

$13333$ Lung Guard $1111$ B$44441556$ Pulmanary B$3458$ Lung Health $10\mathrm{.}5612123\mathrm{.}56$

$15555$ Lung Work $2345$ B$56741556$ Pulmanary B$3458$ Lung Health $2\mathrm{.}569934\mathrm{.}11$

$15555$ Lung Work $1111$ B$56771556$ Pulmanary B$3458$ Lung Health $2\mathrm{.}564434\mathrm{.}11$

$15555$ Lung Work $2345$ B$56711556$ Pulmanary B$3458$ Lung Health $2\mathrm{.}561734\mathrm{.}11$

$33333$ Nervous Help $2345$ B$57671337$ Nervous W$3456$ Nerous Support $55\mathrm{.}111044\mathrm{.}11$

$33333$ Nervous Help $3345$ B$57691338$ Nervous II W$3456$ Nerous Support $22\mathrm{.}111444\mathrm{.}11$

Percriptions B$445604/15/201512581235$

B$444301/13/201522584078$

B$111102/13/20152245578$

B$145203/01/2015223610123$

B$333306/12/2015223634123$

B$444408/01/201522361012$

B$567407/14/20152367299$

B$567707/16/20155523244$

B$567104/01/201533351734$

B$576712/12/201533691011$

B$576911/23/2015222855441$

Store:

$2345$ WBG Feel Good IA Iowa WW$19$ Central Gold $5$

$5555$ Be Healthy NE Nebrasksa WW$199$ Central Gold $6$

$1111$ Get Well NY New York ZZ$15$ North Silver $9$

$3345$ Healthy Now IL Illinois NN$33$ North Silver $9$

Plesse help I lost my tutor had to wipe my computer just to get SSDT vsiuals will help Im a visual learner hands on