Agreed - for example, for this thread, I see:

"RE: Avatar / Photo Issues?<!-- 864 --><!--...

romina (8/20/2014)

---

MMartin1 (8/20/2014)

---

Hi Romina,

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...

Tom Van Harpen (8/20/2014)

---

Thanks for the response Phil.

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...

How about something like this?

declare @x table (TransId varchar(10))

insert @x

(TransId)

values ('4461'),

('14130')

...

What do you mean by 'statement'? Package? Proc?

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...

coreyjbaum (8/19/2014)

---

Thanks for the reply. The stored procedure im calling isnt using temp tables but it is generating a guid as a result. The stored procedure is apart of another...

coreyjbaum (8/18/2014)

---

Im trying to use and OleDBCommand to execute a stored procedure with a bunch of parameters. After scouring the internet i tried using WITH RESULT SETS NONE at the...

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

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...

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...

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...

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 🙂

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''+...

Not by me! Or anyone else, it seems....