SSIS – Avoid OLE DB Command
I decided to do a little performance testing on some common SSIS “Tricks” that increase speed and effectiveness of SSIS...
2009-11-07
2,765 reads
I decided to do a little performance testing on some common SSIS “Tricks” that increase speed and effectiveness of SSIS...
2009-11-07
2,765 reads
When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult...
2009-10-23
7,086 reads
Today I gave a two part session at SQL Saturday in Orlando. When originally planning this years event Andy Warren said many people who...
2009-10-17
1,323 reads
It’s that time again! SQL Saturday has returned to Orlando with an all star group of speakers http://www.sqlsaturday.com/schedule.aspx. The event...
2009-10-07
742 reads
SQL Server 2008 has a new Change Data Capture feature that allows you to track Inserts, Updates, and Deletes on...
2009-10-05
2,384 reads
The SSIS Package Store is a nice option available for storing SSIS packages. The Package Store lists packages stored on...
2009-09-28
6,341 reads
I recently worked on a project that involved loading a Data Warehouse from a DB2 source. In this project we...
2009-09-23
1,835 reads
Opening DTS packages on a 2008 SQL Server requires several steps to be able to view the packages in a...
2009-08-26
1,582 reads
A very common need in SSIS is to check to see if a file exist before you run what could be...
2009-08-11
15,180 reads
Saturday I had the great opportunity to speak at SQL Saturday in South Florida. The event was great. It was...
2009-08-09
562 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
WhatsApp: 0817839777, Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa Timur...
WhatsApp: 0817839777, Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
WhatsApp: 0817839777, Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers