I actually knew that and should have thought of it myself, but you mentioning it in context makes perfect sense in this situation. I'll definitely give that a shot....

Thank you for the quick response, I will try that out and see if that

does anything for me.

One thing that puzzles me about this solution though (and I truly...

Does the source Oracle query have all of its columns named (i.e for concatenated or calculated columns, you're naming those columns using an alias)? Otherwise those will show up...

If it were me, I would:

select max(len([columnName])) from [tableName]

for each column I was planning on modifying and compare that result against the length you want to change it to. ...

This is a long shot, but I had a similar issue when I updated some of the ODBC and OLE-DB drivers on one of my servers. I had a...

You can use the waitfor command. For example, the following code will select two different times that are 10 seconds apart.

select GetDate()

waitfor delay '0:0:10'

select GetDate()

There are some other options...

I had a somewhat similar problem where someone wanted me to create a proc that inserted a record into a "logging" database each time a web page page was hit.  This...

If you get really desperate and are able to, you could always restart the SQL server services.  Each time you restart SQL, tempdb gets recreated.  Unless you have a process...

This isn't going to be what you want to hear, but personally, I recommend against processes that create or alter procs affecting multiple databases.  If you create this process, then...

I hesitate to give too much direct information because, unfortunately, there is no "silver bullet" to performance tuning.  Tuning is one of those things where experience outweighs book knowledge.  The...

I feel your pain!  My favorite is when the network guy tries to give you advice on how to manage your SQL environment and thinks it is a good idea...

If everything truely is the same from the old server to the new, the first thing I would check is the physical connection of the server to the network among...

That is a good point that requires some clarification.  Our schedules do indeed cover flights from anywhere to everywhere.  So I do need to take minutes into account.  My implementation actually has that...

My suggestion is to consider a different implementation.  I work for a company that deals heavily in airline schedule data.  Needless to say, I am frequently concerned with locations and...

Without knowing the detail of your package, I would suggest this first.  If you are using the "destination file" object as part of a data tranformation task...

1) open the "destination...