DSXchange

Hello, I trying to use an ODBC stage with a Access Database. The connection is OK, but when i try to make a query on one ODBC access table, it dosen't work. In fact, in access database, table have some column name composed by two word like this : tableA.purchase order. How can i read this table ? Th...

i recreate the odbc link in DSN system.
it's working.

Hello, When i tried to import a ds project using an odbc stage (excel odbc definied on ds server) il have the following errors : Line : Unknown property name Stage Type Object=V0S0 Classe = CODBCStage I have this error on 2=3 lines (lines 3637, 9804,15764). When i open a job using an odbc stage, i h...

I can't used emlail list because we launch datatsage job using a portal and the email depends of the connection login.
I think i have to used two notification activity in my job .

Thanks for your help

I used a paremeter file and in this file i defined one variable called VarCarReceiptAdress. I used this parameter in the notification activity stage. in VarCarReceiptAdress i wnt to define to email like email1@societe.com + email2@societe.com i m working on windows platform. i have tested to separte...

i have tested your solution using space
and email is only send to the first email adress

yes,
it's due to a special format applied to the file
thanks for your help

I used an excel workshet using ODBC stage.
I added new lines to the end of my file and i don't see them if i do a wiew in my odbc stage.

many thanks for your help,

hello when i try to send an email notification, i bahe the following message : SeqUpdateDnB..JobControl (DSSendMail): Error when executing command: SMTPMail RCV: 454 5.7.3 Client was not authenticated. Contents of command file: C:\Ascential\DataStage\Engine\bin\dssmtpmail.exe -server SMTP serveur-fr...

Hello,
How can i send email to multiple mails using Notification Activity ?
Do i have to used , or ; as separator ???


Thanks for your help

Is it possible to create a sequencer running job activity stage based on parameter updated directly by user (not in a file): When i execute the sequencer, aprompt appears asking the value of the parameter


Thanks for your help

no i don't succeed to reproduce it.
Apparently it's specific of my project. I exprot and import datatsage between 2 environments which are not (certainly) the same.

Is an option exists on the server (or during server installation) to specify each time you import job, import it in multi instance ?

Each time i import one project, all jobs are marked as multi instance.
In the original project, they don't.
Any idea ?

Thanks a lot for your help