Styjun

1mth baby boy keeps peeing through diapers, sometimes diper seems practically unused

What if an AES GCM nonce overflows and collides with the GHASH nonce (0^128)?

Count the number of shortest paths to n

How to actually concatenate two Strings?

Discussing work with supervisor in an invited dinner with his family

Weird corners with cline

Open subspaces of CW complexes

When was the tzitz lost?

How were medieval castles built in swamps or marshes without draining them?

What stops you from using fixed income in developing countries?

Why does Windows store Wi-Fi passwords in a reversible format?

Set orthographic view using python?

Hangman game in Python - need feedback on the quality of code

Unlock your Lock

Disk usage of integer column vs boolean column in Postgres

Reusing studs to hang shoe bins

Why all theories are Lorentz invariant?

Did Dr. Hannibal Lecter like Clarice or was he attracted to her?

What is Soda Fountain Etiquette?

Shift lens vs move body?

Is it ok to record the 'environment' around my workplace?

Cooking Scrambled Eggs

What are the IPSE’s, the ASPE’s, the FRIPSE’s and the GRIPSE’s?

How much does Commander Data weigh?

Change data types from Advanced Editor vs Data Conversion Transformation

SSIS 2008: Derived Column Transform a String to a Date Data TypeSSIS - Advanced Editor for ODBC Source - Input and Output properties does not save settingsSSIS Flat File Source Advanced Editor, Is there a way to change all data types at once?SSIS - Data Conversion from DT_STR to intHow to set properties from Advanced Editor such as FastParse using BIMLTimestamp to Bigint (MSSQL) vs. DT_BYTES to DT_I8 (SSIS)SSIS Data Conversion Error despite using Data Conversion and accurate destination DatatypeHow to convert a string to money in the Data Conversion Transformation process in SSIS?SSIS Lookup Transformation Data Type issueWhy Data Type DT_NTEXT from SQL Command OLE DB Source?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

2

1

I am using SSIS to create some packages. I have gotten confused around the Data Conversion Transformation component and changing columns data types from Advanced editor

If I can go into the advanced editor and change the data type of my output, why would I need to input the Data Conversion Transformation?

Is this just down to preference or is there a difference between using both approaches?

sql-server ssis etl sql-server-data-tools ssis-data-types

share|improve this question

edited Mar 27 at 19:56

Hadi

28.5k88 gold badges3434 silver badges8080 bronze badges

asked Mar 26 at 16:50

leTurnerleTurner

5277 bronze badges

add a comment | 

2

1

I am using SSIS to create some packages. I have gotten confused around the Data Conversion Transformation component and changing columns data types from Advanced editor

If I can go into the advanced editor and change the data type of my output, why would I need to input the Data Conversion Transformation?

Is this just down to preference or is there a difference between using both approaches?

sql-server ssis etl sql-server-data-tools ssis-data-types

share|improve this question

edited Mar 27 at 19:56

Hadi

28.5k88 gold badges3434 silver badges8080 bronze badges

asked Mar 26 at 16:50

leTurnerleTurner

5277 bronze badges

add a comment | 

I am using SSIS to create some packages. I have gotten confused around the Data Conversion Transformation component and changing columns data types from Advanced editor

If I can go into the advanced editor and change the data type of my output, why would I need to input the Data Conversion Transformation?

Is this just down to preference or is there a difference between using both approaches?

sql-server ssis etl sql-server-data-tools ssis-data-types

share|improve this question

edited Mar 27 at 19:56

Hadi

28.5k88 gold badges3434 silver badges8080 bronze badges

asked Mar 26 at 16:50

leTurnerleTurner

5277 bronze badges

sql-server ssis etl sql-server-data-tools ssis-data-types

sql-server ssis etl sql-server-data-tools ssis-data-types

share|improve this question

edited Mar 27 at 19:56

Hadi

28.5k88 gold badges3434 silver badges8080 bronze badges

asked Mar 26 at 16:50

leTurnerleTurner

5277 bronze badges

share|improve this question

edited Mar 27 at 19:56

Hadi

28.5k88 gold badges3434 silver badges8080 bronze badges

asked Mar 26 at 16:50

leTurnerleTurner

5277 bronze badges

edited Mar 27 at 19:56

Hadi

28.5k88 gold badges3434 silver badges8080 bronze badges

edited Mar 27 at 19:56

Hadi

28.5k88 gold badges3434 silver badges8080 bronze badges

asked Mar 26 at 16:50

leTurnerleTurner

5277 bronze badges

asked Mar 26 at 16:50

leTurnerleTurner

5277 bronze badges

1 Answer
1

active

oldest

votes

3

Before showing the difference between both approaches, i will try to give an overview of the data conversion types.

Implicit vs Explicit conversion

There are 2 different type of data type conversion:

• Implicit conversion: Implicit conversions are not visible to the user. SQL Server automatically converts the data from one data type to another. For example, when a smallint is compared to an int, the smallint is implicitly converted to int before the comparison proceeds.


• Explicit conversion: Explicit conversions use the CAST or CONVERT functions or other tools.

From the following Microsoft Grid you can see what data types can be converted with each approach:

If you need to know what are the SSIS data types relevant to the data types of SQL Server database engine (mentioned in the Grid above), then you can refer to the following documentation:

• Integration Services Data Types

---

Advanced Editor vs Data Conversion Transformation

• When changing data types from the Advanced editor you are performing implicit data types conversion since the Source/Destination Component try to convert automatically the data type of the column.


• Using Data Conversion Transformation you are performing explicit conversion. Since it is mentioned on the article above that:

Use the Data Conversion transformation to cast the data type of a column from one data type to a different data type

---

References

• Data type conversion (Database Engine)


• Data Conversion Transformation


• Working with SSIS Data Types

share|improve this answer

edited Mar 26 at 19:56

answered Mar 26 at 18:42

HadiHadi

28.5k88 gold badges3434 silver badges8080 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Thanks! Really useful information!
  
  – leTurner
  Mar 27 at 8:44
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55362367%2fchange-data-types-from-advanced-editor-vs-data-conversion-transformation%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

3

Before showing the difference between both approaches, i will try to give an overview of the data conversion types.

Implicit vs Explicit conversion

There are 2 different type of data type conversion:

• Implicit conversion: Implicit conversions are not visible to the user. SQL Server automatically converts the data from one data type to another. For example, when a smallint is compared to an int, the smallint is implicitly converted to int before the comparison proceeds.


• Explicit conversion: Explicit conversions use the CAST or CONVERT functions or other tools.

From the following Microsoft Grid you can see what data types can be converted with each approach:

If you need to know what are the SSIS data types relevant to the data types of SQL Server database engine (mentioned in the Grid above), then you can refer to the following documentation:

• Integration Services Data Types

---

Advanced Editor vs Data Conversion Transformation

• When changing data types from the Advanced editor you are performing implicit data types conversion since the Source/Destination Component try to convert automatically the data type of the column.


• Using Data Conversion Transformation you are performing explicit conversion. Since it is mentioned on the article above that:

Use the Data Conversion transformation to cast the data type of a column from one data type to a different data type

---

References

• Data type conversion (Database Engine)


• Data Conversion Transformation


• Working with SSIS Data Types

share|improve this answer

edited Mar 26 at 19:56

answered Mar 26 at 18:42

HadiHadi

28.5k88 gold badges3434 silver badges8080 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Thanks! Really useful information!
  
  – leTurner
  Mar 27 at 8:44
  

  
  
  
  

add a comment | 

3

Before showing the difference between both approaches, i will try to give an overview of the data conversion types.

Implicit vs Explicit conversion

There are 2 different type of data type conversion:

• Implicit conversion: Implicit conversions are not visible to the user. SQL Server automatically converts the data from one data type to another. For example, when a smallint is compared to an int, the smallint is implicitly converted to int before the comparison proceeds.


• Explicit conversion: Explicit conversions use the CAST or CONVERT functions or other tools.

From the following Microsoft Grid you can see what data types can be converted with each approach:

If you need to know what are the SSIS data types relevant to the data types of SQL Server database engine (mentioned in the Grid above), then you can refer to the following documentation:

• Integration Services Data Types

---

Advanced Editor vs Data Conversion Transformation

• When changing data types from the Advanced editor you are performing implicit data types conversion since the Source/Destination Component try to convert automatically the data type of the column.


• Using Data Conversion Transformation you are performing explicit conversion. Since it is mentioned on the article above that:

Use the Data Conversion transformation to cast the data type of a column from one data type to a different data type

---

References

• Data type conversion (Database Engine)


• Data Conversion Transformation


• Working with SSIS Data Types

share|improve this answer

edited Mar 26 at 19:56

answered Mar 26 at 18:42

HadiHadi

28.5k88 gold badges3434 silver badges8080 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Thanks! Really useful information!
  
  – leTurner
  Mar 27 at 8:44
  

  
  
  
  

add a comment | 

Before showing the difference between both approaches, i will try to give an overview of the data conversion types.

Implicit vs Explicit conversion

There are 2 different type of data type conversion:

• Implicit conversion: Implicit conversions are not visible to the user. SQL Server automatically converts the data from one data type to another. For example, when a smallint is compared to an int, the smallint is implicitly converted to int before the comparison proceeds.


• Explicit conversion: Explicit conversions use the CAST or CONVERT functions or other tools.

From the following Microsoft Grid you can see what data types can be converted with each approach:

If you need to know what are the SSIS data types relevant to the data types of SQL Server database engine (mentioned in the Grid above), then you can refer to the following documentation:

• Integration Services Data Types

---

Advanced Editor vs Data Conversion Transformation

• When changing data types from the Advanced editor you are performing implicit data types conversion since the Source/Destination Component try to convert automatically the data type of the column.


• Using Data Conversion Transformation you are performing explicit conversion. Since it is mentioned on the article above that:

Use the Data Conversion transformation to cast the data type of a column from one data type to a different data type

---

References

• Data type conversion (Database Engine)


• Data Conversion Transformation


• Working with SSIS Data Types

share|improve this answer

edited Mar 26 at 19:56

answered Mar 26 at 18:42

HadiHadi

28.5k88 gold badges3434 silver badges8080 bronze badges

share|improve this answer

edited Mar 26 at 19:56

answered Mar 26 at 18:42

HadiHadi

28.5k88 gold badges3434 silver badges8080 bronze badges

answered Mar 26 at 18:42

HadiHadi

28.5k88 gold badges3434 silver badges8080 bronze badges

answered Mar 26 at 18:42

HadiHadi

28.5k88 gold badges3434 silver badges8080 bronze badges