ssis-data-types
How to achieve similar datatype
Goal: Combine two column named first and lastname, from the same table A and then transfer it to column fullname in ta开发者_开发技巧ble B from a another[详细]
2023-03-31 03:00 分类:问答SSIS 2008: Derived Column Transform a String to a Date Data Type
I had this SSIS package working yesterday and now I\'m getting this error with no changes overnight.[详细]
2023-03-14 16:20 分类:问答SSIS cannot determine the correct datatype of the column
I have a simple SSIS package that picks data from Oracle database and inse开发者_Python百科rts data to sql server. In DataFlow I have 3 tasks:[详细]
2023-03-02 14:20 分类:问答Converting data types in SSIS
I get an input CSV file that I have to upload to my oracle database. Here is some sample data ContractId, Date, HourEnding, ReconciledAmount[详细]
2023-01-21 17:09 分类:问答What variable type use to represent a Money in SSIS
I need to load a Money value in a variable in SSIS using a \"Execute SQL Task\" component. I map the return column of a SELECT to a variable.[详细]
2023-01-21 00:42 分类:问答enforcing data types in SSIS package
I have a SSIS package that imports data from a开发者_开发问答n excel file. One of the columns has mostly numbers (like 12345) but some also have letters (like 123A5)[详细]
2023-01-19 16:32 分类:问答Oracle query as source in SSIS defines wrong data types
I have a somewhat complex query that I want to use as a source in an SSIS package. I create my OLE DB Source, specify the access mode as SQL, and paste my query in the command textbox. When I click Pr[详细]
2022-12-19 01:54 分类:问答