Viewing 15 posts - 25,411 through 25,425 (of 26,487 total)
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...
November 1, 2007 at 1:21 pm
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...
November 1, 2007 at 1:11 pm
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...
November 1, 2007 at 1:01 pm
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...
October 24, 2007 at 11:02 am
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...
October 24, 2007 at 10:57 am
IIS is required to installed Reporting Services, you can proceed with the install of BIDS without having IIS installed on the workstation.
😎
October 24, 2007 at 10:12 am
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...
October 24, 2007 at 7:40 am
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....
October 23, 2007 at 11:48 am
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....
October 23, 2007 at 9:21 am
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.
😎
October 22, 2007 at 4:29 pm
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...
October 19, 2007 at 11:48 am
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...
October 19, 2007 at 10:46 am
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...
October 19, 2007 at 10:32 am
Viewing 15 posts - 25,411 through 25,425 (of 26,487 total)