Browse by Tags

The SQL server specified in SSIS service configuration is not present or is not available. This might occur where there is no default instance of SQL Server on the computer

Published 3 March 8 2:2 AM | SSQA.net

Multiple versions of SQL Server installation is quite common when your enterprise is looking forward to upgrade to latest versions of SQL Server, in this regard recently one of the Application user reported a problem with regard to SSIS & DTS services...

Filed under: sql server, ssis, ssms, blog, service, 2000, 2005, integration services, packages, disabled

Using Management Studio unable to select "create one file per object"?

Published 17 October 7 4:6 AM | SSQA.net

One of the Developer complained that he is unable to create one file per object using Generating SQL Scripts within Management Studio. It is one of the good feature within SQL Server 2000 using Enterprise Manager where you can differentiate the objects...

Filed under: sql server, ssms, script, 2000, service pack2, 2005, management studio, enterprise manager, generate