The amount of time a transaction log takes to restore is based on the size of the transactions and hence the number of transactions your source system has processed since...

Your description sounds like a pretty good workflow.

1) Use a source component to get the initial data set from the fixed width file

2) use a conditional split transformation based on...

The oracle OLEDB drivers tend not to work all that well with parameters in SSIS. Blame anyone you want, but they should be avoided.

Rather than using parameters, build the...

Ok, I'll add a bit more serious post.

Watch the licensing.

The developer edition is very nice, and inexpensive, and full-featured, and really only supports the one developer having access to the...

You are not being very specific about your issue and it is going to make it difficult to help.

If your query is taking a very long time, you are going...

Nice article.

I want to comment on your removal of the guts of the delete stored procedures by telling you to look up "Deferred updates".

If you update a column with a...

Stick to option 2 or 3. They are both pretty low maintenance and relatively easy to set up. If you only have a couple of tables you are...

Ok, so your source table is a different schema than your destination table and you cannot help it.

I'll give you three options.

First, you can specify to run a DTS package...

So you double-click the dtsx file and the dialog appears, but can you run it successfully from the dialog?

Transactional replication on hundreds of databases is a lot of lag reader agents - I would not recommend it.

If you can handle a warm-standby situation, log shipping will probably be...

Since you are mirroring, all of your eggs are in two baskets - so there is little risk.

Sharepoint database access is not much of a server load, so putting it...

Transactional replication can be configured to replicate in both directions, but in one direction it will basically be a batch of stored procedures (not very efficient). You may end...

You can set a default schema for a login.

As far as using schemas - it is a split topic. I like schemas and enforce my consultants to not put...

You consultant may have taken a wrong turn, or you may be explaining a bit poorly. Here is a scenario we have.

We have a single application for entering customer...

The machine EXECUTING your application must be an SSIS server. Where the package is stored, having the SQL client tools installed, etc. does not mean anything. To test...