Viewing 15 posts - 5,506 through 5,520 (of 13,876 total)
June 23, 2017 at 6:46 am
June 22, 2017 at 6:01 pm
This is simple in SSIS, and had you posted the question in the Integration Services forum, you would have had an answer by now.
Use something like (untested)
[code...
June 22, 2017 at 5:10 pm
June 22, 2017 at 4:48 pm
From the given filepath need to extract "ABC" from "ABCabcprices-20170621122040.txt".
Conditions : Severname and foldername...
June 22, 2017 at 2:08 pm
June 22, 2017 at 8:56 am
SELECT
item_name
, category = (CASE
WHEN item_name IN ('charger', 'cable') THEN
'electricity'
WHEN item_name IN ('pen', 'pencil') THEN
'accessories'
ELSE
'other'
...
June 22, 2017 at 8:30 am
June 22, 2017 at 8:03 am
You have missed a step, I think.
Create a new string variable, to hold the file name.
Configure the FEL to map the 'current' file name to the variable you have created.
Use...
June 22, 2017 at 7:37 am
Thom, I have not read your code in detail, but doesn't running a package execution in SYNCHRONOUS mode obviate the need for this polling?
June 22, 2017 at 7:29 am
June 20, 2017 at 10:55 am
Is G: a local or network drive?
Does the SQL Agent user have rights to the folder?
June 20, 2017 at 7:34 am
Jeff Moden did some articles on this. Start here and see how you get on.
June 20, 2017 at 7:33 am
June 19, 2017 at 1:34 pm
Try something like this
DATEADD( "d", -1 * DATEPART( "d", GETDATE() )+1 , GETDATE() )
Replace GETDATE() with your variable name.
June 19, 2017 at 1:22 pm
Viewing 15 posts - 5,506 through 5,520 (of 13,876 total)