I am going to step out on a limb.  I can't think of a way to test my answer.

Check the windows groups in your SQL logins, including Domain Users (if that...

I think that is what I will do, since Task3 does not take too long to run.  My goal is to have Task3 run while Task1 on another set begins.

Try this article:

http://www.sqlservercentral.com/columnists/awarren/triggerscolumnsupdated.asp

The more complicated:

select a.Part, a.QtyBreak, a.Price from tbl a

inner join (Select Part, min(QtyBreak) as QtyBreak from tbl

group by Part) b

on a.Part = b.Part and a.QtyBreak = b.QtyBreak 

I am going to make one assumption:  Price doesn't have null and Price gets lower as the QtyBreak gets lower:

Select Part,  min(QtyBreak) as QtyBreak, min(Price) as Price

from tble

group by part

I can do this in a stored procedure for a single row (multiple rows with a little fudging).

declare @Location varchar(255)

select @Location = nz(@Location + ' ', '') + nz(Acct.Location, '')

FROM dbo.PM_PatientData...

The first thing to try is

AVG(CAST(SUBSTRING(A.Score, 1, len(A.Score) - 1) AS int))

By using SUBSTRING(A.Score, 1, 2) "100%" will be 10. 

On whatever computer you are running dtsrun, you will need to have the DSN.  The package knows that the connection is identified with the DSN X.  DTSRun is going to...

What result did you expect to get and what result did you actually get?  What was wrong with your results?

Are the join columns compatible?  One isn't an integer and the other a string that contains numeric data (most of the time)?

Is this a straight Access table or a linked table to SQL Server?  I'm at a loss.

Just a couple modifications if you are using VB.Net.  You need the text property.  I believe that the Text property always has at least an empty string.  I would use...

oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('" & Textbox1.Text & "', '" & Textbox4.Text & "', '" & Textbox7.Text & "')"

http://msdn2.microsoft.com/en-us/library/system.windows.forms.filedialog(VS.80).aspx.

http://msdn.microsoft.com/msdnmag/issues/03/03/CuttingEdge/

The latter is C# code, so you will have to convert to VB.

Let me get some low lying fruit.  The following statement is erroneous because of the t1.  The t1 doesn't belong after the where clause.

 (

 select * from tblInternalEduModule Where Category...