Reputation: 308
SSIS how to find correct data types?
Background: This is my day 1 of learning ETL. Had a little computer science training (not very systematically) before.
So I was learning this SSIS Tutorial on msdn (https://msdn.microsoft.com/en-us/library/ms170583.aspx?f=255&MSPPError=-2147217396), one of the steps is to remap column data types from a flat file.
I never ran into this kind of data types (I mean those [DT_WSTR] thing) before. My question is how do I find the correct data type in Flat File Connection Manager Editor for my destination column? A complete list of reference of datatypes would be perfect. Thanks everyone!
Upvotes: 0
Views: 1383
Answers (1)
Reputation: 61259
It's actually a rather complex beast. Despite SO best practice of not linking to external resources, I'm going to disregard it here
- http://www.cathrinewilhelmsen.net/2014/05/27/sql-server-ssis-and-biml-data-types/
- http://milambda.blogspot.com/2014/02/sql-server-integration-services-data.html
- http://www.sqlservercentral.com/blogs/dknight/2010/12/22/ssis-to-sql-server-data-type-translations/
- https://msdn.microsoft.com/en-us/library/ms187752.aspx
- https://msdn.microsoft.com/en-us/library/ms141036.aspx
Upvotes: 1
Related Questions
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to add a column with a default value to an existing table in SQL Server?
- Find all tables containing column with specified name
- How do I UPDATE from a SELECT in SQL Server?
- How to check if a column exists in a SQL Server table
- How do I perform an IF...THEN in an SQL SELECT?
- How can I delete using INNER JOIN with SQL Server?
- Why is this SSIS package throwing conversion errors?
- SSIS flat file with string larger than 50