Where is the status field? Is it in a SQL Server table?

I understand your logic about importing:

1) Needs to be extracted from Oracle

2) Has been extracted from Oracle and is...

00 is NULL - whether that helps you at all is another matter 🙂

Phil

maria.protopapadaki (1/7/2009)

---

Phil,

Interesting, Task2 does not run when @Variable=="" is the expression (and the output param is indeed an empty string, so one would expect the task to run)

I guess this...

If you change the constraint to

@[User::MyVariable]==""

does it still run? That is, is the constraint being completely ignored?

I am not suggesting a scheduling problem. I am suggesting the possibility of a user-privileges problem. Maybe your script does something that you (or the user that you were logged...

Can you log in to your system interactively as the same user that runs the scheduled job (ie the SQL Server Agent user) and then try running the job again...

How can anyone help you when you ask a question like this? Please provide more...

Piotr Rodak (1/6/2009)

---

The sort transform returns the first row if duplicates are found in columns specified by sort criteria. At least it worked this way for us :), but if...

Sounds weird. So the source data is just a query on a SQL Server database?

Are you using a hex editor because the output files look the same in Notepad? I...

Noffer (1/6/2009)

---

-- --

Long story, but the question is straight forward. Why is SSIS trying to read the user variable value into the ole connection manager's connection string before the...

CSV files take no account of column width. This cannot be done. Are you talking about a fixed-width file?

Have you posted in the wrong forum, by any chance?

The sort transform is a mechanism whereby data in a pipeline can be sorted prior to sending it on to the next task.

There is an option 'Remove Rows with Duplicate...

So your field delimiter is a semicolon - sorry if this is obvious, but did you define this as your field delimiter in SSIS?

Can you post a couple of lines...

I have a piece of VBScript that will do the folder flattening for you ... but I guess that's not allowed, being dynamic.

Can't find any Windows command to do it...

Right...