CODEWITHSUNDEEP
sqlssis
shashi
shashi

Reputation: 108

insert data in destination table without defining meta data in SSIS package

I am creating an SSIS package which gets data dynamically, creates table in destination and inserts data there.

But I don't want to define meta data in script component so that when I select something from different source and different table then it simply insert that data into destination table. So please suggest which component I should use. to get every thing dynamically without knowing columns. Dealing with tables only not with excel or another type. Here is the snap shot of script component enter image description here

Upvotes: 0

Views: 259

Answers (1)

Tab Alleman
Tab Alleman

Reputation: 31795

You cannot do this in a dataflow at all. Dataflows have static meta data that must be defined at design time.

I recommend that you use BiML, which dynamically generates packages based on meta data at run time.

Otherwise you can do the entire thing (Source and Destination) in a single script Task (not dataflow component).

Upvotes: 1

Related Questions