Viewing 15 posts - 5,416 through 5,430 (of 13,877 total)
July 13, 2017 at 9:03 am
July 12, 2017 at 1:14 pm
hi
I have 13980 rows coming in excel files which containg employee status.
I need to load...
July 12, 2017 at 12:14 pm
July 12, 2017 at 7:41 am
July 11, 2017 at 2:29 pm
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
Viewing 15 posts - 5,416 through 5,430 (of 13,877 total)