Hi there, I am out of the loop on creating custom SSIS packages. I have a package already created ... but I have been having issues with it and realized its because the people who send me the excel files are changing the name of the Sheets every time they run. So, I'd like the package to just automatically get the name of the sheet. It will always be the first sheet but just the name of it is changing.
I found this link:
Which has some script task to do what I want to do... but I'm a dummy and I have no idea what I need to do to my package to put the script task in and make it work properly.
Can anybody walk me through it? Thanks.