I guess that sums up my 2 problems 🙂

1. If it's on a schedule, who is logged in?

2. How to to do anything that is not an SSIS package

I'm very...

My job has 3 steps. I use the file system task to copy an existing excel file to the output location. The next 2 steps have 3 destinations...

The Excel Connection is defined as variable XLDestination, which is populated from a parent package variable called XLOutput. XLOutput is assembled from 2 separate variables that are both set...

I've just hit this problem. Yes, my SSIS service is installed on a different machine to my client.

What I don't understand is why I can run a package with...

Cheers, Gordon, that did help and I'll keep a note of it. Actually, I'm so new I haven't got out of dev yet - I'm just trying to establish...

Hi Gordon

Thanks for the pointers. The conchango blog didn't cover my question but was packed with useful tips so I've saved the link for later.

I don't have access to...

No luck, I'm afraid. With or without the extra \, and whether I have a separate connection or use the variable in the File System Task.

It always evaluates OK,...

Frank. Thanks for all your help, but I think I'm going to have to find another way to solve this. I'm just too new to SSIS.

I worked out...

Thanks for the reply. I've been able to take this further but I'm still not getting it 🙁

I have 3 package level variables; EXFileRootDir, ExcelInput and ExcelOutput. They...

That did the trick. Thanks very much

The data access mode is 'table or view - fast load' and keep identity box on the Connection Manager is checked