Excellent. Thanks for your help.

Thanks guys will give that a go

For anyone who is interested. I recreated this from scratch in BIDS. I had originally created the package in SSIS and then imported it into a project. This time I...

Hi

Thanks for reply. I am just trying from BIDS at this point

Thanks again

Thanks guys, that gives me something to go at

Thanks 🙂

If a record is found I want to ignore. Records wont change once entered.

Cheers

Hi Phil,

All the tables/Columns are the same in the remote sites (SQLEXpress servers). I am creating a table in the central SQL server the same.

All records contain a unique...

Does anyone have any ideas or areas/documentation to look at please

Thanks.

I will have a look at that but it seems a lot of work for such a simple request. I was hoping to be able to do it with...

Thanks for the reply.

I have tried the SUM(first) but this doesn't seem to exist as far as I can see. We need to bring back the other records as some...

Thanks Jack

Think I have got it:

=Join(Parameters!Parametername.Label, ", ")

seems to work OK

OK. Thanks for your advise. I will look at seting my db size to the disk space size. What concerns me is that what happens when the temp needs to...

Thanks again guys. We will see what monday morning brings and if I keep my job 🙂

Appriciate the help

Ok, thanks guys I have implemented this and put the 3GB switch in the boot.ini for good measure.

Seems to be running better but the PF usage in Task Manager is...