We may (will) have to revisit how we are doing configurations. The process we use now works fine between developing on our workstations and deploying to our development system....

Is there anything in the data to indicate when the data changes from one format to the other?

Personally, different data should be in seperate files.

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...