Turns out that the sysadmin has decided to use a different server to use for virtualization. Upgrade now not necessary! Thanks for all input here. SSC is...

I was told by our sysadmin that 32 bit SQL on 64 bit OS was not an option, also the small amount of research I did on that indicated performance...

Data backups are a definite and already in place. I'll probably do one final full set just prior to shutting down SQL Server so if I have to restore...

Have you tried upgrading the package to 2008 and deploying that version to your 2008 SSIS server? All you need to do is open the package in BIDS 2008...

Overall I would start with a list control and group on sales person and lay out all of the elements on the left, then add a subreport on the right...

Several things to try:

Run a profiler trace to see what is being passed in to the query(be careful if on a prod server).

Can you run the subreports standalone...

We also use CozyRoc for SFTP, Zip, PGP and Excel connections/components. The pricing is good at $400 per year or $1600 for perpetual licensing. On the SFTP task...

TravisDBA (1/18/2012)[hr

It must be nice to be at a point in life where you can choose that. and have an extra income to support that decision vis-a-vis your husband. However,...

I planned my career so that I can do exactly that. Pre-family, I worked long...

All of our work is done via Citrix connection to company-owned desktop image on company owned resources. Our company does provide thin clients at the office, but work for...

Again, hard to say without knowing your data or report requirements...but yes, typically you transform the data from an operational database into a data warehouse schema. You build out...

It's a little difficult to offer a solution when we don't know much about the reports that you have to deliver.

I can talk to my experience - we...

I'd definitely go with a For Each Loop and use the File Copy Task. I'd either read from a database table or configuration file. That way you don't...

ammo-963576 (11/22/2011)

---

With your SSIS project approach, are you able to get the package to log to the existing maintenance plan tables in MSDB? And have Management Studio recognize your package...

Are you trying to update the @Result table with an aggregate from the @Depts table? If so, you need to change your update since you have multiple rows for...