892717952 wrote: Thom A wrote:
What do you mean by "Dynamically" here? You can define the sources/destinations with expressions, yes, but the data flow part of SSIS has to be well defined so unless those objects all have the same definitions (which I doubt) then it won't be that simplistic. You'd end up needed to code your own Script Task instead; which you may well be better off doing outside of SSIS rather than in it.
"Dynamically" It refers not to export and import with wizard, I want to know if we can achieve this funtion with script
You can export/import data out of SQL Server via other methods, yes, but I wouldn't call the "dynamic". For example you can import data with a
BULK INSERT, or export it with
"Dynamic" tends to mean that you want to just "plug in" an object name and the system works out what you want from that; to which the short answer is no SSIS doesn't have that magic. You need to tell SSIS what it needs to do and Data Flow Tasks require explicit Data Definitions for their transformations; unless all your tables have the same definition (doubtful and if they do a likely design flaw), then you can't give SSIS those explicit definitions.
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.