jcrawf02 (3/4/2011)

---

How do I decide when to use subpackages vs stored procedures vs straight SQL tasks? I would...

Pah, you beat me to it!

CozyRoc (3/4/2011)

---

Koen Verbeeck (3/4/2011)

---

You can use a for each loop to loop over the table and store the tablename in a variable.

Then you can construct a dynamic SQL statement in...

You're looking in the wrong place.

Try the 'Project' menu - the item at the bottom of that menu will say [project name] properties - select that.

Koen Verbeeck (3/3/2011)

---

Dammit, if that is the solution, I've wasted 5 minutes of my life typing an answer while continuously checking the...

Sorry, remove single quotes and try again.

As long as the files have consistent formats (same order/number/data type of fields), it is possible.

SSIS is not good in scenarios where you want to be able to handle file...

I suggest you read up on the use of Foreach loops to process one file after another.

(You said keep it short:-))

OK, something like this then:

Use MSDB

Go

GRANT EXECUTE ON dbo.sp_dts_getpackage to 'MyUser'

Well, that seems fairly clear-cut.

You need to

GRANT EXECUTE ON MSDB.dbo.sp_dts_getpackage to

where is the name of the (SQL) user executing the package.

Please post the text of the error messages you are receiving.

SSIS needs to be installed on any machine running the package - so the app cannot just initiate the package to run unless you have SSIS installed everywhere (sounds expensive!)

A question to the OP:

Consider the following scenario ...

Package runs at 1pm.

1) Change made to record at 1.05pm.

2) Another change made to same record at 1.10pm.

Package runs again at 1.15pm.

Your...

Non-native you may be, but your English is still (usually!) better than many native speakers, otherwise I would not have written the post:-)

Right letters, you just wrote them in the wrong order 😀

Yeah, I know, it's Monday.