DSXchange

The most we ran at a time were 19 instances of a job , so till 19 no harm .. I dont know beyond that.

My Bad.... I mean ORDER BY

Well, Firstly whats your requirement? then whats your input ?as I said If your source is a database then do a group by and use this funtion then you will get the first 10 rows, and if your souce is any seq file then you have to necessarily use a Xformer and run in sequencial mode so that you can sto...

what is your input file as, if its a database file then you can surely limit the rows according to your requirement... if your imput is any of the databases then use these following querys to limit the rows and if your input is a dataset or a sequential file then use a transformer and RUN it in sequ...

If the row is rejected from any perticular stage then you might want to debug it using a peek stage and establish a reason why , but if it is a target stage then the best way is to go with a user defined update sql and capturing the error code.

I am not sure why did you get this doubt, log in to the manager and then go to import , select the file and import it in. Did you import the file in .dsx format or .xml format?

Try to do a view data, then try to import the table definition from the ODBC stage, probabaly we might get some more information by doing this....let me know