Hi Danster,

One the CONTROL FLOW pane of your new SSIS Package (that's what they're called now), drag a DATA FLOW from the TOOLBOX TAB to your pane. Renamed it as...

In the package, what protectionlevel was used? The default is EncryptSensitiveWithUserKey - which, unless you developed, and deployed witht he same user that is trying to execute the job, is...

By the way, you can generate this for yourself by using the DTEXECUI (just run it from 'start','run','DTEXECUI'). You need to be able to open the package, but after you...

yeah - here's a sample. This run's a [ackage from file system. The important bit is that, while the package is still encrypted with user key, this won't help you....

To be honest, I think you are right. Am I right in saying that these packages have never run successfully at your site? They've only run from the developers sire?

SSIS...

I'm struggling with many of the same issues 🙁

Here's my take on some of the problems you are facing:

Does the SSIS do any file operations, etc.? If so, permissions should...

Ok, so you're proposing replacing the .Net script component in each of the 'child packages' with the ForEach file exist process? Not sure that would move me forward, since now...

Hmm - thanks for the response!

I'd probably have used the For Each File process to look for files in the folder and process anything that matched my criteria with a...

Are you using configuration files? If so, do you connect using SQL authentications, and if so, is there any chance the configuration file is missing the login name?

I'd be interested to see how you solve point number 4 in SSIS, or T-SQL for that matter, if you mean that the package will run continuously, polling the location...

I think I've found the problem. Seems I had 2 variables named the same name, with different scopes - one was package, the other was script. I suspect I was...

.. made some progress. I'm debugging, and when stepping through the .NEt script, I get to the end of the script, at End Main, and then .Net launches a 'Find...

thanks for that - silly copy&paste error.

Setting the breakpoint seemed to cause my SSIS to hang on debug - it opens and goes to the breakpoint, but doesn't seem...

Apparently, I added too much detail, and poeple are avoiding the question 🙂

I've tested doing exactly the same thing, but using CSV's as the source (i.e. text files and not...

Do any of your packages do network/file operations? If so, does the userid invoking the job have the relevant permissions?

Are you using Logging, and if so, what level of...