Here is my try at this, the code runs ok but it does not create a folder for me ?

Any ideas

declare @md varchar(100), @Path varchar(100),@wk_novarchar(2)

set@wk_no = datepart(wk,getdate())

--print @wk_no

SET@Path...

Thanks for the very detailed reply my mail session did not have the profile set to MS Exchange setting which you refred to in your reply. Am currently running a...

Thanks guys i'll have a look at both and let you know..

Am using DTS packages but i've also some SSIS package also

The problem seems to be the send email task of the job when its schedule to run it get stuck on this step..

I can run the DTS package and it work fine, But the schedure job is not finishing it always seems to hang on the last step most of my last...

Most of the jobs are for a data warehouse so they are doing ELT work and most of them are work off different tables and databases.

This has only happen recently...

I don't think its possible to look at DTS packages in SSIS VS you can run them but you can open and edit them.

Hey i need to be able to know which extension as not all of the files go into the same table.

i've the 6 files and they are named like...

Am using 2000 but its on 2005 interface. So is there away around this ?

I copied your query into my QA and changed the table name and ran the query. It gave me a error

Here is the query

declare @top int

set @top = 25

select...

Hey i tested this and am getting a Error on the @Top paramter it seem to not like the @Top in the Select statement

Hey thanks for the reply, i had a look at the file and it seem that the file had some funny characters in the column and its that which is...

Thanks for your help nite_eagle.

I do have another question you might be able to help me with. Am after making this change to my SSIS package, and have saved...

Thanks for the expression below, i've just one question regards it, i know both the findstring and right, the ? is use for the logic but am not sure why...

Sorry guys that was a typo on my behalf, i only want to remove the first character if its a 0.

0123 will become 123

2349 will stay the same

I'll test...