Posts by Tiago Meireles • 41 points
5 posts
-
0
votes1
answer34
viewsA: Taking month and year
Get it with a case, the case in SSIS Express is like this: https://docs.microsoft.com/en-us/sql/integration-services/expressions/conditional-ssis-expression?view=sql-server-2017…
-
0
votes1
answer262
viewsA: I cannot assign return of the expression in the SSIS variable
The variable you are using for mapping is not the same as the one leaving the Result Set. By the way, when you use a variable that is mapped, you do not need to put its name, just put in the query a…
-
0
votes2
answers462
viewsA: Copy excel extension files from various subdirectories with ssis
You don’t need a script, you can just use the properties of the Container Foreach Loop, which lets you search all the files in a directory or sub-directory and extension you want. Maps the result…
-
0
votes1
answer399
viewsA: Import SSIS file with columns at different positions each day
If column order changes, SSIS maintains the structure of the information associated with that column. Check in the advanced Flat File Source options Example Day 01: Col1, Col2, Col3 A B C AA BB CC…
-
4
votes3
answers97
viewsA: Relationship between the tables
There is no COD_PRODUTO in table TB_ESTOQUE according to your example. Try: SELECT E.PRODUTO, P.DESC_PRODUTO, E.QT_DISPONIVEL, E.COD_FILIAL FROM TB_ESTOQUE E, TB_FILIAL F LEFT JOIN TB_PRODUTO P ON…