Showing posts with label online. Show all posts
Showing posts with label online. Show all posts

Friday, February 24, 2012

Integration Services in BOL: Is this all I get?

Short answer
NO, the beta or CTP Books Online that you're using is not all there's going to be. Make sure that you watch for the Web release of BOL that will drop around the time that SQL Server 2005 hits the streets! Read more to understand why.

More information
SQL Server 2005 is going to be released simultaneously in 8 or 9 languages. Since the documentation team had to lock down early to allow time for translation, the version of Books Online that you'll get on the CD in the box is going to be several months old. Think of the BOL in the box as Version 0.9, while Version 1.0 will be the RTM Web release. Meanwhile we're working non-stop to update, improve, and add to the Integration Services content in Books Online.

Remember that the BOL feedback links are your most direct route to improved content!

-Doug

Doug,
Are we going to be able to sync our local install with the web release?

-Jamie|||Jamie,

If you mean, will you see updated content silently downloaded on a topic-by-topic basis in your existing BOL installation, unfortunately, no. BOL and the Microsoft Help 2.0 technology that we rely on don't currently support that. The Web release around RTM that I mentioned will simply be a complete new BOL installation...and yes, a rather sizeable download.

We will, at least, be flagging content that has changed significantly so that you won't have to scan all the sections that interest you with the hope of coming across some new tidbit of information.

Best regards,

-Doug

Integration Services Configuration on Cluster

I've followed the books online help to configure SSIS (move the
MsDtsSrvr.ini.xml file, edit the file to have the correct path virtual server
name, and change the registry), restart all services...and nothing. I can
connect to SSIS fine through Management Studio, but when I click on Stored
Packages -> MSDB it hangs and eventually times out with this error message:
"The SQL Server specified in SSIS service configuration is not present or is
not available. This might occur when there is no default instance of SQL
Server."
I have a no default instance of SQL 05 on a failover cluster.
Also, I've tried every possible combination on the Server section of the
MsDtsSrvr.ini.xml file: server name\instance name, cluster name-.
Is it a dash or a backslash, I've seen different advice in articles, also.
thanks!Perhaps the configuration file isn't on the shared disk and available to
both nodes?
Please check out this article:
http://msdn2.microsoft.com/en-us/library/ms345193.aspx for complete details
of the required configuration.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Integration Services Configuration on Cluster

I've followed the books online help to configure SSIS (move the
MsDtsSrvr.ini.xml file, edit the file to have the correct path virtual serve
r
name, and change the registry), restart all services...and nothing. I can
connect to SSIS fine through Management Studio, but when I click on Stored
Packages -> MSDB it hangs and eventually times out with this error message:
"The SQL Server specified in SSIS service configuration is not present or is
not available. This might occur when there is no default instance of SQL
Server."
I have a no default instance of SQL 05 on a failover cluster.
Also, I've tried every possible combination on the Server section of the
MsDtsSrvr.ini.xml file: server name\instance name, cluster name-.
Is it a dash or a backslash, I've seen different advice in articles, also.
thanks!Perhaps the configuration file isn't on the shared disk and available to
both nodes?
Please check out this article:
http://msdn2.microsoft.com/en-us/library/ms345193.aspx for complete details
of the required configuration.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .