IMO, you should use an output parameter. This is the most efficient method. If you need help getting the output parameter to work, post some code and I'll...

Could you post the answer and/or the link you found that provided the answer? That way if someone else googles it and finds this link then they will have...

You can do this in SSIS. That is what I am trying to tell you. You use the Script Task (a component of SSIS) to check for existence....

I understood what you wanted to do, I just was wondering why you wanted to that. One way to do what you want would involve the use of a...

A Script Task is one one of the Control Flow items in the toolbox in BIDS. It allows you...

Why do you need to do this? Wouldn't you have an order header with these 2 lines items on the order?

Are the $ amounts totals or price per item?

IMO, the best way is to use a script task which will allow you to check for the file, if it exists fail and do one thing in your flow,...

This is one of the "failings" in SQL Server. If you want a report that provides data based on a list of items you have a couple of options....

Can you post the linked server setup?

didier.boelens (12/8/2008)

---

Thank you for your answer.

Here follows additional information referring to your question...

1. Why inserting the record?

=> Since it might happen that several "users" would like to create a...

Thanks for posting the link.

I played around a little bit, but could not find a way other than making the user the owner of the database and that...

In the report, select the object you want to toggle, go to properties -> Visibility and set to hidden and set the toggleitem to the item you want to have...

Why do the insert? Why not build the key before the insert like this:

ALTER PROCEDURE dbo.sp_test

(

@in_parent...

I agree with Grant, something is closing the database. You should put a trace on it.

Duplicate post. Please post answers here