Matt, Perfect, it was CDOSYS i was trying to come up with when I suggested doing a serach on CDO on this site!

😎

Go up to the Search box on this page, and do a search on CDO. You will find many hits, and one or more of them may be quite...

Actually, for me it isn't much more help. I could really use a more detailed description of what you are trying to accomplish. If you could provide DDL...

It would help if you could provide us with some sample data. This article will help you put together wjat we need to help you better:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

😎

There may be a better way to accomplish what you want, but to do that we really need to know the structure (or at least the relevent portions) of the...

This could probably be done using dynamic sql. To really help you, we need more info from you to be sure we give you something useful back. Please...

Give this a try:

SELECT TOP 500

MuniAnnuals.DOCID,

MuniAnnuals.FYE,

MuniAnnuals.DOCNAME,

MuniAnnualsdocument.DocumentID,

MuniAnnuals.StateID,

...

Also, can't change the time when the jobs run, part of the process has to be completed prior to 9:00 PM local time to ensure data is transferred to a...

I wish it were that simple. All of the jobs have multiple steps, one even has 60+ (I'd have to open it to get the exact number and I'm...

And I'll third that. That should actually be the first thing you do.

😎

Jeff, I knew there was a way to do it with dateadd, I just didn't think it through enough. Good catch!

😎

I am assuming that when you say you fixed the issue in the GUI, you meant that you set the package property DelayValidation to true. If you saved and...

We are still having a problem with this. If anyone has any ideas they would be greatly appreciated.

😎

I would do this is four steps.

1. Create a new column on the table as a datetime column: xyz_new

2. Update the new column with the following code: update...

MD, glad to help!

😎