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...

This is puzzling.  Here are some questions I have.

Does the connection to SQL Server in each server use a trusted connection or do you specify a SQL login/password in the connection...

What are you trying to do?  If you are trying to copy a file in ActiveX script, you would be better off using the file system object.  See http://www.sqldts.com/292.aspx. ...

One of the properties of the filedialog returns the file name and path.  I just can't put my finger on it right away.

I don't have a .Net windows app open, so I may be off on certain details.  But here is the gist of what I would do:

dim f as new FileDialog()

f.Show()...

Try this:

http://groups.google.com/group/microsoft.public.sqlserver.clients/browse_thread/thread/53aa505a6aaaeaaa/4fe1fd11b0a51a62%234fe1fd11b0a51a62

I haven't seen that error before. Can you step through the code to find out what line the error is happening at? 

Is it giving a line number?

Try:

oConnection.ConnectionProperties.Item("Integrated Security") = "SSPI"

(etc)

If I am understanding you, this is how I would do this.  Some of this I think you are already doing.

Your process package has two steps and a couple global...

I'm going to try to answer the question of setting the connection.  There are a couple ways to do it.

You can add the following code (adapted from http://www.sqldts.com/200.aspx).

' Pkg...

Mark, you got me there!!  I corrected my original post.

My point was simply this:  it is far less expensive to software development companies to...

First, I would inform the vendor selling the application that you have begun to find a replacement for their product (even if you can't).  Application developers (and their managers) need...

Just a minor correction to your query:

select *

from table1

join (table2 join table3 on table2.col = table3.col)

on tbale2.col = table1.col

Select a.*, b.*, c.* from

(a inner join b on a.key = b.key) inner join c on c.key = a.ckey