Microsoft SQL Server 2000 Resource Kit with CDROM

Hi,
Does anyone know if there is a similar book by Microsoft for SQL Server
2005? Thanks in advance.sharman
No, there isn't. The dev team at Microsoft specifically said they wouldn't
be expending the resources (no pun intended) to put together a resource kit,
because most of what would be in the RK was available through whitepapers
and the Inside SQL Server 2005 books (of which I am an author).
If there is something specific you're looking for, just ask.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:E218667C-120C-42E6-A8FE-F093CE13DC77@.microsoft.com...
> Hi,
> Does anyone know if there is a similar book by Microsoft for SQL Server
> 2005? Thanks in advance.

Microsoft SQL Server 2000 Resource Kit with CDROM

Hi,
Does anyone know if there is a similar book by Microsoft for SQL Server
2005? Thanks in advance.
sharman
No, there isn't. The dev team at Microsoft specifically said they wouldn't
be expending the resources (no pun intended) to put together a resource kit,
because most of what would be in the RK was available through whitepapers
and the Inside SQL Server 2005 books (of which I am an author).
If there is something specific you're looking for, just ask.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:E218667C-120C-42E6-A8FE-F093CE13DC77@.microsoft.com...
> Hi,
> Does anyone know if there is a similar book by Microsoft for SQL Server
> 2005? Thanks in advance.

metadata update

hi, I try to post a new question about metadata refresh...even if i see other thread that work on a similar problem.

I have a ssis package that import an xml huge file (500 mb); These are the main step:

1) generate a XSD file against xml using xsd.exe utility

2) using xml task, make a diff between the old xsd and the new

3) if there are no difference, I start the data flow task that import xml in sql server; otherwise I stop all the task, edit the data flow task, change the xsd reference in advanced editor and then make many "double clik / OK" on every single flow....

The underling idea is that xml file change because some columns are added but these columns are not interesting for my elaboration, so i can ignore this new column and work without mapping it.

What I'm looking for is a way for make, via SSIS, the "double clik / OK" steps....in other words, to update the metadata.

Could anybody suggest me a way? it's a sort of macro, or keyboard recorder...I'm trying to study xml package configuration; is this a good way ?

another way is to give to the end user the task to update metadata; for making this I need to open the package editor (visual studio..:!) in a more confortable environment....For example, is possible to edit the ssis package in ms access? probably i know the answer...

please, help me!

thank tou in advance

alessandro

Can I check my understanding?

You have an XML source file, correct? And its format (i.e. the xsd that describes it) sometimes changes, correct?

You want a way of changing the SSIS package at execution-time in order to handle this eventuality, correct?

If I've got all this correct then I'm afraid you cannot do this. The metadata of a data-flow cannot be changed after design-time.

-Jamie

|||

Thank you Jamie; you perfectly catch my question, and your answer is similat to other that I have seen on this forum. What I don't really understand is why there is this "limitation" (if i can say).

SSIS are many light year better of DTS (and not only...), but the thing I'm trying to do seem to be so easy....it's only a break in the execution and a sort of macro! At this point I don't exclude to trying a mouse recorder solution....

thank you very much for you answer

Alessandro