Viewing 15 posts - 5,416 through 5,430 (of 13,873 total)
Here is more feedback, a DBA and I are monitoring the job closer and...
July 11, 2017 at 10:12 am
July 11, 2017 at 10:07 am
The table is truncated each time before a load, it's laoding the same 1.75M...
July 11, 2017 at 7:47 am
July 11, 2017 at 6:38 am
July 11, 2017 at 6:07 am
July 10, 2017 at 1:54 pm
I would recommend storing the date_edited column in the target data too.
Then you can run a query to get max(date_edited) from the target table and use that date to...
July 10, 2017 at 1:47 pm
Sorry, but you misunderstood my meaning. I was not suggesting changing the proc, but the EXECUTE WITH RESULT SETS part.
Change this
EXEC dbo.ShopperSkuHistory
WITH RESULT SETS
(
July 7, 2017 at 1:48 pm
EXEC dbo.ShopperSkuHistory
WITH RESULT SETS
(
shopper_id char(32) NOT NULL,
skus ...
July 7, 2017 at 12:47 pm
This is a good solution architecture, IMO. If different customers have different file formats, there really is no way of getting round the fact that you need different packages to...
July 7, 2017 at 12:44 pm
Well done on getting to the root of that issue.
July 7, 2017 at 12:41 pm
Also, I hope that you and your users know and accept that (NOLOCK) means that you may experience the following symptoms:
1) Missing data
2) Reading the same data more...
July 7, 2017 at 10:31 am
You are on the right path.
Instead of
EXEC proc
You need
EXEC proc with result sets
as suggested by the error message. You need to describe the expected result...
July 7, 2017 at 10:28 am
July 7, 2017 at 8:59 am
Viewing 15 posts - 5,416 through 5,430 (of 13,873 total)