DSXchange

Thanks ray - I created a routine that uses your opensequential file function to write the data to a seq file.

Is there a way of returning a flag from the opensequential file to identify if a new file was created or that we are just appending records?

I want to call a job from a routine with a number of parameters. I want to then write the values of the job parameter to a seq file.

How do i create a job to run with just a sequetial file writing the parameter values to a seq stage?

I use oconv(iconv(lkTransactions.TransactionDate,"D/DMY"),"D2") but still get the error. I have tried lots of different date formats.

Do i need to do something on the SQL server side?

I get the following error trying to load a date value into a datetime field in SQL Server (using SQL Server odbc driver). I have tried the folowing: 1. left target as date and used iconv to convert the date 2. made target a string and used iconv to convert the date 3. Used oconv to format the data i...

Yes that is correct - and - i have looked at KB's site.

The question is more is more conceptual/arcitectural. This specific example is covered at KB's site, but, the requirements i have detailed will be needed for other applications.

KB has hidden all the code for the utilities he has written?!

thanks - solved

My last post was a little unclear: What I want to do is: 1. Populate a text file with some values (eg: List of all the projects on the server #PROG_DIR#\DsJob.exe -server #HOST# -user #UID# -password #PWD# -lprojects > #EXPORT_DIR#\PL.txt ) 2. Loop through each of the values in the text file and cal...

Sorry, I am new to DS (2 weeks). So i must admit this is all 'gobeldy-gook' to me. is the Variables stage the User Variables Activity? I do not have a Variable Stage in my DSJob pallette! Any chance of stating all the items I would need and their joins - I can work on the detail!!! Do I need?: 1. st...

I got this error running a job with a Notification Activity. I cannot find any more details about why 'SMTPMail RCV: 550 5.7.1 Unable to relay for xxx@xx.com.au' happened?? Full trace below! NB: I tried it from the cmd line but got the same error. My 'dssendmail_template.txt' uses: <file> From: %fro...

I have a command stage with an input of a seq file.

My question:
I know how to use job parameters in the command line (#PARAM#), but how do i use the row values from the input seq file as a value in the command line?

ODBC DSN connections to Excel are readonly by default - need to ensure the readonly check is off!!

I get the following error when trying to write to an excel sheet using ODBC or OLE DB (using a DSN).

Operation must use an updateable query
DBMS.Code= -3035
SQLState = S1000

HAs anyone found this error because I cannot understand why!!