It looks like you're basically after the 2nd half of the year as peak period.

Is the time component important? I.e. if it's not critical that peak period ends 1 minute...

It does seem that BIDS keeps track of its packages and doesn't take too kindly to background operations.

Sometimes it will somehow lose a package that is currently open and ask...

Assuming that for whatever reason there is an open transaction that your packages are joining, what happens when you try explicitly denying transactions (NotSupported)?

Another suggestion is to try turning off...

Since SSIS is based on fixed metadata it doesn't normally do 'dynamic' in the way you are looking for.

The whole premise of SSIS is that you map source to...

1. How are the headings incompatible?

There are options to skip header rows which may help.

2. From memory the driver doesn't care too much whether a column is hidden, it selects...

The thing is that schemas belong to databases, not the other way around.

That said there are ways to query an instance and find any databases with a particular schema but...

You can of course just do your work in notepad and save it as per any file.

SSMS shouldn't be any different.

P.S. In my experience, whilst template packages work well their...

I get this error on one particular client site.

Google has plenty of suggestions, but given that we were not impacted by the error we never bothered resolving it.

To quote...

Some more thoughts:

How does it go without bulk load?

Is your package a child, parent, or single?

Try using a SQL Server destination, you may get more information in the error.

When running...

I've seen this one too.

From what I can tell, being a vague sort of error you can get it for various reasons.

From memory, points of interest are:

- Is it...

I have seen this, too.

The VPN will only make it worse, but I've seen slowdowns in large packages and also in projects with a large number of packages.

Given the number...

You're presuming I will stop the execution. :hehe:

But assuming I do stop execution:

The answer depends on how you measure your results.

At the end of running the code and after stopping...

This may be a long shot, but ...

In the past somewhere I've seen the symptoms described but couldn't place it.

Informix rang a bell but I was thinking Movex, so I...

Hi,

the file may well have been written manually.

It's just calling a single package and setting some variables and other options.

More likely though the package call itself was copied...

Correct, a lookup join will only return one value from the reference set for each...