Installing OLE DB Driver for SQL Server - OLE DB Driver for SQL Server | Microsoft Docs

https://docs.microsoft.com/en-us/sql/connect/oledb/applications/installing-oledb-driver-for-sql-server?view=sql-server-ver15

• This reply was modified 3 years, 6 months ago by  Bojidar Alexandrov.
• This reply was modified 3 years, 6 months ago by  Bojidar Alexandrov.

Hi this site is nice to build and explain RegEx expressions

See your first one. It allows 0-3 spaces from the start of the string and then captures 4 digits.

• This reply was modified 4 years, 2 months ago by  Bojidar Alexandrov.

Just shoot in the dark - check that you have read permissions on the drive and parent folders...

You have to set low (say 10000) Rows per batch and Maximum insert commit size on the OLE DB Destination.

I've used it for parsing few similar but with own specifics fixed length text files.

There was a header with important note and summary fields that needed checking against...

This file is on a shared folder. I think this is not a problem of SSIS but some other thing. Probably you have changed Windows version, some different configuration, domain...

Thank you, but late for me 🙂 I've just lost a day trying to fight that. Why MS are still keeping this broken release online... I've reverted to uploading the...

Nice exercise but you still have an unique index on EmailAddress so why not instead of the two indexes, make one unique over EmailCheckSum and EmailAddress and miss all the...

Actually we use log shipping for establishing a reporting database but there is an issue that we need one reporting base updated once a day and another one hourly. The...

Thanks for your opinion, Sergiy it is valid but I want to clarify the situation. It is web based application with separate database, application server and web server. Indeed I...

Thanks, Jacobs, Sergiy and others in this nice discussion.

The sollution with triggers was indeed over my head, despite the fact that I have created views with instead of triggers...

Good article, little bit simple and short but its a refresher anyway

Better way is:

SELECT *

FROM t1 a

LEFT JOIN t2 b ON a.f1=b.f1

WHERE b.f1 IS NULL