ETL and Data Integration tools - Modern ETL software for everyone

Downloaded trial version of Advanced ETL Pro to evaluate.
I created a transformation (txt file to SQL database) and it works but when I want to use it in a package it doesn't.
Can you help me with this?

Did you get any error messages?

Mike,
www.etl-tools.com

Yes, that the transformation doesn't exist.
But I think the problem is solved.
Apparently you get this message when your transformation is still open.

Another question.
Is there a function in the transformation to keep only numbers in a field an remove all the rest(for example phone field)? Or can you create your own functions or do you have to resolve it with a script?

Yes you are right you have to save transformation first.

There is a function which lets you remove characters.
I do not have the software in front of me right now
I think it is called delete characters
Anyway it is possible.

Mike