I am using ssis 2008,i have folder in which i have 10 excel file.i wont to load them one after other in data base
I have created a Dataflow task that load one file into database.i have inserted this dataflow task into For each loop
and in For each loop i have give that folder path and *.XLSX and in variable mapping i have created one variable which i have passed in Database destination connecion string (properties->expression)
but still i get error "cannot acquire connection from connection manager"
please guide me or provide me with some reference so that i cud load file from folder into database one after other
View Complete Post