hmm.. for some reason it says that the last post by me but I can't see it

UPDATE: weird.. I could see only 3 pages and once I posted this message,...

• This reply was modified 2 years, 10 months ago by  masterelaichi.
• This reply was modified 2 years, 10 months ago by  masterelaichi.
• This reply was modified 2 years, 10 months ago by  masterelaichi.

hope everyone had a wonderful break!

Just thought of revisiting this and check if the files I uploaded were sufficient enough

Hi Jeff,

I have attached some sample files which I created using this website called mockaroo. The actual files are more varied than the ones I have attached as there are...

• This reply was modified 2 years, 11 months ago by  masterelaichi.

Hi Jeff,

My apologies, I have been unwell and accumulated a mountain of work these past couple of days. I am hoping to upload some sample datasets in the next couple...

I was having a look at some of the raw files to upload to the tables and realised that I missed pointing out that some of the source files have...

Thanks, Jeff. Truly appreciate your help with this!

The only thing that I remembered was that the files were built from Excel files.  What I didn't remember was that you were...

• This reply was modified 2 years, 11 months ago by  masterelaichi.

No problem at all. I totally understand! Appreciate all the help 🙂

Sorry  for not getting back sooner as I was away from work and didn't have access to files. I had a look and there aren't too many columns that I...

Thanks, Jeff. Really appreciate that!

I think some of the columns may potentially have sensitive content or other identifying names but I will check that and, if necessary, dummy the columns or mask it before...

The CSVs were created from Excel. I just save as CSV. I am guessing they are tabbed (they do appear in a table format)

The tables do contain confidential information so...

Edit: the sql version at work I believe is SQL Server 2016. As for the version on my personal machine it most likely is SQL Server 2019 as I only...

The create table sql code gets automatically generated when I go...

That would have been my preferred method as well. But the project has been going on for a few years and this is what has been followed historically, even before...

The filenames are named with the groups there are in - Filename1_Group1.csv, Filename2_Group1.CSV, Filename3_Group1.csv; Filename1_Group2.csv, Filename2_Group2.CSV, Filename3_Group2.csv, and so on

When I create the dataflow task, I add the name of...

• This reply was modified 2 years, 11 months ago by  masterelaichi.