Yelena,

Its an interesting point. Its obvious that the use of the terms "synchronous" & "asynchronous" mean something different in an SSIS context than they do in a programming context and...

Hmmm...I was under the impression that BCNF is considered an enhancement of 3NF, but isn't the same. I've got a SQL Server DBA sitting next to me that concurs. This...

Yeah, its not a property of a component, its a categorisation based on what it actually does or, more accurately, how it does it!!

We'll have you building complex ETL streams...

[Just posting this up here so I know if anyone replies]

Yelena,

I don't have an IS instance to hand so can't check this out (I'll try and remember to do so later) but if you think BOL is erroneous, you should...

Fair point Scott. I realise the question should have been reworded slightly and was expecting a post such as yours when I re-read it this morning and realised the ambiguity (I...

Perhaps I should expand the explanation on this one a bit.

The metadata (e.g. source location, columns in the source, columns in the data paths, destination location, destination columns) of an SSIS data-flow...

Nice one Kristian. Reusability is key to the SSIS architecture. There's lots of possibilities in v1 with much more to come in v2 I'm *sure*!

-Jamie

Larry,

You're right, this can't be done and I agree that this is a big hole. Microsoft's stock answer is that BizTalk should ideally be used for integrating with Web Services...

Kathi,

I think BOL is a bit light on this. Could you use the "Send Feedback" link on the appropriate page to let the author know - it seems alot of...

As I said I am awaiting confirmation from MS. This definately used to work the way that I described therefore I think the new behaviour is a bug.

-Jamie

Yelena,

They will provide the same value. The difference is how you access them. ContainerStartTime is available as normal in a package whereas DTSContainer.StartTime is available programatically.

-Jamie

Hi Juergen,

Yeah, I wrote the QoD before I discovered what I wrote about in that blog post. Right now I'm pretty sure that the behavious has been altered and I'm...

Yes. SSIS can push to any data sink that is supported by OLE DB (of which SQL2000 is one of course).

-Jamie

Oh yeah. I guy I know went for an interview 5 years ago for a junior consultant role. His CV said that he had "some experience of using Oracle". When probed...