I have had to reinstall OS & all software on development box after a HD
crash, but cannot get SSIS to work as before. My setup:
XP Pro Sp3
Visual Studio 2005 & 2008
SQL Server 2005 Standard with Integration Services
SQL Server Integration Services service is running, but I cannot run a SSIS
package. There's no file association to .dtsx files and VS 2005 does not
recognize .dtproj files to do so in debug mode.
I have gone through the great pain of un & re-installing SQL Server 2005
(and thus SSIS) to no avail.
I ran out of time to waste guessing the correct order of events and
dependencies a couple of weeks ago, and had hoped the previous post would
eventually lead to some guidance so I could take up the matter again. This
post serves as that hope's last gasp.
"bbirindelli" wrote:
Check event logs on that machine.
Go to ...Microsoft SQL Server\MSSQL.1\MSSQL\LOG and check log file for that
package.
Create a simple maintenance plan and execute a job for that maintenance plan
- see what errors do you get.