ETL and Data Integration tools - Modern ETL software for everyone

Help me please.

I'm trying to import an Excel file into my SQl Server.

On the log all the messages are OK ( import 3 records ),
but IF i

make a query in a query analyser the records are NOT STORED or upgrade.

Thanks in advance
Débora

Hi

Please email us your log and script

Also make sure that you are using latest version

Mike

Débora

Click Help -> Check for updates now. and it will tell you the version number

I have just loaded the data from excel file using your script without any problems

It would be the best if we can connect to your computer remotely and check it ourself

If it is not possible can you try the following

It could have something to do with your source target connection

Try loading data from text file
Try different server/table may be you have not got enough user rights
Remove all validations.

Try setting batch size to 1

Please let us know the outcome
Mike