James Shropshire

This post is for those of you who need a quick answer to this issue and you’ve already restarted the DTC service and the SQL Server service in that order. Before you start pulling your hair out and running to DTCPing or DTCTest, if it’s ok with all parties involved, try restarting the DTC service [...]

In this quick presentation I’ll demonstrate how you can use a SSIS package in SQL Server 2008 to loop through multiple files of a certain type in order to load data into your database. Thanks, James Shropshire MCDBA, MCITP SQL Server

In order to resolve this issue use the following steps: Ad hoc access to OLE DB provider ‘Microsoft.ACE.OLEDB.12.0′ has been denied. You must access this provider through a linked server. Run the Following T-SQL USE [master] GO EXEC master . dbo. sp_MSset_oledb_prop N’Microsoft.ACE.OLEDB.12.0′ , N’AllowInProcess’ , 1 GO EXEC master . dbo. sp_MSset_oledb_prop N’Microsoft.ACE.OLEDB.12.0′ , [...]

Here is a way to create an SSIS that audits the transfer of data each step of the way. The main transformations used for this are: Row Count The row count was used to validate the number of records Conditional Split Was used to split out rows with a specific Header value. In this case [...]

As a DBA who services numerous customers and clients, an issue that crops up relatively often is the need for more disk space. As an organization you do have options: Trim your data Buy new disks Truncate your data (Yeah right!!) For most organizations these are truly not options at all. With the release of [...]