If you can get just a bit more specific, I think we can help you.

What do you mean by 'validate'? Is there a certain column that always has a certain...

For one solitary piece of data it's certainly a pain - but if you are generic about how you write it you will be able to reuse in future.

Phil

Not really. You might consider creating a physical 'Variables' table in SQL Server and using that to store/lookup any variables which are truly global.

Phil

That's not a great error message:) Maybe it should just have said: "Something, somewhere, is wrong."

I just tried one on my system. Try this:

Resultset = None

SQLSourceType = Direct Input

SQL Statement...

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