Sladescross's Blog

Blogging about Sharepoint related stuff

SSIS Container Hierarchy April 17, 2014

Filed under: Container,Container Hierarchy,Hierarchy,SSIS — sladescross @ 1:33 pm

http://consultingblogs.emc.com/jamiethomson/archive/2004/12/13/445.aspx

 

SUS and Data Feeds April 16, 2014

Filed under: Data Feeds,NHS,SUS — sladescross @ 3:59 pm

http://www.hscic.gov.uk/susguidance#cmsanchorhow_do_I_extract_data_from_SUS

 

OnPipelineRowsSent April 15, 2014

Filed under: Pipeline,Rows,SSIS — sladescross @ 4:29 pm

http://consultingblogs.emc.com/jamiethomson/archive/2007/03/08/SSIS_3A00_-OnPipelineRowsSent.aspx

 

Analysis Services – Vision & Roadmap Update – Analysis Services and PowerPivot Team Blog – Site Home – MSDN Blogs

Filed under: BI,Roadmap — sladescross @ 7:49 am

http://blogs.msdn.com/b/analysisservices/archive/2011/05/16/analysis-services-vision-amp-roadmap-update.aspx

 

SYSSSISLOG Squeeze the Asset for Reporting April 9, 2014

Filed under: Logging,SSRS,SYSSSISLOG — sladescross @ 4:08 pm

http://troywitthoeft.com/simple-ssis-package-monitoring-for-sql-server-2008/#more-790

http://troywitthoeft.com/simple-ssis-package-monitoring-for-sql-server-2008/

http://blogs.msdn.com/b/mattm/archive/2008/06/23/reporting-on-execution-logs-using-reporting-services.aspx

http://www.sqlservercentral.com/blogs/toddmcdermid/2011/04/26/transforming-ssis_2700_-sysssislog-entries-into-something-more-readable/

 

Unused and Missing Indexes DMV April 1, 2014

Filed under: DMV,Index,Missing,Optimisation,Performance,Unused — sladescross @ 4:51 pm

http://geekswithblogs.net/Vipin/archive/2013/02/28/dmv-to-figure-out-unused-and-missing-indexes-on-table.aspx

 

SQL Client and SQL Client Native

Filed under: ADO,Connection String,ODBC,Provider,SQL Client,SQL Native Client — sladescross @ 10:55 am

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c5d4fe15-cab3-4e4e-ae59-101cf1c4c755/sql-native-client-vs-net-sqlclient?forum=sqldataaccess

SQL Native client surfaces OLE DB and ODBC providers for SQL Server
SQLClient surfaces an ADO provider for SQL Server.

http://www.aspfree.com/c/a/Database/Using-ADO-with-the-SQL-Native-Client/

SQL Native Client is a new data access method from Microsoft. It boasts its own dynamic link library. This extends the capabilities of ADO on the SQL Server. This article explores two aspects of this method.

First, the methods of connection and command objects when the ADO accesses the database with the SQL Native Client provider are described with an example.

Provider=SQLNCLI.1;Integrated Security=SSPI; Persist Security Info=False;
Initial Catalog=Northwind; Data Source=Hodentekmysorian;
Use Procedure for Prepare=1;Auto Translate=True; Packet

http://www.c-sharpcorner.com/uploadfile/nipuntomar/connection-strings-for-sql-server-2008/

The .NET Data Provider for ODBC access to data sources that are connected to using an ODBC driver.

The ODBC .NET Data Provider is an add-on component to the .NET Framework. It provides access to native ODBC drivers the same way that the OLE DB .NET Data Provider provides access to native OLE DB Providers A .NET Framework data provider also serves as a bridge between a data source and an ADO.NET DataSet. For data sources exposed by using ODBC. Uses the System.Data.Odbc namespace.

Sample Code

using System.Data.Odbc;
OdbcConnection myConnection = new OdbcConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
//execute queries, etc
myConnection.Close();

Bridging to SQL Native Client 10.0 ODBC Driver

Syntax:

Driver={SQL Server Native Client 10.0};Server=urServerAddress;Database=urDataBase;
Uid=urUsername;Pwd=urPassword;

http://www.codeproject.com/Articles/2304/ADO-Connection-Strings#ODBC DSN

strConnect = _T(“DSN=MyDSN;Uid=MyUsername;Pwd=MyPassword;”);

 

 
Follow

Get every new post delivered to your Inbox.

Join 63 other followers