DSXchange

Same pearl with a different shine. You'll probably need to use user-defined sql. First, clarify what 'col2 < firstday_of_month' means. Col2 is a date? I doubt you can use 'MM' here without also including the year as well. I'm guessing you need a sql statement more akin to this: delete from tablename...

I'd suggest stepping back and not using user-defined sql, it's not needed here. Create one column in the stage for col1 in the table and mark it as a Key field. Use an Update action of 'Delete existing rows only'. Set the value of the key field passed down from the Transfomer to 1. Done.

That was just to get your job compiling and running with a chance of success. The actual setup of the DRS stage for this is a completely different issue.

Post your delete SQL.

Ah, yes... but you don't need to.

If the <CR> is at the end of each line, then you've got a DOS formatted file. If you tell the Sequential File stage that, it will read it properly.

That would only get you any defined in the Administrator.

Every job run logs an entry (second log entry, I believe) that lists all 'Environment variable settings'. Perhaps just locate one of those and build your 'report' from that?

You need to define a stage variable so the job will compile, no need to actually use it. Then a constraint to ensure that only one record goes to the database stage, otherwise the job will run forver. I use:

@OUTROWNUM=1

If there's no order to the Status data, meaning you could get something like this: 5 I 5 B 5 B 5 A Then it seems to me you'll need to make two passes through the data. You could use a hashed file that you wrote to and read in the same transformer, to build a list of ProdIds and record if you ever sa...

Is the hashed file in an 'account' or pathed into a directory? How did you try to delete the file? Has the job ever worked and is just now having this problem? Describe your job - are you using the hashed file as a reference lookup? If yes, it must exist first and have been created by another 'proce...

so when i tried to write following two records in a hashed file null , L1, F1 null, L1,F1 hashed file wrote just one record , deduping, i know hashed file would not allow duplicates , but in the above case , in my perception they are two different records as null is never equal to another null. Sam...

But, I can't ask the person generating this file to correct his CSV file (He doesn't know how to do...). Of course you can. Explain how. Anyone responsible for generating a spreadsheet as input to an automated process needs to be disciplined and not send you crap. They can delete the empty rows and...

Use a text editor to check the file you imported. You should find many references to a ReadOnly property, if they sent it to you with that option enabled it will be set to a 1. If that's the case, you would need to change that attribute to a 0 then reimport.

I have SQL server table as the target, but even then, the same order is not preserved. Should I enable any maintain order option? The issue here is simply a lack of understanding on how relational databases work. As noted, there is no 'order' to be 'preserved'. If you want to get records back out o...

You don't need the Sequential File stage after the XML Output, it is perfectly capable of writing the file out. Enable that from the Options tab. If you use the Load option on the Input/Columns tab to bring your metadata into the stage, everything will go in the right place, including the XPath Expr...

Patience! People have lives and are not here 24x7. Or they've got no idea. Start over. When you say 'import table definitions' how exactly were you doing that? Paste your error in again, even if you think it is exactly the same. Oh, and what changed between now and when it used to work? 'Nothing' is...