Thanks for the reply. I eventually came up with a basic script that probably needs a bit of tweaking but the logic is there.

I will definitely have a look at...

Thanks for that information.

I also have another question. Once the source tables are loaded into the our staging area. I will probably have to use lookups to transform some of...

I haven't tried nested sets. Will definitely have a look into it this weekend. Thanks for the info.

Hi,

many thanks. will give it a go.

Hi,

Thanks for that, will make amendments now. Much appreciated.

Its not silly at all lol. Indeed I put quotation marks around the command and it ran perfectly via the sql job scheduler. What I dont understand is that if...

I tried doing the backup the job in 2 steps. i.e first step to do the backup and the second step to run a batch job to copy the...

Hi,

I edited the domain details and username etc beforehand.

I think your suggestion might be correct. I have looked at the history and the time for the backups to complete varies...

That seemed to work. I just had to add a PIVOT clause to reformat the data.

I managed to solve this by adding a 2 script tasks. One to create a list of the files in the directory and the another to dynamically change the filename...

Thanks. I wil give this a go.

Hi Jeff,

Managed to run the amendments this afternoon and found considerable improvement in performance. Whole thing loaded in just under 2min 30sec. Network traffic is high during that period so...

Hey jeff, sorry for not getting back to you. I have been really busy this weekend, but I am going to run the changes this evening. I will post either...

Hi Jeff,

Just ran this at work on some of the data and it the first CTE failed because it could convert the string type to datetime.

After running some queries to...

Thanks jeff. Will try it this weekend and let you know how it runs. Much appreciated