Tags » SSIS

SSIS Performance Tuning Webinar–Q & A

Thank you everyone for attending my webinar on SSIS Performance Tuning, if you missed that presentation you can watch it here: http://pragmaticworks.com/LearningCenter/FreeTrainingWebinars/PastWebinars.aspx?ResourceId=683

Below are some of the questions that I received from the Webinar: 392 more words


When and how to use the aggregate transformation in SSIS

Aggregate transformation allows to aggregate the data from the data source pushed in the SSIS. It can be used in scenarios where we have to group, sum or count the data, for example aggregate transformation can be used to sum the total monthly sales made by employees.  200 more words

SQL Server

SSIS 2012 – Package Configurations Menu Option Missing

I am posting this because I came across the same thing. As the original author states – maybe it will be useful for someone else. 8 more words

SSIS: Zipping files with WinRAR

One of the strengths of SSIS (SQL Server Integration Services), is that’s it’s really powerful with the components available. But it’s easy to use the “Execute Process Task” to execute external tools. 534 more words


ISPACs - Got To Love Em

Being a DBA and working with various teams, I have become accustomed to deploying SSIS packages. I’ll even go back further and, dare I say, DTS packages (I hope everyone did not just fall on the floor while reading that). 497 more words

SQL Server

How to solve a a tricky SSIS Problem with the TF Surrogate Key transform!

Recently I was able to solve a really tricky problem in SSIS using the TF Surrogate key transform. Let’s discuss the business problem:

The client was using some complicated .net code to loop through each line in a file and look for a very specific string of code. 295 more words


Text file data type mismatch between source file and target

SSIS package “Source_To_Stgaing.dtsx” starting.
Information: 0x4004300A at DF TEXT File, SSIS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at DF TEXT File, SSIS.Pipeline: Validation phase is beginning. 451 more words