You are welcome.

CEWII

You are very welcome. That leap is quite steep the first time..

CEWII

Try:

http://www.codeplex.com/site/search?projectSearchText=zip

Good luck..

CEWII

Uh, there are no 64-bit jet drivers to get an install..

The way around this is usually SSIS being run by the 32-bit version of DTEXEC.

Sorry..

CEWII

First I think an instead of trigger might be just the thing to control the insert and manipulate the data..

Second I think this might be what you are looking for...

Here is a link to some common date routines:

http://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

CEWII

I'm sorry but you haven't provided enough information.

What is the OS version?

What errors did you get? It didn't work doesn't mean anything..

Lets start with that and see where we...

I think there are several things in play here. From SQL Agent if you have a job that calls a package it will only run one at a time....

I believe the answer is yes but you will need to look into what is called External Activation. I would probably start at: http://blogs.msdn.com/sql_service_broker/archive/2008/11/21/announcing-service-broker-external-activator.aspx..

CEWII

It sounds like you want one column with date AND time. IF that is true then this is probably the answer:

(DT_Date)(SUBSTRING([Column 1],5,2) + "-" + SUBSTRING([Column 1],1,2) + "-"...

"using their powers for evil".. That makes me grin..

CEWII

I can't think of anyway to do it in the same schema short of building the logic into your sproc. The engine won't do it, the security model prevents...

Good question.. And I wholly agree. Best is very relative to the given circumstances and limits. And what is best at Company A may not even be...

If the sproc and underlying table are owned by the same user(schema) such as dbo then the assumption is that you should be able to perform the functions that the...

I moved from pass-thru views to SYNONYMs on a recent project. Love it..

CEWII