Excellent Jack. Thank you!

After seeing so many RBAR posts from Jeff I had begun to research the tally table method. But I just could not get my head...

This sounds like a scenario where the new "sparse columns" feature of SQL 2008 might be of use, although I realize you probably have to use SQL 2005.

Not sure what your DB2 lives on - but in my case, we have DB2 on an iSeries(AS400). I use the iSeries Access ODBC driver. In SMS 2005...

I'm not saying that manipulating an Excel file isn't possible from SSIS, but I think it may require some pretty nifty programming to accomplish.

Seems to me that you...

My experience with Julian dates is from a mainframe system.

The Julian date used was an integer composed of the 4 digit year plus the number of the day of the...

In my environment, although we have a SAN, our net admins have decided to use local storage for the ESX VM's we have. I think they're just a set...

Don't know if this is what's going on - but it's something to check....

There are special security considerations when using xp_cmdshell. You can review these in BOL.

I use Litespeed to backup one of our 200gb databases. I also use Idera SQLSafe to backup several other multi-gb databases we have. Both do a good job...

You would use a DataFlow transform to extract the table data. The Destination Connection string would be composed dynamically using an expression. The expression would use a variable. ...

We do this quite frequently in our SSRS 2005 reports. It is done by including a USE statement in the SQL code. Like this:

"USE " & Parameters!DatabaseParameter.value &...

How are you setting the value of your file name variable ? From an external package config or self contained within the package?

You may have to do 2 things:

1 - Data Conversion ( if your original field is coming in as an integer type this is where you cast it to...

See the sqlcmd utility in BOL

What you're suggesting is pretty much what I do now... I put a Data Source with the same name in the project directory. But since the rdl from the...

Scott,

Thanks for your reply; but that's not quite what I'm after.

We have a vendor supplied app that is built on top of SSRS to assist users in designing...