Plan a bit for the future also.

If you expect another 100 users over the next year, CAL licenses may be expensive.

Then again, if you have hardware upgrade plans buying a...

What steve was asking about the application is if it is an off-the-shelf product you purchased that already includes a SQL CAL.

I am assuming the application is one you built...

I did not fully understand what you wrote.

I think you are looking at your source component, not your destination component.

The batch settings I am referring to are on the OLEDB...

Unless you add the column as the last column in the table, the script MUST create a new table and copy the data (causing a new set of indexes to...

In many cases, when you make a change to a table through Management Studio, the change is scripted as the creation of an entirely new table structure and then the...

If you are using an OLEDB Destination in your data flow, open the editor for the component.

For the data access mode, choose "Table or view - fact load".

The options will...

It depends on how you are importing the rows. If you use SSIS and an OLDDB destination adaptor to your SQL server, you can set the batch size and...

There are only two things I have run into.

SSIS can be a bit challenging if you are running it from a 64 bit server. You just have to remember...

There are lots of options and, unfortunately, you are going to have to look carefully at your situation to choose one.

Here are some things to think about.

SQL 2000 and SQL...

SSIS does not like to save passwords. There is a property for the package called "ProtectionLevel" that will allow you to save some passwords based on a package password...

All of the providers work fine.

Make sure you are using a compatible oracle client (10g works well - many older clients are less than compliant with a lot of software).

SSIS...

That is what I was reading into it, but I did not want to attack with "why are you trying to build your own locking mechanism?".

If anything, replacing this entire...

To get a deadlock, you have to have a connection lock at least two resources in a single transaction. It is mostly a timing issue.

Here is a pretty typical...

What is calling this, how often is it being called, and what exactly are you trying to do with it?

In order to achieve a deadlock, you must have at least two locks taken on one of the connections. Lock escalation cannot do this - if that were the...