Questions tagged [ssis-expressions]
The ssis-expressions tag has no usage guidance.
15
questions
6
votes
3
answers
2k
views
SSIS 2012 VS_ISBROKEN on Derived Column
I have converted a SSIS package built in VS2008 to open in VS2010.
I have a Derived Column component that fails validation. It works fine in VS2008.
Here is the Expression used in Derived Column...
...
- 1,394
4
votes
1
answer
15k
views
How do I map SSIS 2012 Package Variables to Parameters?
I have created multiple packages that use variables to assign Connection Manager Expressions such as Connection String. However in the new SQL 2012 Project Deployment Model I don't seem to be able to ...
- 167
3
votes
1
answer
6k
views
ssis convert ddmonyyyy dd/mm/yyyy
Hi guys trying to convert
16JAN2014 --> 16/01/2014. Any ideas??? i'm trying to avoid the horrendous expression of ? JAN : 1 ? FEB : 2 etc. etc.
SSMS will quite happily do SELECT MONTH('16JAN2014') ...
- 281
2
votes
1
answer
1k
views
convert string allow null col to int?
I want to convert string to int my string type [DT_WSTR] and my expression
ISNULL(col) || TRIM(col) == "" ? (DT_I4)0 : (DT_I4)col
I get this error
[Derived Column [518]] Error: The conditional ...
- 245
2
votes
1
answer
6k
views
SSIS Event Handler at Package Level
I have a fairly simple SSIS package (handful of Execute Task and a few Data Flow task). The end result I am looking to have:
I would like to get notified by email when an error occurs anywhere
in the ...
user507
1
vote
1
answer
20k
views
SSIS Derived Column Casting to DT_STR
Why can't I get this to cast as a DT_STR - the data source is WSTR, but shouldn't this cast make the output DT_STR?
(IPUNSPSC) =="**no_UNSPSC_available**" ? (DT_STR,20,1252)NULL(DT_STR,20,1252) : (...
1
vote
1
answer
5k
views
SSIS: Get Date for Day of the Week
In SSIS, how do I get the date for a specific day of the week? For example, how do I get last Sunday's date?
I assume I have to do some subtraction on the day-of-week, but not sure:
DATEADD("d", -...
- 167
1
vote
0
answers
332
views
flat file datetime issue
I have a flat file with this datetime format 5/24/2017 05:12:44.243 PM. I have been struggling to convert this format to something like this 2017-05-24 17:12:44.243. I tried using this derived column ...
- 61
0
votes
1
answer
3k
views
Looking for solution to add double quotes in field which has commas in SSIS
I have a field called something like TYPE & the values are variant in it. I want the SSIS to export the result to CSV & while exporting, if it finds the , in column TYPE only that line/value ...
- 1
0
votes
1
answer
4k
views
SSIS - Disable Task Based on Variable Value
I have an SSIS package that runs a number of Data Flow Tasks all at the same time.
Each Data Flow Task is placed inside a Sequence Container.
Before the Data Flow Tasks are run, a Script Task is ...
- 523
0
votes
1
answer
175
views
How to create Destination table name with Getdate in SSIS OLEDB destination
How to create Destination table name with Getdate in ssis destination task.
I have one table like Test..but i want to create new table like Test_09Feb2023 in OLEDB destination.
0
votes
0
answers
315
views
SSIS Dynamically Loop through SQL Tables
I have been fighting with an SSIS package for sometime now.
I did successfully build a package that will extract data from a specific table by creating a date list from a script task, use a ...
- 427
0
votes
1
answer
126
views
Logging the conditions within a conditional split transformation (SSIS in SQL Server 2012 and 2016)
I'm struggling to find out how we can store the conditions inside a conditional split transformation when we run a package. I need a snapshot of the expressions (the whole expressions, not only ...
- 1
-1
votes
1
answer
1k
views
How to format SSIS Expression for weekend
I have the following format to account for weekends while naming an excel output. How do I get only the date and not the full startime formatted like 20150429?
((DT_I4)DATEPART("weekday",@[System::...
- 123
-2
votes
1
answer
737
views
How to convert default Date format from MM/DD/YY to YYYY/MM/DD HH:MM:SS in SSIS packages?
I don't know what to write in Derived column expression.
Steps-
1.Source - Excel file
2.Derived column
3.Destination - OLE DB Destination
