SSIS and Sql Server Journey

Personal Notes of Sarabjit Singh and Bhavpreet Singh

Encryption\Decription in Sql Server 2005

  • ENCRYPTION by passphrase
  • ENCRYPTION by symmetric keys
  • ENCRYPTION by Asymmetric keys
  • ENCRYPTION by certificates

Leave a comment »

Must Read: Full Text Catalog, Full Text Index, Noise Words or Stop Words


Leave a comment »

Set showplan_text No: To view the execution plan in text format

For further drill down:

Leave a comment »

Leave a comment »


Leave a comment »

SSIS: Awesome post by Matt Masson

Leave a comment »

SSIS: Remove duplicate rows from input file

We have an requirement in which there are 40,000,000 (forty million) records in the Input file. We have to load it into the databases after implementing a few business logic transformations. Major part of concern is to remove duplicate rows. Following are the possible solutions.

1. Use Sort task and set “remove duplicate” property to TRUE. Would take quite long as it is a full blocking transaction.Β 

2. Use Script component. Need to compare. I guess it would again be a full blocking transformation.Β 

3.Dump data to DB and then reload after selecting distinct records. Looks like the best option.Β 

Will be back with the stats. Feel free to add your suggestions/stats/comments.

Happy SSISing.. πŸ™‚

1 Comment »

Pinal Dave Fix:SQL SERVER – Fix – Error: 1060 The number of rows provided for a TOP or FETCH clauses row count parameter must be an integer

Leave a comment »


Zaim Raza on MS BI

If you’re curious, you can rename the .ispac file and give it a .zip extension, and extract. Voila, we see all the files that make up the ispac – a manifest, your DTSX files, and a .param file. Also note that the manifest does not have the usual long .ssisDeploymentManifest extension.


View original post

Leave a comment »

SSIS Naming Conventions and Best Practices

Leave a comment »