Friday, April 19, 2013

[SQL 2012] Switching data warehousing to SSIS from Cognos

[SQL 2012] Switching data warehousing to SSIS from Cognos


Switching data warehousing to SSIS from Cognos

Posted: 19 Apr 2013 02:08 AM PDT

Has anyone switched to using SSIS for their ETL? Currently using Cognos Data Manager but possible we're going to switch to SSIS so interested in experiences, tips, pitfalls, etc...Thanks.

SSD + HDD Server, where I install os, sql binaries, mdf, ldf and tempDB?

Posted: 18 Apr 2013 11:36 PM PDT

Hello,My company has a new Server:64 GB RAM2 x Intel 320 SSD 120GB RAID12 x SATA3 1TB RAID 1We will use this Server only for SQL Server 2012, for an small 10GB database, with high workload.I would like to know wich is the best ditribution of OS, SQL Server 2012 binaries, MDF, LDF as TEMPDB in this Hardware.Thanks.

Enabling Always On availablity :Couldn't enable the option

Posted: 18 Apr 2013 09:59 PM PDT

Hi,, In sql server 2012 creating a cluster , i had added servers and the next step is Access point for administering the cluster which i need to give the IP address dedicated to the cluster.I don't have a dedicated IP address to assigning to creating cluster. i couldn't pass this step for creating clustering. Kindly help in passing this through.

can we give a copy of a database to someone and it be packaged in such a way so that they cannot see the table structure / design?

Posted: 18 Apr 2013 08:24 PM PDT

can we give a copy of a database to someone and it be packaged in such a way so that they cannot see the table structure / design????????Thanks in advance,suresh.

Linked Server to SQL 2000 from SQL 2012

Posted: 18 Jun 2012 07:29 AM PDT

Hi Guys,I am able to create linked server to SQL 2008 from SQL 2012 and it works fine; however, I am not able to do so with SQL 2000.TITLE: Microsoft SQL Server Management Studio------------------------------The test connection to the linked server failed.------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Cannot create an instance of OLE DB provider "SQLNCLI10" for linked server "TESTSERVER". (Microsoft SQL Server, Error: 7302)------------------------------BUTTONS:OK------------------------------

SSMS error opening maintenance plans

Posted: 18 Apr 2013 03:49 AM PDT

I've applied everything I can find for sql 2012 management tools and mine now show 11.0.3350.0 both on my desktop and on my test server. Getting two types of errors.If I remote onto the sql server, managing maintenance plans works fine. From my desktop I get the Object reference not set to an instance of an object with "vsintegration" mentioned. Must be something about visual studio or other software on my workstation. When opening the sql error log viewer and selecting a Windows NT log like application, I get "the given key was not present in the dictionary"I'm going to uninstall Visual Studio and everything related to sql server 2005, 2008 and 2012 and re-install the 2012 management tools because others here will soon run into these errors.

No comments:

Post a Comment

Search This Blog