What tool are you using to connect to SQL Server?  I think that information will help people find a solution.

Russ

What you need to do is create a pseudo index.  Create a new query in Access, go to the SQL View.  Then enter

Create unique index PK_TableName on TableName (FieldName) with...

Are there any locks on the files?

You can set a setting in the package properties to log to sql server (which puts information from the steps into a table in...

Look at http://www.sqldts.com/default.aspx?225

Russ

PS:  As if you needed reassurance, I think that your plan will work very well.  I have done the same thing with other components.  It prevents users...

There is a little note in BOL "Guidelines for Using the FOR XML Clause:"  Generally, FOR XML cannot be used for any selections that do not produce direct output to...

To me the major advantage to certification is what you learn in the process.  I am a database developer, who has acted as dba in a couple single server shops. ...

I cut my teeth on DTS by using the import wizard.  I do an import, choose the objects to import, then rather than running the import right away, I save...

I'm not sure what you are doing.  Let me suggest what I think you are saying and  a solution.

You have 20 steps in your package.  I am going to guess...

Is the ODBC a system (machine) DSN or a User DSN?  It needs to be a System DSN to work.

Russ

A couple things to look for:  What version is the SQL Server ODBC driver on the Web box?

Run profiler and connect to the server that your web page is connecting...

There is no way to do this using T-SQL.

You can do it using visual basic.  This http://www.sqldts.com/?208 explains how to run a dts package.  You can run a similar program...

What you need is to apply a workflow to this process.  Select the first task to complete then the second (if they are transform tasks, select the target connection of...

What are the schemas for the three tables?  What are the unique/primary constraints for these tables?

Russel Loski, MCSD

I usually use sub-queries:

select t10.Partner, t10.staffname, t10.clientcode, t10.clientname, t10.DebtTotal

from

  (SELECT TOP 10 Partner, staffname,clientcode, clientname,sum(DebtAmount) AS  DebtTotal

  FROM tbl_Billsfortheyear INNER JOIN tblStaff ON staffindex = Partner

  group by Partner, clientcode,...

Do you have IIS installed?  And dot net framework 1.1?

Russ