Relative Content

Tag Archive for ssis

SSIS Data Flow Task : Event Handler : OnError : Propagete : False – still propagating to parent containers and failing package

I have an SSIS package with a Data Flow Task (Word to DB Data Flow Task) that is inside a sequence container that is inside of several loops. “Word to DB Data Flow Task” can sometimes fail and I want to capture that failure and continue through the parent Container and Loops. I have created an OnError event handler for “Word to DB Data Flow Task” and set it’s Propagation to False.
The parent container still receives the Error which propagates all the way up and fails the package.

SSIS package designed in VS2010 not working in a 2019 SQL Server

I have a SSIS project/packages written in VS2010, that has a number of c# custom script tasks, I tried to deploy to a 2019 SQL Server for the first time but it fails, gives an error message “… Failed to compiled scripts contain in the package. Open the package in SSIS Designer and resolve the compilation errors.” I know this not a new issue just that someone out there might be armed with more knowledge.

SSIS expression: convert date to DDMMYYYY

I’d like some help editing the current date. I need getdate -1 day, but the entry must look like DDMMYYYY.
RIGHT( “00”+ (DT_WSTR, 2) (DAY(GETDATE())-1),2)+RIGHT( “00”+ (DT_WSTR, 2)
MONTH(GETDATE()),2)+(DT_WSTR, 4) YEAR(GETDATE())
Unfortunately, the first day of the month gives the wrong date.
Today is 01/07/2024 and I need the date 30/06/2024(30062024)
Thank you all,

Visual Studio SSIS 2022 – I can no longer see or add/modify Variables in SSIS packages

I’m working with Visual Studio SSIS 2022. Until recently, I was able to view and add/modify user variables in the Variable window. But this morning, I am no longer able to view them or to add new ones. I downloaded the most recent version of SSIS (I think) and installed it but still no luck. Does anyone know what the issue is and how to resolve it?

Return End of String Between 2 Brackets – SSIS Derived Column Expression

The difficulty of extracting the error column name in an SSIS data flow is widely recognized. To meet the requirement of minimizing scripting transforms/components, I cannot use a complex scripting solution to identify error columns in the dataflow. However, by utilizing two lines of C# that are well documented, I can obtain the Error Column description, which is the value shown in the Data Viewer—a string with the column name at the end, such as:

Identifying and Redirecting Duplicate Column Values in SSIS 2019

To be clear this is not a requirement to identify and redirect or dedupe rows in the data flow task leveraging the Sort Transformation. Instead the requirement is to identify duplicate values in a column then redirect those rows. As an example, using the attached table, ProductID 1001 is duplicated therefore rows 3 and 4 should be redirected. Likewise, for column ProductCode, the A01 code is duplicated hence rows 2 and 6 need to be redirected. Any help is appreciated. Thanks!

Older SSIS Project wouldn’t open in Data Tools- Protection Level mismatch

I ran into an ssis work around I thought I’d share. We had an ssis package created in Data Tools 2015, and it was in Prod and running daily and untouched since 2017. We are migrating to SQL Server 2022 plus new servers and while prepping for testing found that this particular ssis project would not open for any reason, giving error: ‘MS Visual Studio 2015 has stopped working’.