Try to convert it using the expression (DT_DBDATE)[ColumnName] in a derived column and Most importantly Set the Option to Ignore Failure in the Error Output Tab of Derived Column Transformation....

Its better to do it using SQL Query than in reports..

Can you post some valid sample data and Few Insert Statements with Values and also your table structure to help...

did you trying changing the data type in the text file to dt_date or dt_dbdate type ?? If you just want to convert datatype using an expression it would be...

can you post more details about which component is producing this error..is at the source or destination..Can you post more detailed description ??

That's really strange.. Is the package corrupted ? Did you try running each task separately ??

I have set the Access Mode to a specific file and when the job runs it brings the same file in 16 times which is the number of excel files...

I have used the following expression to calculate the age. It gives me years but i cant seem to calculate the remainder as number of months.

=round(datediff("m",Fields!DOB.Value,Fields!REQUEST_DATE.Value)/12,2)

For a pupil who is...

Paul

i believe that it might be a typo but the SQL is missing a "," before Col3. Now the error describes metadata has not been updated meaning there was a...

I would go with the approach of using a YYYYMMDD* format to get those two files.You can use a for each loop to pass the value using a variable.. Let...

Do you knw the count of the Files that you are looking to fetch each time? how many times would the job run ?

How are you checking for the most Recent files.. Do you store the Latest File Name on every run and use that to determine the next set of files??

Is it a package level variable or task level.. If its a task level or limited to the FEL task only change it Package level variable

fiaolle (3/31/2010)

---

Hi again

It works, thanks. But what if I also want to get the rows that doesn't have any images, meaning the rows from tblVara that doesn't have fldVaraID in...

elchuru (3/30/2010)

---

Hi,

This problem may be common in this forum. In my folder i have 100 zipped files,i want to unzip all these files at a time.Can anybody suggest me step...

are u passing this variable as an argument.. Can you post a detailed error??