sql-serverssisssis-data-types
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!
Solution
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
- Providing string variable into Dynamic SQL SELECT statement WITHOUT it being read as a column name?
- How to store geocoded address information into the database
- Truncate a DDL or DML command
- How can I find out what FOREIGN KEY constraint references a table in SQL Server?
- Why ISDATE() is returning 9996 as date?
- .NET 8 & SQL Server 2016 - Contains() throws error
- IsDate Function in SQL evaluates invalid dates as valid
- SQL Server - Value passes ISDATE() but fails to CAST as DATE or DATETIME
- Error when connecting to SQL Server in deno: 'cannot find module crypto'
- Multiple many-to-many and multiple one-to-one relationships in the same entities
- SQL Server DATEDIFF round up the YEAR difference. How to round it down?
- Path table to HTML treeview in SQL Server
- SUM and Decimal precision
- Parse TEXT datatype column to grab values based on TAGS
- How can I create a tar file in memory from several varbinary(max) columns stored in SQL Server using .NET native API?
- collation conflict between "Hebrew_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"
- Maintaining property order with get-member
- migrate data from MS SQL to PostgreSQL?
- Add multiple conditional values to one column
- Read Committed vs Read Uncommitted if both transactions do not rollback
- SQL YEAR(GETDATE())
- VIEW with NOLOCK but called without NOLOCK
- SQL Merge WHEN NOT MATCHED BY SOURCE THEN on filtered source and targed tables
- SQL obtain timestamps for end datetime row 1 and start timestamp row 2
- Tricky SQL update
- Remove Identity from a column in a table
- Return 1 if value is 0 without CASE statement
- Append string text based on pattern search SQL
- How to find Cyrillic font (russian characters)?
- Query Azure SQL Database using Rest-API