Yes - it can be done, but don't.

Use an OLE DB Command task instead. It is much easier to use and meant for what you are doing.

You do not...

Here is a how-to for precedence constraints with pictures that I created for someone else.

It should help.

Source:

SSNFEI

------- -----------

12343333

23454444

52126666

Destination:

ID_TypeID_Value

------------------

SSN1234

FEI3333

SSN2345

FEI4444

SSN5212

FEI6666

1) Select the source table using a data source adaptor (OLEDB or DataReader will work fine).

2) Multicast your dataset into two data sets (the Multicast component just makes a...

It will get a little complicated, but if you search on Google you will find some samples and pictures to walk you through it.

DTS had some good features, but SSIS...

In the toolbox when you have the control flow open you will find a component called a Foreach Loop Container. When you open the edit window for this component...

The answer to your questions is basically "No". Even in simple recovery mode, MS SQL writes to the transaction log. In simple recovery mode, it just truncates the...

Both mirroring and clustering offer hardware failover support, but they offer different failure protection.

It is true that you mirror user databases, not the entire server. Since you are unlikely...

SQL "Suspends" a process when it is waiting for a non-SQL resource to complete an action. A very common example would be that a process has requested a large...

You could try moving your processes into SSIS. If it is as simple as your example (copy form one table to another), you could try the SQL Server destination...

You really need to convert your SQL Statements into stored procedures that take parameters that do not overflow this 4000 character limit. I just do not think what you...

You will not be able to index that view.

You really do have to either spend the time to change the logic, or create a table called v1 and re-populate it...

Let's start with asking why you would want to do that? If you are trying to use a script task like the DTS dynamic properties task, don't.

Can you post...

RS does not turn landscape because the width is greater than the height. What it actually does is takes the defined width and height and compares it to the...

The only thing I will add is that if Microsoft follows their plan to only support two versions of a product, you may find SQL 2000 support is gone as...

You need to re-think your approach. Because the column is calculated (using a function, case, concatenation, etc.) you will always end up with a table scan of some sort...