Cannot write to kettlejobs/incremental-public-L_TVA/PAYS.ktr at ./sqlserver2pgsql.pl line 1136.

[hobbes]

Hello,

I get these errors when I try to create the kettle jobs:

./sqlserver2pgsql.pl -b tables-before.sql -a tables-after.sql -u tables-unsure.sql -k kettlejobs -sd SOURCEDB -sh sqlserverip -su USERNAME -sw USERPW -pd postgresdb -ph localhost -pu user -pw pass -f tables.sql 
Warning: because of its length, the constraint name I_FOURNISSEUR_CONTESTATION$I_FOURNISSEURI_FOURNISSEUR_CONTESTATION is ignored and will be set by Postgres at execution time.
Warning: because of its length, the constraint name SSMA_CC$I_FOURNISSEUR_CONTESTATION$REF_FOURNISSEUR$disallow_zero_length is ignored and will be set by Postgres at execution time.
Warning: because of its length, the constraint name I_FOURNISSEUR_FOURNITURE$I_FOURNISSEUR_PRODUITI_FOURNISSEUR_FOURNITURE is ignored and will be set by Postgres at execution time.
Cannot write to kettlejobs/incremental-public-L_TVA/PAYS.ktr at ./sqlserver2pgsql.pl line 1136.

I guess that the constraint are not problematic, but the last one is scarier... it seems to stop the job creation...

ok, I understood it: there's a / in the table name, which is the directory separator in file paths... so I can deal with it myself, but maybe it's possible to add some logic there in the script.

Thanks a lot for your work, deeply appreciated.