don't MAKE me whip out a CLR UDF for regex....:)

By the way...

You want to look up "Dynamic SQL" in Books Online. It will get you there.

The two big commands you want to look at are EXEC and sp_executeSQL.

Execute in BOL

Sp_executeSQL...

Then he can change permissions to whatever he wants....

Agreed - I don't think this was badloy worded, especially keeping in mind that wording a question so that the answer is essentially given to you defeats the purpose. ...

hehe...I see Romper room is in session again....:)

I'd comment, but there are so many topics going....I think I'll just go sit in the corner, suck my thumb and watch the...

Jeff Moden (3/19/2008)

---

I figured that much out... I remember how big something like this got in DTS... that's why I was taking the T-SQL...

All right- if you're hard-core about wanting to use SSIS:

1. You're going to need to read up on file-system tasks and foreach tasks (so that you can "loop" on each...

antonio.collins (3/19/2008)

---

my 'favorite' requirement was to send a report a particular printer after the first data load of a month. all other scheduled reports resided on disk and the...

Joshua - from the question itself:

You...

antonio.collins (3/19/2008)

---

but this simple test is often not applied. requirements wind up being dictated with little open discussion between parties. i have no problem doing justifiable work even...

If you prefer the convert (since it gives you more control over the format) - try:

select convert(datetime,'03/18/2008 13:12:29 ',101)

Looks to be the format you're wanting

I have a feeling you may need to split off the EDT from the rest, and somehow convert that (if need be) to a +/- hours from GMT. The...

Does each file only have one of these policies in it, or does it have a repeating pattern of these?

I take it you have zero control over how...

Tony - any way to get MUMPS to "dump" that data out to a text file? How long does that take? Some of the ODBC implementations just were horrible...