![]() If you have any question, feel free to let me know. The best way to find out if it will work is to right click it on your computer and choose to open it in word pad or note pad. Note: any file with csv extension will probably show with an excel icon. In one word, using staging tables when any progress can be more easily, flexible, efficient via the power of SQL Server or any Other databases. The csv file must be text based as in saved as plain text with a csv extension or txt in some cases. There's more power of SQL Server, like a full text search which can be used as an advanced conditional split or lookup and is very difficult to be implemented in SSIS. SELECT ID,(SELECT col1,col2,col3 FROM stageTbl WHERE id=s.id FOR XML PATH('')) do the transformation via the power of T-SQL import the transformated data into destination table import data from scv to staging table in SSIS so at first, you import the data as it is in CSV to a staging table in SQL Server but for me, doing such kind of transformation is more flexible in SQL Server you can surely do the transformation in SSIS Dim readText () As String File.ReadAllLines (path) For I As Integer 0 To readText.Count - 1 Dim Part1 As String readText (I).Substring (0, 16) Dim Part2 As String readText (I).Substring (16) 'Put Part1 and Part2 into their database fields Next I. so you may have to a transform the data before they finally go to the destination table For each line split the text into two strings using substring. May be contrived but it demonstrates when to use it. In SQL Server, a staging table is just a regular SQL server table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |