Viewing 15 posts - 76 through 90 (of 279 total)
May 19, 2017 at 10:47 am
DECLARE @filedirectory NVARCHAR(100) = 'E:\Temp\Filename\'
DECLARE @command NVARCHAR(1000) = 'dir /B "'+ @filedirectory +'"'
IF OBJECT_ID('TEMPDB..#tmp') IS NOT NULL
DROP TABLE #tmp
--Loop through all of the files
CREATE TABLE...
March 30, 2017 at 12:41 pm
March 22, 2017 at 12:44 pm
March 22, 2017 at 12:30 pm
March 13, 2017 at 11:31 am
March 9, 2017 at 12:42 pm
We already have stage Table and first we load to stage and then actual DW. But the requirement mentions to evn stop loading process and send email if you find...
March 9, 2017 at 11:55 am
March 9, 2017 at 10:20 am
March 8, 2017 at 1:20 pm
March 6, 2017 at 3:28 pm
February 21, 2017 at 3:29 pm
February 21, 2017 at 3:11 pm
February 16, 2017 at 3:28 pm
Viewing 15 posts - 76 through 90 (of 279 total)