In other words does a DataFlow Task implement a cursor beneath the sheets?

No, the Dataflow task is row based.

Yah, I was the one that kept telling you it was there.

It all come clear to me now that there is a bit...

You can use the HIS DB2 provider. Also, SS2K5 is shipping with a DB2 provider in the box.

K

Ah, output parameters...

Well, now, that's a different story altogether, isn't it. Eh hem...

K

That's actually a better approach. It's simpler and like Jamie says, always works. It even works for cases where the DAC wouldn't normally allow parameters like for table names and...

http://sqljunkies.com/WebLog/knight_reign/archive/2005/10/05/17016.aspx

Whidbey is the code name for VS products from Beta 2 to RTM (Release to Manufactures). 

Yeah, I think I was aware of that.

My issues are version specific and deal...

Is there a question in there? I'm not sure what it is you're asking. If you have Whidbey installed, you'll be able to load your BI projects in the same...

Nice article!

Universe.Earth.Software.Microsoft.SQLServer.IS.KirkHaselden

I'm not terribly familiar with Rendezvous, but I think the difficultly will lie in the differences between Rendezvous' subject based addressing and MSMQ's destination based addressing using queue names.

If...

Sorry Kathi, I haven't seen this. Will you please open a bug and attach the package that's giving you the problem? Thanks, K

Does the SSIS provide any features for real time data loading?

Yes

Is it compatable with TIBCO?

It is comparable to TIBCO Data Exchange in some ways. What compatibility are...

As Jamie Thomson found out, comparing SSIS to Informatica is definitely not an apples to apples comparison.

http://blogs.conchango.com/jamiethomson/archive/2005/03/22/1172.aspx

Ash blogged about upserting in SSIS here:

http://sqljunkies.com/WebLog/ashvinis/archive/2005/06/15/15829.aspx

HTH

I've never attempted this, but have heard that people are doing it without issue.

Can you tell me what providerr you're using for the destination?

Do you still need an answer to this? It's basically an issue with certificates on the server and is fixed in the June CTP.