How is "The AS400 connection is configured to save the login and password"?

If you mean the checkbox in the ODBC dialog is checked, you are mistaken. Even the MS...

You can use a single account, but it will be less secure.

With a single account, you will have to give the account permissions to handle all actions that need to...

Analysis Services incremental updating is based on the idea that fact records should never be updated. You should only add new fact records to the table. If you...

Good point Matt.

However, if F1 got them here, shouldn't they be on a topic or article that, if read, probably already contained the answer they decided to post?

I'll throw in my 2 cents.

I moved 2 shops I worked at from VB6 to C#. I specifically avoided moving to VB.Net because much of the old syntax would...

Actually, the thread was originally about the poor posting, not the lack of ability of the posters. It's ok to ask basic questions, but some posts seem like spending...

The install for SSIS is not cluster-aware. MS has some solutions for this that work just fine. Check the MSDN website.

As far as the folder - you should...

Track the file name and execution times in a table somewhere.

I would suspect that your process is picking up a file more than once. A ForEach loop over a...

msdb..sp_help_job will return the status of job(s) to determine if they are currently running.

The non-empty behavior basically evaluates the empty behavior by examining the actual measure you select. This allows the calculation engine to eliminate having to run the calculation for the...

Yes and no.

SSIS is tied heavily to the meta-data. So, if you design your package through the GUI and select a table as a data source, the components in...

There are lots of ways to do this and all of them have their up and down sides. Search around the web for "slowly changing dimension" updates. Data...

Right, search the site a bit for batch large transactions. There are some posts and articles about doing this that will help you write the necessary loops.

A SELECT statement would have nothing to commit. What are you trying to do?

There is nothing built in for this. You will need to write some queries to figure out which records are new or changed and insert or update the tables...