Viewing 15 posts - 5,506 through 5,520 (of 13,874 total)
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
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
= (DT_DATE) DATEADD("DAY",...
June 19, 2017 at 12:42 pm
SELECT DATEADD(dd, DATEDIFF(dd, 0, GETDATE()) - 1, 0);
Change -1 to -2 for day before yesterday.
June 19, 2017 at 12:16 pm
For file operations, I would normally expect to see a File System Task or a Script Task being used. Why are you calling an executable to do this?
June 19, 2017 at 10:43 am
June 18, 2017 at 8:26 am
Please read Chris' post again, particularly this:
For the main part of the query, start with hard-coded for testing then recode to dynamic sql when you're done.
He's giving...
June 16, 2017 at 9:10 am
June 16, 2017 at 6:20 am
Viewing 15 posts - 5,506 through 5,520 (of 13,874 total)