CODEWITHSUNDEEP
sqlssismappingetl
user2721794
user2721794

Reputation: 423

SSIS Mapping and Transformation

I'm new to building SSIS packages, in fact this is my first package. I need to pull data from one DB view on Azure managed instance to an SQL on prem. I have built out the data flow and all. I'm moving data from a database view into a another database table but the destination table has a column that the source doesn't have hence my destination mapping view looks like (See attached image) How do I fix this or what are my options?

enter image description here

Upvotes: 0

Views: 71

Answers (2)

devesh
devesh

Reputation: 668

Its self explanatory that ignore(optional) means mapping for those columns can be ignored and if you want columns to be mapped with any calculated column you can do it by using derived column SSIS component Reference

As per your use case,try to use OLD DB component instead of ADO.NET component to optimize performance for a relatively large data set

Upvotes: 0

ReshaRoshla
ReshaRoshla

Reputation: 34

If this columns needs to stay empty in the source and you don't have it in source your best and only option is leave it like this. It basically needs to ignore it so no information will be fed. That will work.

In case you need information as current date you can add derivied column box in between your source and destination in your Data Flow where you can add current date or more columns that come from variable for example.

Upvotes: 1

Related Questions