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!

😎

Check this thread for the code from one of my Script Tasks:

http://www.sqlservercentral.com/Forums/Topic443977-148-1.aspx#bm444004

You would then use the value returned from the Script Task in a File System Task to rename the...

To expand a little. We installed SQL Server 2005 DE on a development server (don't have our QA servers yet). We purchased one copy of SQL Server 2005...

From what I have been able to determine, you need the Professional version of Visual Studio or better to debug stored procedures. That was one of my big complaints...