To expand on LutzM's post, you need to use the PIVOT function. The issue with this is that the PIVOT function requires you to specify the column names/values, but...

If you mean that the files contain the same data but the field and row terminators are different and the fields are in a different order then I would look...

From 2003, Excel files are just XML documents (as are all office documents)

so you could generate the xls or xlsm file dynamically - its quite a bit of work to...

sounds like homework to me...

You want to lock the variable so that no other process can change the value whilst your script runs, otherwise any logical processing you do may...

You can do this in SSIS (I am about to emark on a DW build that will use this principle!)

You can use the unpivot task (it is a little confusing...

So what we are looking at is a rolling delete process

My preference (for codeability) would be a sproc in the database that takes two arguments Tablename to be deleted and...

OK,

Looking at the screenshots, I think your safest bet would be to have another data flow task

2 data sources: SQL and Oracle - select the original dataset from SQL and...

So is the source file missing data (i.e. are the lines of empty fields supposed to have data) or just extra lines.

If you are happy that the data is complete,...

+1 for Phils suggestion. Keep Excel a long long way away from SSIS.

32/64 bit compatability issues (made more complicated when you develop on 32bit laptops and deploy on 64...

I am going to hazard a guess that the CSV is generated from an Excel file and that there were 400K empty lines at the end of the CSV file....

If you are only reading data I would definitely use sprocs or views;

If you are inserting, deleting or updating data then it is a bit more complicated. Where...

When you say three months, do you mean a rolling 93 days, or archive a month at the end of each month (i.e. have between 3 and 4 months on...

If it is important that all rows are transferred, then put all the relevant control flow tasks in a sequence container and turn on transactions. You may also need...

your problem is going to be that a dataflow requires the field names and types of both the source and destination to be defined prior to compilation so you would...

Love it 😛

Reminds me of one of my favourite jokes:

Q: Why does Excel get Christmas and Halloween confused?

A: OCT31 = DEC25 (actually OCT2DEC(31) = 25 but it doesn't sound...