If I understand the situation, each package is expecting to find "C:\DBConfig\Databasename.dbConfig", but that file may now be moved (along with other things) to the D: drive. The key...

As Alvin suggests, all packages can point to a common xml file. But beyond that, you can have them use more than one file. We do that for our...

Since there's no such thing as an "identity fuction", I went with the create/select-into answer.... 😉

Seriously, though, I appreciate both the reminder of the identity fuNction and Hugo's immediate and...

I hope I haven't offended anyone or embarrassed myself by choosing a pronoun of the wrong gender.[p] It strikes me that one way to avoid that would be not only...

I've had to present a "best guess" at matching events from two data sources. Each source provides a subject identifier that tells where a package came from, but there's...

Jeff and RBarry,

I have the highest regard for both of you. I've learned more than I would have thought possible from your insightful and thorough analyses and solutions. You've each...

Good question, pointing out the change in stored procedure name.

Not to sound as though a direct update of system tables ever would be a good idea, I do...

Hmmmm. I don't know whether Elton Join...

Brian Knight, author of the Wrox Press "Expert" and "Professional" SSIS books, replied to a similar question that the preview function just doesn't work with parameters. http://www.bokebb.com/dev/english/2006/posts/2006107267.shtml

(Since this SQLServerCentral thread...

This sounds like a problem that the OP's client (or business partner if in the same company) should be involved with. I'd be very leery of letting a programmer...

It looks to me as though the original question of why only a single row is returned may be answered by an entry in the BOL under "Behavior Changes to...

To save y'all the trouble of clicking each MSDN link given in the solution, here are my condensations of the basic definitions....

date

Defines a date. Three bytes with a range...

You're getting great advice from some very smart folks on optimizing this. For my two cents, I'll suggest you consider not using the BETWEEN operator on your datetime values....

Part of the "where" clause is

and cyear=@currentYear

and ( cmonth>=04) or (cmonth<=03 and cyear=(@currentYear+1))

This is, of course, based on the original post where the comparison...

[p]Jobs and their schedules are in the msdb system database. There's a cool script posted a few months ago at http://www.sqlservercentral.com/scripts/Maintenance+and+Management/62222/ that has the joins and data formatting to give...