I suggest that you concentrate on getting the sp working fast on its own without worrying about SSIS for now.

You should try to work out where the bottleneck is: is...

Add an Execute SQL task. Set the appropriate Connection info, then set the SQL Statement property to

EXEC sp_name

where sp_name is the name of your stored proc.

Phil

Are you asking whether it is possible to write a query that accesses data from SQL Server and Access?

I agree that you need to expand on what you mean by...

You might investigate using the file watcher task - check this thread for more details:

http://www.sqlservercentral.com/Forums/Topic493253-148-1.aspx

Phil

Can you use a script task?

If so, you can put the filename into a variable and then process it.

There may be an easier way, but script will work for sure.

Phil

Agreed and done.

Phil

If you enjoyed answering this question, you can do it all over again here:

http://www.sqlservercentral.com/Forums/Topic634483-148-1.aspx

Phil

Is this a homework question from a college course, by any chance?

This thread looks too similar to be a coincidence:

http://www.sqlservercentral.com/Forums/Topic634303-148-1.aspx

Phil

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?