Hi,

using TRIM solves the issue

Hi All,

I have the following Expression working on a Derived Column in an SSIS Data Flow Transformation

[Date_Start] == " 0 0- 0- 0" ? NULL(DT_WSTR,10) :...

The current string in the expression is

Hi John,

I have tried with and without spaces at the start but made no difference

Hi there,

yes I have used konesans in the past and it is a great solution, unfortunately a lot of organisations will not accept it on their systems as the code...

Hi Peterjonk , Farlzy, Koen verbeech

what I've decided to do here is now that I have it writing Success to the Log whether or not a file is present, is...

Hi Koen,

Thanks for your reply...

I am thinking of coding the looping into the C# script, which is the first task...

The only issue I see with this, is that the dba...

Hi Peterjonk, farlzy and Koen Verbeech,

thanks for your replies. Just to clarify what I want to achieve

I have set up a test package which has two tasks.

The first task,...

Hi kenneth.mofokeng,

thanks for your reply.

The run64BitRuntime is set to False.

The issue only arises with this one specific file, the other xlsm files are loading fine using this SSIS package.

Hi,

thanks for your input...

I eventually got these files loading..

i noticed a few what i thought to me to be minor differences between the layout of the working...

Hi,

I eventually used the following code,

The excel serial data in my scenario always begins with '4'

The code below is fired at the loaded staging table in the database..

thanks for your...

Hi Koen Verbeeck,

thanks for your input... I believe it is the number of days since 1-1-1900, however there seems to be some issues regarding leap years ....

I have observed one further issue,

for example I examined one excel source file which has a date displayed in the cell as 30-Jan-2013, the cell is formatted as Date...

Hi devilsid,

thanks for your comment.

There is no particular reason I want that particular formatting, as long as they all values are consistently formatted I caan live with that.

When you say...