The script task only supports VB.Net for SQL 2005. 2008 gets you C# as well.

Basically, you will drag a script task into your data flow. You will be...

Configuring replication may take some down-time depending on the type of replication, the configuration done, if it is going to require schema changes, etc. It often does not require...

It's all based on the object model of the code you are calling. You reference it just like you would if you were writing an application in C#. ...

My posting got sanitized.

setting variables from the command line looks like:

/SET "\Package.Variables[User::gvSourceId].Value";101

You can set values of variables and other package properties through the command line execution of a package. Here is a sample I sanitized a bit:

[font="Courier New"]/SQL " "...

That's the tools on your local PC - the one running Management Studio, not the database server. The sp on the server makes no difference on this part.

You can call another assembly through script tasks. A script task can be a task in the control flow, or a source, transformation, or destination in the data flow...

Make sure your Management Studio is up-to-date. I think the options were missing until sp2. Help-> About make sure Management Studio version is 9.00.3042 or higher.

Flush your procedure cache. Update all of your statistics. Like I said, the statistics are pretty likely to be your issue.

You need to update statistics after upgrading a...

Right click the table and bring up the designer.

In the "Table Designer" menu, click "Indexes / Keys".

Add a new item with the Add button.

Change the "Type" property to "Unique Key".

No

I hate replying to postings that were cross-posted, but in this case, I am going to.

Hardware is not the only thing SQL Server uses to determine execution plans. You...

You could do this one of two ways that I can think of.

The first would be to use a script task and simply generate multiple output rows per input row.

The...

I too think Service Broker is actually great and I have probably over-used it to solve things that could be otherwise handled more easily.

Nope, there is no GUI for Service Broker (unless you count the template scripts). That was my point.

I tried to type as sarcastically as possible, but apparently pressing harder...