Attached is the error message. I can only get this when running in debug with the VS process attached. When I double click it runs the Aquire Connection method then...

I downloaded that one already but I was more confused after looking at it. Are the inputs setup the same as a transformation? There are pieces I was looking for...

I'll elaborate on this monday when I'm back in the office, but no I don't get any error message when working in BIDS and double click to open. It just...

David,

Thanks for letting us know your resolution.

No I don't see. When does it commit? on every save? If so that's a problem since we can only commit a buildable working version.

Red Gate is coming out with...

What does this do for SSIS that...

Here's a few:

http://msdn.microsoft.com/en-us/library/ms141671.aspx

http://msdn.microsoft.com/en-us/library/ms137538.aspx

http://msdn.microsoft.com/en-us/library/ms141085.aspx

Do you have any specific questions? Sometimes it just helps to see a few examples.

One thing to try is to run the 32 bit version of DTExec to verify you get the same result. I had to do this once because one of the...

Greg,

Good points, also one thing I need to remember is they are a consulting company and developed this approach to make deployment to customers more streamlined. Also they probably have...

Jeff,

I figured I'd hear from you on this one. Like I mentioned in my prev post I've had data flows that I switched to stored procedures, I was in the...

ducon,

I think we're in the same boat on this one. I agree with your approach on updates, the OLE CMD in my opinion is nice to have but I've taken...

if you use standard edition this will lock the table until the index build is finished, will probably take longer.

Where is the version comment property? How do you access this from a package deployed as a sql deployment?

thanks, tom

1.) Is my assumption about loading it all into memory correct?

2.) Why does it do this?

3.) can I stop it doing this?

3a.) If not can I make it use my...

One way I could do this is to put the job Guid into a package variable using the Set Values on the job setup. See screenshot.