SQL_Overview SSIS package for SQL 2008

• yoak

  Valued Member

  Points: 53

  More actions

  June 15, 2009 at 7:17 am

  #206017

  Hi,

  I have been using the SQL_Overview SSIS package specifically SQL_OVERVIEW_Part3 containing SQL_Overview_Package.dtsx in SQL 2005 quite some time with no issues. I copied the package and Database over to my SQL server 2008 server, Ran the Visual Studio Conversion Wizard which ran the SSIS Package Upgrade Wizard,

  I try to migrate it to a SQL server 2008 server that claims to have completed successfully. However, when I open the package itself, it just hangs.

  Do you have a converted one for SQL 2008 that works well?

  thanks,

  YOak

• yoak

  Valued Member

  Points: 53

  More actions

  July 31, 2009 at 6:58 am

  #1032898

  Hi,

  I finally found out the problem to the issue I had listed here below. I only had named instances on my new SQL 2008 server and no Default instance. As soon as I installed a default instance the SQL_Overview SSIS package started working just fine. Thought others would want to know.

  thanks,

  Yvonne

  :hehe:

  --------------------------------------------------------------

  I have been using the SQL_Overview SSIS package specifically SQL_OVERVIEW_Part3 containing SQL_Overview_Package.dtsx in SQL 2005 quite some time with no issues. I copied the package and Database over to my SQL server 2008 server, Ran the Visual Studio Conversion Wizard which ran the SSIS Package Upgrade Wizard,

  I try to migrate it to a SQL server 2008 server that claims to have completed successfully. However, when I open the package itself, it just hangs.

  Do you have a converted one for SQL 2008 that works well?

  thanks,

  YOak

• MrSQLDBA

  SSC-Addicted

  Points: 417

  More actions

  December 8, 2009 at 8:34 am

  #1089278

  yeah I have a few issues with this SQL overview package as well

  a) I normally run this at the load server info level to get the machines domain name, but now the registry entry doesn't exist...anyone know how I can use SQL to get the domain of the machine?

  SET NOCOUNT ON

  DECLARE @chvDomainName NVARCHAR(100)

  EXEC master.dbo.xp_regread 'HKEY_LOCAL_MACHINE',

  'SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon',

  N'CachePrimaryDomain',@chvDomainName OUTPUT

  b) I run this to find all SQL server instances on the domain

  Exec xp_cmdshell 'sqlcmd /Lc'

  but none of my SQL 2008 machine are being picked up!