Filling a created table

in searches found how can create dynamic script (using execute sql task) inside each loop supplied list containing name , other details table. however, when try fill table data flow, i'm not seeing object allow me map unknown columns.

however, in case search led me down wrong path, more general description. have 2 existing databases, i'll call them base , dynamo. base used app that's being being integrated app uses dynamo. base being redesigned.

for several tables need create new table in dynamo, name doesn't match name base, , columns not same. transforming data, know how in data flow.

the problem in column mapping. can attach tables using variables, i'm not finding way similar thing columns. identifying correct ssis objects can lead me solution appreciated.

thanks,
dave

it sounds you're trying design data flow connect columns don't know @ present - , know @ runtime.  ssis unable using bids designer - period.

however, may not exact problem, , if is, there still 1 last resort.

if know destination database structure like, , it's there no such structure @ present, need create "fake" structure program package against.  destination structure doesn't have exist @ runtime, have exist @ design time.

if don't know destination database structure like, option use ssis build package programatically in c# use ssis engine.  construct ssis package elements ssis api calls (all .net libraries), wire data flow(s), execute inside c# or vb.net program.  program query source structure in order determine how destination structure like, , construct destination structure dynamically.

---

SQL Server  >  SQL Server Integration Services