thanks for the suggestion, however, I must have been thinking the same thing at the same time as you guys,

Here is my solution.

Update dbo.FCDataEntry

Set FC_UserQty6=mth7Qty.mth7

From

(

Select mth7.FCHdrID, Round(Sum(mth7.Mth7Avg*Mth7.strctmthFC8),0) as Mth7

from

(

Select MTHQTY.FCHdrID,StrCtMthFC8,--Checking...

Yes thank you

I have not used the Dynamic Property Task  - could you assist me an what I would need to input

Do you know why when I use the SQLDTS.com "Looping, Importing...

Sorry if I confused you. What I am trying to accomplish is the following:

1. Determine a list of files(.txt) that need to be used to import data. (I already have this...

thanks everyone for their suggestions.

Karen

I am confused in DTS when setting variables it ask for a path or directory, how do I get around that?  Also, If I change the code I will no...

Thank you for the suggestions - However, my VB skills are limited - I was trying to use DTS to create the global variable.  I understand how to set the...

I still get an error of Function not found when I parse the follwing query.

SELECT DISTINCT Q1.FilePath, Q1.ProjectNum, Q1.Filetype, Q1.DateModified

FROM         (SELECT     Col002 AS FilePath, Col004 AS ProjectNum, Col006 AS Filetype,...

Thanks for your great suggestion.

Karen

Thank you for all you hard work and helping me get my issue resolved - You are the BEST!!!!!

1 more issue - how to I modified the code to strip...

I am still having problems with my connection string- Please note the the server I am attempting to connect with is not a SQL Server -  it is a connection...

Thanks for the assistances, however, I have a problem with my connection string - could you please take  a look and make a suggestions

I am getting a Login Password error...

Thanks for all your effort, however, I found the fix I needed.

The solution is that the Server/Field names proper syntax should be:

OracleServer..Schema.fieldname

Thanks again.

I am still quite confused - Please help me with the correct syntax(order) of the query when using a linked Database server

ServerName = "SiteManager"

Database = SMODBC

User...

I can see the tables in the list of tables - however, I am unable to view the tables data.  Does this mean I am not connected?