The book I bought when I started working with SSIS is Professionl SQL Server 2005 Integration Services by WROX. It worked well for me when I first started and...

Can't answer your question(s), yet, as we only have our Data Warehouse development environment at this time. We are still awaiting our QA and Production systems. Here is...

How's this: Let's take a complex process and dissect into it multiple subsystems and make it more complex to understand. If you are writing an ETL system from...

That I can't explain. I have installed all components of SQL Server 2005 Development Edition on both of my workstations, and assisted others with the installation on theirs with...

You were running the instcat.sql from the wrong place. You should have run it from SQL Server 2005 x64 server. we had the same problem initially, and once...

IIS is required to installed Reporting Services, you can proceed with the install of BIDS without having IIS installed on the workstation.

😎

Could you provide more details on how your installation of BIDS is being blocked? I have BIDS installed on my workstations and we don't have IIS installed on the...

Gotta root for the home town! GO ROCKIES!

Not if you spend pounds as fast as dollars. I was stationed in England for 2.5 years in the Air Force. It was expensive on the local economy....

Hopefully the code I provided works for you, but I (and I am sure others will agree) think it is not a good idea to store dates as integer values....

Can we ask why you need to do this?

Also, this should work: select year(getdate()) * 10000 + month(getdate()) * 100 + day(getdate())

Replace getdate() with your column name.

😎

Here is my take on things; don't read too much into the questions. Although the correct answer is a or b (either a or b alone is only partially...

Actually started getting into computers in Junior High School. My grandfather had a medical lab and purchased an HP 9810 (actually just a BIG programmable calculator) to do the...

Actually, all we are asking is that you try to solve your problems first. If you are having difficulties, show us what you have done and we will gladly...

Just thought I'd add an update. In setting up the linked servers I found that I didn't need to enable Named Pipes on SQL Server 2005, the ODBC connection...