search

assasafras / git_tutorial

Tutorial
0 stars 0 forks source link

Job Failed: Collections - Monthly 1st (530am) | Step 4 | Email_CollectionsLegalLettersAbove90dExtract #27

Closed assasafras closed 8 years ago

assasafras commented 8 years ago

Message

Executed as user: FLEXIRENT\syssqlint02. Microsoft (R) SQL Server Execute Package Utility Version 10.0.6000.29 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:51:26 p.m. Error: 2016-10-04 22:51:27.82 Code: 0xC020200E Source: Data Flow Task Flat File Destination [49] Description: Cannot open the datafile "\DEVAKL016V\CollectionsData\LegalLettersExtract\LegalLettersExtract_NZContracts90DaysAbove.csv". End Error Error: 2016-10-04 22:51:27.82 Code: 0xC004701A Source: Data Flow Task SSIS.Pipeline Description: component "Flat File Destination" (49) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:51:26 p.m. Finished: 10:51:28 p.m. Elapsed: 1.982 seconds. The package execution failed. The step failed.

assasafras commented 8 years ago

Issue

COnnection String of the Flat file connection manager was not an expression, thus global config was not altering the string.

Solution

Added expression of @[User::_fullFilePath] for ConnectionString property.

assasafras commented 8 years ago

Working in UAT