Thanks a lot its working

declare @STR char(50)

select

@STR = " where strs...

its not working

declare

@STR char(50)

set

@STR = ''

im using MSDASQL ass linked server

Its working very slow???

I will do it amigo , Regards.

So there is noting to do?

First thanks,

second Yes i am talking about DatePart.

The reason the year 2004 has 53 weeks is because the last week in that year was mostly on 2004

The sql...

running internal access function from sql server dts.

Thanks alot Anyway Its not what i meant

bye.

how can i do it from the dts?

in the access data base i have some local table And becuse of that i cannot convert it to vbscript?

any other suggestion?

Im talking about creating macro in access.

How can i convert/run it not using access?

Hi and Thanks

i need to run access procedure ,after

a running sql sricpt from the dts.

regards.

the macro will exec internal function.

How can i do that?

Hi,

You mean that i can exec macro(from access) from the command line in my server.