Viewing 15 posts - 9,121 through 9,135 (of 13,876 total)
Koen Verbeeck (8/21/2014)
--Also, the subject line of the notification mail is suddenly full of strange characters.
Agreed - for example, for this thread, I see:
"RE: Avatar / Photo Issues?<!-- 864 --><!--...
August 21, 2014 at 12:38 am
romina (8/20/2014)
MMartin1 (8/20/2014)
Are you still using the looping? I don't think that will help. Just use a SCD transform and select it as a 'Historical Attribute' for the change...
August 20, 2014 at 11:59 pm
Tom Van Harpen (8/20/2014)
I am starting to see some benefits and after we get rolling I'm sure we'll find new and clever ways to use the...
August 20, 2014 at 11:43 pm
How about something like this?
declare @x table (TransId varchar(10))
insert @x
(TransId)
values ('4461'),
('14130')
...
August 20, 2014 at 7:37 am
What do you mean by 'statement'? Package? Proc?
August 20, 2014 at 1:07 am
Some quick questions and thoughts:
Are you migrating to the project deployment model?
Do your projects make full use of shared parameters and connection managers?
Have you changed the variables you want to...
August 19, 2014 at 11:50 pm
coreyjbaum (8/19/2014)
August 19, 2014 at 11:30 am
coreyjbaum (8/18/2014)
August 19, 2014 at 3:23 am
I think this might also work. A bit of a hack though - the split is much more elegant.
select replace(substring(storeNumber,10,7),'-','')
from dbo.StoreNumberTest
August 18, 2014 at 8:09 am
The SCD transformation can perform badly when compared against other approaches.
What type of SCD are you using?
When I refer to a set-based approach, I am referring to performing actions on...
August 17, 2014 at 11:52 pm
96,000 times round a Foreach loop sounds like a performance-killer to me.
It would be useful background to understand why you have decided to do things this way rather than...
August 16, 2014 at 4:29 am
I can't see a way of querying SSISDB directly to get this data. Which makes me wonder where SQL Server has put it!
But for those people who have adopted the...
August 14, 2014 at 1:28 am
Aha, OK - perhaps I should have considered that, thanks Chris. Sorry Alan.
I have reason to be picky - I'm building a WiX installer, so I'm in XML hell 🙂
August 13, 2014 at 5:19 am
I did part of this - I'm certain that you can work out the rest.
exec sp_MSforeachdb @command1 = 'use ?; select ''ALTER DATABASE ? MODIFY FILE ( NAME = N''+...
August 13, 2014 at 5:16 am
Alan.B (8/12/2014)
If I understand your question correctly you need to do what is referred to as a Left Anti Join Semi Join.
Not by me! Or anyone else, it seems....
August 13, 2014 at 4:46 am
Viewing 15 posts - 9,121 through 9,135 (of 13,876 total)