Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Input column in Script task

Status
Not open for further replies.
sugu.bala

sugu.bala

Programmer
Dec 30, 2021
1
IN
Hi,
I am new to SSIS. My need is to validate data from SQL source and assign valid records in 1 table and invalid records into error table. My SQL source table name is dynamic. Is it possible to read dynamic input columns from this SQL source and pass to a script task. On for loop,will it fetch each column dynamically so that i have to perform validations against columns.

Kindly help.
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SSIS in SQL Server 2022
Replies
4
Views
343
grnzbra
grnzbra
grnzbra
  • Locked
  • Question
Editing Mappings Data Types in SSIS
Replies
0
Views
193
grnzbra
grnzbra
how2trainyourdragon
  • Locked
  • Question
SSIS Web Service task SSL errors
Replies
1
Views
200
how2trainyourdragon
how2trainyourdragon
arunaramana
  • Locked
  • Question
what are the items in a collection that referred in foreach item type enumerator within foreach loop
Replies
1
Views
211
Igelchen
Igelchen
rohitkochar123
  • Locked
  • Question
OLE DB Command Input has lineage ID 3293 that was not previously used in the Data Flow task.
Replies
0
Views
205
rohitkochar123
rohitkochar123

Part and Inventory Search

Sponsor

Back
Top