CODEWITHSUNDEEP
ssis
rakamakafo
rakamakafo

Reputation: 1154

SSIS Data Flow doesn't copy all columns

I want to create a simple SSIS Control flow. Data flow structure is as follows enter image description here

Flat File source looks as follows:

enter image description here

And OLE DB Destination file looks as follows:

enter image description here

Table structure of WeatherHistoryStaging is looking as:

enter image description here

And than I've run packge, but only Date column is copied into WeatherHistoryStaging table, other columns are null. Before exetuting Data Flow task, I execute SQL Task, which deletes WeatherHistoryStaging table, that part works fine. Why not all columns are copied from txt file into WeatherHistoryStaging table?

Column mapping of Destination

enter image description here

Upvotes: 0

Views: 417

Answers (1)

JodyT
JodyT

Reputation: 4412

You have only mapped the Date colum. You're ignoring the other 3 columns that's why they're staying NULL. Select the correct source columns instead of <ignore> and it should work.

Upvotes: 1

Related Questions