In my case I just needed to replace the quote with a space.

The replace worked fine.

Thanks

I need to use access and recreate the SP that I have in SqlServer.

The file is access because its an MDB...

OK how about this. Is it possible to create a temporary table in access like in Sql.

In Sql we use the ##tbl_name....

I really am not sure. Access is new to me. I have not worked with Access much.

Mine is a diffrent error. Everything works fine...but when I go into the transformation properties and click the test button I get an error.

For your case are you pointing to...

I have not changed anything on the UDL. Its type Sql Server.

its very simple.

I have:

1 text file source, 1 udl and a transformation task between the text file and the UDL.

Then I map the column from the text file to the...

The text file is always there it never gets deleted.

Thanks

In the select statement I changed the table name where your retrieving the date.

Thanks Again

UPDATE AE SET AE.count_fact = dtCounts.count_fact

FROM #tmp_ar_exception AE INNER JOIN

(

SELECT DISTINCT #tmp_ar_exception.dt_id, COUNT(F_AR_Detail.date_id) AS count_fact FROM...

I changed it a little and it worked your a genuis coming up witht that code....thanks man

Thats really close, but It only updates one record not the two records it suppose to. Ill work on the code you supplied and see what I come up with.

I dont have a rule for one record.... I need to use both values that were returned by somehow use them one at a time to update. 

thats even better. thanks dude.

thanks for all the info....I think Meghana's script can help alot.

This looks really good, but It has to be dynamic. I have to load and leave.

Thanks for the heads up.