Thank you so much i appreciate the help, please could you explain what is a UNC drive and what is a mappped drive and how i could set up the...

thanks so much for the input i appreciate it and i wish you more sql server agent wisdom to help fellas like us, thanks

i cant tell if the volume of data has increased, i would maybe have to check and see but thanks so much for the input.

Yes the job completes without any errors from the sql server job agent

the package is copying files to a temp folder and then another process is picking up the files from the temp folder and dumping them in a database. trying to...

hey thanks for the info could you shed more light on it by giving me an example specifically

Thanks it worked i appreciate your help

well thanks for the tip, the guy whom i inherited the code from has a weird way or writing code which is crazy i have been trying to make...

where do i do that please

Thank you, but i have tried that and it doesnt still work nothing has changed any more ideas

am looking at the code and it seems ok what do i need to next

ok thanks i appreciate your answer ll give it a try and tell you how it works

Thanks for the response i would think that would be the case ll check it out and see

ll give it a try and give you feedback thanks

i want it to take a tabular result and turn it into a string that is from

1

2

3

4

int 1, 2, 3, 4