Viewing 15 posts - 4,726 through 4,740 (of 13,877 total)
February 6, 2018 at 12:13 pm
OK, this is getting tough 🙂
Are any of the parameters marked as Sensitive?
Can you confirm from the All Executions reports that the values of the parameters...
February 6, 2018 at 11:31 am
February 6, 2018 at 11:29 am
add data in a way that it matches customer key
Please expand on the above.
February 6, 2018 at 11:24 am
Hmm, OK.
Where, exactly, are you seeing this message?
..., with a message that the 'expression cannot be parsed'.
February 6, 2018 at 9:05 am
Try something like this
BEGIN TRY
IF NOT EXISTS (
SELECT 1
FROM dbo.view_MyView
WHERE MemberID = @MemberID
)
BEGIN
THROW 50000
,'MemberId does not exist'
,1;
February 6, 2018 at 9:03 am
February 6, 2018 at 7:35 am
February 6, 2018 at 6:58 am
February 6, 2018 at 6:35 am
Steve has got it right, despite his 'not much of an SSIS guy' disclaimer 🙂
Use a FOREACH loop to process the file, even though you know that there...
February 6, 2018 at 5:50 am
Viewing 15 posts - 4,726 through 4,740 (of 13,877 total)