Hi Phil, it's always something special if you present a solution. Thank you, for your awsome script! 🙂

Hi Jeff,

the Script for the Staging-Table below. All Cleansing-Activitys are done in the cleansing area. No Cleansing, Check Constraints, PK, FK, Index ...in Stage. Technical Columns startswith("tc").

Regards Nicole

CREATE TABLE [sap].[Orders](

[id]...

• This reply was modified 4 years, 9 months ago by  info 58414.

Hi Jeff,

1. How many "records" does each file have. An average will be fine.

=> about 2000 per File

2. You said previously that all of the files are formatted the same....

• This reply was modified 4 years, 9 months ago by  info 58414.

%

• This reply was modified 4 years, 9 months ago by  info 58414.

Hi,

thank you for this Informations!

At night, the flat files from around 500 customers arrive on an FTP - Step by Step. The SSIS job currently starts at 08:00 AM and...

as Table with separate Col.

Great Mark! Only view Lines for this big Result 😉
do you still have a tip for me, how do I bring the result in a flat display (horizontal)?
Regards...

Hi, here is the Execution-Plan.
Thanks

Hi, here is the Execution-Plan.
Thanks

Hi Phil,
thanks for yout Posting. My Problem is not the OLTP Source-System, and not the DWH-DB. My Problem is the DataMart during the ETL-Load from DWH.
Regards Nicole
😉

yes, when i restart SSMS -> the Problem is fixed.

should I start SSMS after VS ?

Thanks 🙂

Hi,

we have the following Problem.
ORA -OLEDB-Connector ist actual only released in 64-bit.
32-bit will released in then next few Weeks.
We need to test the...

Great ! this helps .. Thank you

No, all Columns have the same Pattern:

Example: INC000001234567

* Len (15) = char (15)

* Starts with "INC"

* After INC following 12 num digits

Yes, the Column-Value has the same Pattern,

No, the Column Datatype can be diffrent