Packages

Is it possible to run packages outside ETL like from the command line or PowerShell script and such?

Yes it is possible

Please have a look a the following article

www.etl-tools.com/wiki/advanced-etl-proc...mand-line-interface/

Thank you , I tired it and it works.  I tried to run it from SQL and it didn't work using xp_cmdshell and was wondering if anyone has tried it and able to provide how they did it?  
Thank you 

Re xp_cmdshell you might need to check the user access rights

Or if you have the agent installed and configured you can try this approach

www.etl-tools.com/automation/0009-runnin...-party-software.html

I do have Admin permission - I thought it would something simple, I have done it before, something like this 
DECLARE @command varchar(8000)
SET @command = 'c:\Program Files (x86)\DB Software Laboratory\Advanced ETL Processor Enterprise\aetlcl.exe 4714"' 
EXEC  xp_cmdshell @command
Or   this if I have the exe file in the c drive
SET @command = 'c:\aetlcl.exe 4714'
EXEC xp_cmdshell @command

But all I get is a Null output,  Your idea would work too but thought I would try to do the above - thank you 

You can try redirecting output to the log file 

SET @command = 'c:\aetlcl.exe 4714 > c:\temp\data.log'

It might have some useful information