This is resolved.

I just had to edit property of Excel Pivot to show row/columns with empty data 🙂

In BIDS,

1. Go to Tools->Choose Toolbox Items

2. Go to tab 'SSIS Data Flow Items'

3. Verify whether 'ADO Net Source' checkbox has been checked.

Cheers!

Maninder

That's correct. The complete filename (FileName+Datepart) should be built using expression builder.

I have also replied to other post you've referred to above.

Shouldn't the variable that holds date values be of 'Object' type than 'String'?

Sure, ORDER BY would be able to handle that scenario. and that Query would be required for First Foreach loop container.

Second foreach loop contaiiner should be used for looping through...

As per my understanding, below approach should be able to handle this:

1. Create a Table 'Time' which should have all the calendar dates and a Column 'IsProcessed' with flag 'Y'...

Hi Welsh,

Do you use Foreach loop container to traverse through these file(s)? I had faced similar situation, where I stored the Fully Qualified file name of file in a user...

Hello,

You may use Derived Column transformation in Data Flow task and REPLACE function should be able to replace the character in the required column(s).

REPLACE( «character_expression», «search_expression», «replace_expression» )

Cheers!

Maninder Kumar

Hi Koen,

I couldn't find any configuration warnings as I was running it via SQL Server Agent job and the package was running without any issue in my local machine.

However, I...

Yes Phil, that was mapped to the destination.

I tried to create 1 more derived column transformation and deriving a different column (Say "String 2)" and interestingly it started showing the...

Thanks Phil.

Creating user variable and Using Substring Function (to retrieve sub folder name) in Derived column transformation worked for me 🙂

Cheers!

Maninder