Sorry, I cannot ask users to wait 15-30 seconds. In any case, even 30s might not be enough depending on the data size. Yet, regardless of data size, the first...

I'm mostly curious why SQL Server's async cursor population is not working as I would expect. I have no exact problem to be solved. In general, an async cursor population...

Well I ended up editing the XML directly (no testing connection waits there!) I did indeed inherit this package from times past and yes it is super frustrating. Perhaps down...

Hi John,

We did end up fixing this by doing 2 things:

We turned the log growth up higher, so that the log file is allocated more space during a growth...

Any thoughts? This still persists with my only workaround to use queue and several workers to concurrently process the log backups

Thanks both for your input!

An update --- I tested on another sql server instance on the same machine where I am implementing log shipping. After initializing only a few of these DBs I could...

Sure --- I found no other errors before that one --- so the log full error was the 1st error in the logs.

Thanks!

>What is the exact error message you are getting?

Error: 9002, Severity: 17, State: 2.

The transaction log for database 'DBNAME' is full due to 'LOG_BACKUP'.

>Why are you shrinking the logs...

Hi Craig,

Thank you for your interest --- it turns out replicating actually involves a little bit more work. The insert procedure is called by another and it only blocks...

I have definitely been there! SSIS can have a steep learning curve in some places.

Anyway, in your package, click the SSIS menu and click Variables. Add a string variable...

I have definitely been there! SSIS can have a steep learning curve in some places.

Anyway, in your package, click the SSIS menu and click Variables. Add a string variable...

Got it working --- the configuration file used to find the right path to a variable or property should NOT be created as this overwrites any ad hoc values provided...

OK so here is what I am doing:

create variable named test --- no value assigned, string datatype

right click flatfile connection, properties, expression, add expression as ConnectionString to the test variable.

So...

Elliot --- thanks for your reply. The problem is that once the variable is added, it cannot be changed at run time b/c the new behavior is such that the...