Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL_Overview SSIS package for SQL 2008 Expand / Collapse
Author
Message
Posted Monday, June 15, 2009 7:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 8:24 AM
Points: 3, Visits: 65
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
Post #734976
Posted Friday, July 31, 2009 6:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 8:24 AM
Points: 3, Visits: 65
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


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

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
Post #763053
Posted Tuesday, December 8, 2009 8:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, October 24, 2014 7:58 AM
Points: 44, Visits: 495
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!

Post #830730
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse