That is the design.

I'm not going to write the code for you - there are lots of C# loop and copy file examples on-line.

Please have an attempt and then come...

pcd_au (8/21/2014)

---

My experience is more with SQL2008R2 SSIS than SQL2012 SSIS, and I'm struggling to see the benefit of the Project deployment.

The solution I'm working on requires reading source data...

I'd use a Script Task:

1) Read file names from table into an array.

2) For each array element:

a) perform the file-existence check:

i) If true,...

I see no avatars for anyone.

Maybe this would be a slightly better WHERE clause (handles NULLs)?

WHERE NOT EXISTS ( SELECT B1.[BedDays]

...

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