Sounds like security to me too. Try running the jobs in VS, but while logged in as the SQL Agent service user.

Phil

I suggest that you bring all of the data into a SQL Server staging table and then run one or more 'clean-up' queries on the staging table to do the...

Noffer (1/7/2009)

---

---

So, I goggled the code and came up with the following page in the Microsoft Knowledgebase...

http://support.microsoft.com/kb/933835 Does this look like its the source of our problem? Or...

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...