another option is code entire solution inside a script task which references variables like SourcePath, DestinationTable.

again, hoping for more of a standard SSIS solution and minimise the scripting side.

May also...

John Rowan (4/25/2016)

---

Well, this is more of a work around than a fix, but since you know the exact naming convention of the tabs, you could write a query to...

Package

ForEach Loop Container

-> Collection

-> Enumerator Configuration

...

Yes, every iteration of the loop shows this hidden value assigned to the user variable SheetName.

I can clearly trace this via the Watch window as the package executes.

The connection between...

No, that object is a hidden one apparently, having read some feedback from another forum.

None of my tabs are called this and there are no hidden tabs (that you can...

actually previous post was slightly inaccurate.

basically, there is no error as such - the package just doesn't move on to next tab.

It iterates 9 times around the "_xlnm#_FilterDatabase" and then...

yeah I've used breakpoints to debug and the user variable gets assigned to {_xlnm#_FilterDatabase} value. Then errors out at data flow task with:

"the type of the value (Empty) being assigned...

and thanks for taking the time to impart your valuable advice.

P.S. just posted another which you may find interesting - that old nugget of loading Excel to SQL

Phil, it turns out that if I run Visual Studio Pro 2012 on server "as admin" then I'm able to save and execute package (fixed minor errors).

In addition I deleted...

Phil,

When I start Visual Studio 2013 Shell (Integrated), open project and I upgrade it says Upgrade Complete, albeit with several warnings and 2 errors. Main error is "invalid connection" (the...

So if you read again my first post I detail exactly what happens when I try to upgrade. This is what I'm trying to resolve, and hoping to get advice...

Yeah but does that mean I have to recreate the packages on 2013 from scratch? At the moment I'm unable to upgrade.

Hi Phil,

Thanks for info but I'll try to just elaborate on my specific issue.

I deploy from Visual Studio Integrated Shell 2012 to server running SSMS 2014.

My configuration is - Desktop...

this is SSRS - sorry, should have said