No. One physical log file for that database but it consists of 235 virtual log files. I can't shrink the log file because the virtual log files toward the end...

The client's DBA is a moron. He is free to recommend modifications that would require the application to use a SQL query using an ORDER BY clause or he...

Nvmd. Reporting Services Books Online is my friend. I still think this UI sucks and is not intuitive at all. Hehe.

Thanks guys! This really is a great site.

Yep, figured out the conditional split and ninja edited my post. Hehe. Thanks again. You live near Atlanta, GA? If so, I owe you some beer.

I am damn close to having everything working now. I was including account_id in the unpivot and that was messing me up. I can't tell you how much I appreciate...

I tried messing with unpivot for a while. I just don't understand it. I eventually thought maybe this is not an unpivot situation.

I set the options as you explained but...

That is an excellent idea Matt. Thanks. One more question. All of my logic right now resides in a single data flow. To be honest, I don't really understand the...

Good call. I had to use the OLE DB Command transformation. For the very new like me if you want to do an insert or update and you can't stand...

I am starting to get the hang of it now. Thanks guys.

I got a book and am making progress now. The problem I was having was related to the IDE. I had a connection created and added a datareader option. But...

Has nothing to do with being new. You can't connect to an ODBC data flow source (that I know of) without having the option listed under the Data Flow Sources...

This is really not an ODBC issue. It is a toolbox issue. I can't add items to the toolbox. They don't show up.

Ok, I am getting somewhere. Only problem is there is not an ODBC source. I can only see an OLE DB Source in the toolbox. I would think that I...

I guess what I am not understanding is how you associate the query with the connection. Right now in Solution Explorer I have one item listed under the Data Sources...