HI

Converting to text does seem the best way forward

because when I manually convert the column 'Code' in excel to text the data comes through fine to the SQL server... I...

Hi

I keep having error about does not support data type DT_R8

I have tried to go to the advanced editor of the derived column, but it won't...

Hi

after loads of digging on Google ...

advanced edit on the connection manager, columns, need to convert them there too, as well as using the data...

brill

all working , great

thanks team

hi

I got to use above really well with a fixed file name

how do you use the above if the file name is dynamic ?  I...

hi

there is no unique id for these records

the data looks like

OrderDate   Department   OrderProcessedCheckPersonel  PackedDate    Unit

01/01/2001    Catering       John Smith                                02/01/2001       ...

Hi

I am using Visual Studio 2010, and my file name is not different

file name is always called

OrderProcessData.xlsx

please help

hi

sorry I  don't understand how to use powershells

please help

Hi

the excel source column type is a float

and changing the file type to the int worked!

brill thanks team

Hi

the source is an excel document

OrderYearMonth
201601
201501
201401

I am using then a data conversion for the column OrderYearMonth     - DT_DBTIMESTAMP

hi

I am receiving an error with the code

cannot use DT_DBTIMESTAMP with a binary operator "/"

I have tried to change this to...

Hi

thanks team , amazing !

Hi

that is a good point

I would use the 01 (First) of the month

please help

brill x, thanks again team

hi

example, sorry I am new to SSIS  

ID           Name    Surname  Dept     Sales
AA1B2   Jack       Jones      Cakes   £220
AB1B8   James    Jones      Meat     £1100
Total:                                                 £1320

Its the last line of...