Try this:

@[System::PackageName] + RIGHT((DT_STR,4,1252)YEAR(GETDATE()),2) + RIGHT("0" + (DT_STR,2,1252)MONTH(GETDATE()),2) + RIGHT("0" + (DT_STR,2,1252)DAY(GETDATE()),2)

Please take a little more care with your question.

What do you mean...

Sure - that's what it's for 🙂

jcrawf02 (3/4/2011)

---

heh...makes me think of that sig (can't remember whose at the moment) "semper in...

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.