Yes, same instance

Thanks

Thanks

In answer to your question:

1.       The source is another table in another database and I am using a dataflow task to move it from one table to another. The source...

Great, thanks

I will give that a go

Thanks all

So, I've spent a little bit of time on this

I am doing a little bit of manipulation on staging (also comparing to what exists) before moving it live -...

Very good set of articles

One question regarding storage and indexes - hopefully it makes sense

Using the sample code.

If I have something like:

select product
  , count(*), sum(SalesQuantity)
from...

For what it's worth, I'm getting the same issue and have yet to find a resolution

In my opinion, VS is pretty poor when used for SSIS dev. Just too many...

Thanks for the response Grant

Think I'll go with the COUNT and COUNT DISTINCT then.

Just wasn't sure whether there's a quicker option (bit like doing a count using sys.table and sys.partition...

Thanks Brian and Phil

I'm just going to try a couple of your suggestions and gather some information

Agree regarding Azure...

• This reply was modified 6 years, 3 months ago by DamianC.

Must admit I'm pretty annoyed by this as I'd planned to do both the 70-767 and 70-768 this year, having worked through 70-761 and 762 in the later part of...

It is Phil. Apparently it was a bug in 2017 (read somewhere) and a patch fixed it. It wasn't fixed in 2015. I have the latest 2017 version and it...

Thanks AVB

Thanks Chris

Thanks for the responses

@Phil - it's not creating issues. More curious/concerned

The reason I went to VS2017 was down to a bug in 2015 that just wiped the script and variables...

Thanks Phil

I'll take a look at that