What is the Difference between Execute TSQL Task and Execute SQL Task?

 In SSIS there is one task Execute TSQL task which is similar to Execute SQL task. We will see what is the difference between the two.

Execute the TSQL Task:  

  • Pros: Takes less memory, faster performance

  • Cons: Output into variable not supported, Only supports ADO.net connection

Execute SQL Task:

  • Pros: Support output into variables and multiple types of connection, parameterized query possible.

  • Cons: Takes more memory, slower performance compared to the TSQL task.

Comments

Post a Comment

Popular posts from this blog

What is Connection Mangers

  Connection as its name suggests is a component to connect to any source or destination from SSIS — like a sql server or flat file or lot of other options that SSIS provides. Connection manager is a logical representation of a connection. Connection Managers are used for gathering data from various sources and sending it to a destination. It facilitates system connection by including information regarding server, data source, authentication details, database, etc.
Read more

What is Transformation? Explain Different Types of Transformations

Image
Data transformation is the process of extracting required data from a data source and is the most critical SSIS step. Post extraction, the process aids in managing and transferring the data to a specific file destination. There are several rules implemented by this process for loading the extracted data to the destination target file. Based on this, the transformations are classified as: Blocked Non Blocked Semi Blocked Non-Blocking  –  No blocking Partial Blocking  –  The downstream transformations wait for certain periods, it follows start then stop and start over technique Full Blocking :  The downstream has to be waiting till the data has been released from the upstream transformation. Non- blocking transformations Audit Cache Transform Character Map Conditional Split Copy Column Data Conversion Derived Column Export Column Import Column Lookup Multicast OLE DB Command Percentage Sampling Script Component Slowly Changing Dimension Partial blocking transforma...
Read more