21. October 2009 01:12
By
rjdudley
In
SSIS | Windows 7 | Windows Forms
To run SQL Server 2008 on Windows 7, you need to update it to SP1. There are "known issues". Also, SQL Server 2008 BIDS will not install on Windows 7 unless you have updated VS 2008 to SP1.
If you're doing a fresh install of VS 2008 and SQL 2008 on Windows 7, install in this order:
-
VS 2008, WITHOUT SQL Server Express
-
VS 2008 SP1
-
MSDN Library for VS 2008 SP1 (if you're so inclined)
-
SQL Server 2008
-
SQL Server 2008 SP1
This will run you a couple hours.
Currently rated 5.0 by 1 people
- Currently 5/5 Stars.
- 1
- 2
- 3
- 4
- 5
Tags:
19. February 2009 07:53
By
rjdudley
In
SSIS
I was working in an SSIS package recently, and kept getting the following error:
[DTS.Pipeline] Error: component "<taskname>" (1) failed the pre-execute phase and returned error code 0xC0010001.
Pretty non-descriptive. This source is using a parameterized query in an OLE DB source. The problem was I had forgotten to set the parameter's value to a package variable. So if you're getting this error, check your query's variables.