The reason for the group by is to get a 25 patient for nurse sampling for 2011. I have not filtered for 2011.

To be honest I know I am overseeing...

SSIS Control flow in an SSIS package using expressions in constraint editors

My solution and it works great is below:

--below section used for testing

update tbljobcontroller

set ParameterValues = '20100501,H4527,H5407'

where JobName...

Thanks you, You are right. Did not think to look inside the constraint editor and its properties.

I found an exellent tuturial to use expression within constrains here:

http://www.simple-talk.com/sql/ssis/working-with-precedence-constraints-in-sql-server-integration-services/

I made...

Hi,

I am trying what was suggested in the post as well and I cannot get the expression to eveluate without an error:

"exec [dbo].[spGetContractForCMS_ImportEDW]" + "'"@[User::RunDate_EDW] + "'"

I am using...

Thanks,

It is resolved.

There is a separate timeout property for bulk copies I added this line and ran fine w/o a time out: sbc.BulkCopyTimeout = 0; //adam

...

oh and Steve, its about 20,000 rows and 60 columns.

But I want to try it in case.Maybe it could hold it. How would I do that?

Thanks ALL!

Someone mentioned the for each loop container and vb script. But I do not want to do that becuase I seems like a lot of work becuase I...

Craig,

Thank you very,very much for that explanation. That helped clear it up!

Adam

Thanks, I copied and saved your code and saved in a .sql to pull up for next time which will be soon I am sure.

Thanks all,

I got quickly what I needed( CONVERT(char(8), CreatedOn, 112) = '20110208' ) from the link from Dave before I saw the other reply. But I will need to...

table A has a cascading delete to Table B if found.

I figured it out!

Well I started with table a with the plan on doing them one at a time. Then I replaced a with b then c using the same delete and all...

Sorry about my my poor grammar. I was frustrated and brain fried when I wrote that. I wish I would have seen the previous post. But I will copy and...

I am an Iraq combat vet. I speak english as a first language. I was just brain fired and frustrated in my post. I am new to cte, but I...

Yes, but my local server is not linked to the prod so I cannot insert into a temp on prod from my local instance and of course I have tried...