SSIS Configurations – Deep Dive Session

Hello everyone, Here are the slides of my session of “SSIS Configurations – Deep Dive” – @ Microsoft SQL User Group, Singapore Thank you very much for all your support ūüôā My apologies for machine issues and I could not show you demo. I will talk to team and ask for 20 minutes to show …

Continue reading ‘SSIS Configurations – Deep Dive Session’ »

The Story of Precision, Scale, and Length in SQL Server

Hi guys, Did you ever faced issues with BIG mathematical figures – related to either overflow or any¬† other arithmetic errors. This may be applicable to SQL arithmetic operations or arithmetic¬† operations you do with SQL table in SSIS etc. Well, check 1 more time, if you have any issues in your database design related …

Continue reading ‘The Story of Precision, Scale, and Length in SQL Server’ »

Tracking Down Ghost Characters: WHERE Clause Does Not Work Properly In T-SQL Query

Hi guys, I would like to share an experience with you when I was working on 1 SSIS related issue. Scenario was: I have to exclude some records from Table A by matching some keys of Table B. ¬†Table A Year Month CustomerCode <Extra Columns> 2012 JAN CX1000 ¬† 2012 JAN CX2000 ¬† 2012 JAN …

Continue reading ‘Tracking Down Ghost Characters: WHERE Clause Does Not Work Properly In T-SQL Query’ »

MSSQL: Find total records of each Table in given Database

hi guys, i wanted to do a quick post on how you can find total number of records in each table of the database. here is the script you can use: USE <Your Database Name> GO ;WITH CTE_DATABASETABLESIZE (DATABASENAME, SCHEMANAME, TABLENAME, TOTALROWS) AS ( SELECT ¬†DB_NAME(), SCHEMA_NAME(SO.UID), SO.NAME, SI.ROWS FROM ¬†SYSOBJECTS SO ¬†INNER JOIN SYSINDEXES …

Continue reading ‘MSSQL: Find total records of each Table in given Database’ »

SQL Server User Group Event on 4th Oct 2012, Singapore

Hello friends, how are you doing? There is an event (SQL User Group, Singapore) on 4th October 2012. Following is the detail about the event. Send an email to “Chen Liang <liangchen@dataraid.info>” with your name, working place and contact number for reservation of your seat. There is no charge for all members of SQL Server …

Continue reading ‘SQL Server User Group Event on 4th Oct 2012, Singapore’ »

E-Book Gallery for Microsoft Technologies

Hi guys, good morning !!! here is the list of cool FREE E-Books from Microsoft Press. Rate this post

Check if file exists: using SSIS

Hi All, Many times, we have to do this simple checking “if file exists/available .. then proceed” in SSIS operations. And Microsoft did not put any facilities to achieve this task in SSIS with default components. People also have raised this concern to Microsoft, but Microsoft explains that they have more priority works to deal …

Continue reading ‘Check if file exists: using SSIS’ »

Important Fact: Default Logging in SSIS which store log entries in SQL Server

Hi all, Few days back I have posted an article on “Default Logging in SSIS“. You can refer that here. In that article I have forgotten to mention a behavior of “enabling a default logging in SSIS package“. Let me show you what you need to know about this fact. Fact: When you enable a …

Continue reading ‘Important Fact: Default Logging in SSIS which store log entries in SQL Server’ »

Customizing the Default Logging in SSIS

Hi Guys, Sometimes definitions are wacky. I thought of writing this article on default logging where I could modify it with my application requirements. And guess what… “Customization with default logging” title rendered in mind. Just for fun if you think about it, when you customize the default logging; it would be custom logging. But …

Continue reading ‘Customizing the Default Logging in SSIS’ »

Configuring “Merge Join” Task in SSIS

Hi All, Today I would like to tell you the required settings to be done for using Merge Join in SSIS. Merging the data from 2 different sources can be implemented in various ways. And that depends on many things like both sources are on same SQL server or on different SQL servers but available …

Continue reading ‘Configuring “Merge Join” Task in SSIS’ »