I got errors 'select permission denied on sysfiles', 'select permission denied on sysfulltextcatalogs', etc depending on what task was attempted. Turns out someone had revoked select permission on system...

I got these errors because I was installing via remote desktop, and had copied the media to a directory on the server; see http://support.microsoft.com/?kbid=916760  if that's your problem.  (client...

Since I don't want to schedule every package for the devs, I was motivated to get this to work.  I used the same proxy user I had for SS2000 jobs...

If you don't have a SSIS Package execution proxy user set up, you need to do so (create credential first using the correct win authent pwd); grant the proxy user...

I cross-posted, thanks again, Jamie.

When in doubt, check BOL (still having trouble with the search).  It works with:

"C:\\Local\\DataIn\\SEG_IDEM_"  +  (DT_WSTR,4)DatePart("yyyy", GetDate()) <"10" ?

(DT_WSTR,4)DatePart("yyyy", GetDate()) : (DT_WSTR,4)DatePart("yyyy", GetDate()) +"0" +

(DT_WSTR,2)DatePart("mm", GetDate()) +  "0"...

Sorry, that's what I want, I'm getting 2006327.txt

I need to have the expression always evaluate to a 2-character month and day, my current filename evaluates to seg_idem_20060327.txt:

"C:\\Local\\DataIn\\SEG_IDEM_"  + (DT_WSTR,4)DatePart("yyyy", GetDate()) + (DT_WSTR,2)DatePart("mm", GetDate()) +  (DT_WSTR,2)DatePart("dd", GetDate()) +...

Hi,

The proxy user applies to DTS also.  You need to change the owner of the job that executes the DTS package to a non-sysadmin user.  The proxy user only executes...