Looks like Jeff was a little faster than I..

CEWII

You could try:

SELECT DATEADD( dd, -3, GETDATE() )

And you might look into:

Common Date Routines

CEWII

You can't reference the variable directly but you can use expressions to set it..

CEWII

I'm fairly sure that this won't prevent a sysadmin user from removing your trigger, but should help at the DB level.. I'd probably do the DDL trigger at the...

Ah yes, I agree, that is not going to work..

You'll have do to more user based mapping..

CEWII

Nope, not really. The time I played with it I was using some of the getting started stuff I found in the book online.. I'd start there..

CEWII

If mobile is involved it pretty much points a compact edition. There is no express for mobile..

CEWII

mbokker (11/4/2009)

---

I'm new so not sure about how to do that.

When I add a Derived Column task to a Data Flow Task, it complains because there is no input...

I saw...

You use a derived column task to get it into the pipeline and then you can select it in the data conversion task.

CEWII

I agree likely coincidental..

CEWII

Depending on a bunch of factors such as how big the box is and what events you are tracing you could cause the box to be slower, however, I agree...

Where in SSIS are you trying to do this? In a data-flow? If so then use the data conversion transformation to do the convert. And then you...

I like that reply Tom.

As far as approach, if you have a boss that isn't open to outside help then you are largely screwed. You will not get a...

Great, you are on the right track.. The 32/64 thing bites more people than I can count. I decided to add a suggestion for it:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=508253

Well I like to...