Flat file source component hangs after installing SP2

Hi there,

after we've upgraded to SP2 my flat-file-source component hangs in the validation phase.

normally at 50% or 66%.

i see no activity what-so-ever cpu-wise/memory-wise.

have no idea how to fix it.

(sorry if i am posting this twice, couldn't see my previous post)

Hi Mafti,

could you give us more information about your flat file source configuration? What type of flat file, how many columns, etc?

Also, could you make sure it actually hangs in the flat file source: copy your package and simplify it to have only a single data flow with the single flat file source connected to the row count?

Thanks.

Fixing the Problem

I followed the suggestions of some in this thread but the easiest, and subsequently the one that worked for me, turned out to be simply installing Reporting Services for SQL Server 2000. In my case the registry didn't have the rptproj extention listed so the narrative 'make sure the application for the project type (.rptproj) is installed' made sense to me. After installation class was listed in the registry and Visual Studio 2003 could now see, both files were shown whenever I went to the solution directory, and open the report files. I hope this helps some but it seems there are differing problems tracking the same error message.

Hello Steve_King:

Could you please gives the link about the thread which has the suggestions?

Are SQL Server 2000 and VS 2003 used by Team Foundation Server?

Thank you very much.

Fixing the Problem

I followed the suggestions of some in this thread but the easiest, and subsequently the one that worked for me, turned out to be simply installing Reporting Services for SQL Server 2000. In my case the registry didn't have the rptproj extention listed so the narrative 'make sure the application for the project type (.rptproj) is installed' made sense to me. After installation class was listed in the registry and Visual Studio 2003 could now see, both files were shown whenever I went to the solution directory, and open the report files. I hope this helps some but it seems there are differing problems tracking the same error message.

Hello Steve_King:

Could you please gives the link about the thread which has the suggestions?

Are SQL Server 2000 and VS 2003 used by Team Foundation Server?

Thank you very much.

First Time Installing - Can't Find BIDS

Thank you to all that take the time to read this!

All software is installed on a single development pc.I have a SQL Server 2000 Developer Edition Database that I am using to test a new Accounting System.SQL Server 2000 is the required format.I would like to start developing some SRSS reports against that database.It was suggested that I install the SQL Server 2005 Reporting Services, because I was told 2005 is less buggy and easier to use.I installed SRSS 2005, and only SRSS 2005, and used the Configuration Tool to get it configured properly, I think. I have green checks on everything except "Email Settings" and "Execution Account"

Now, I want to write some reports.BIDS is not under the "Microsoft SQL Server 2005" program group, only "Configuration Tools".I was also told that I could use Visual Studio to write reports.I installed Visual Studio 2005 Standard Edition.When I go start a new project, "Business Intelligence” is not a project type or sub-type.

What do I need to do so I can either install BIDS or use VS 2005 to write reports?

If you open Visual Studio 2005 and create a new project, do you see 'Business Intelligence Projects' as an available project type?

Jarret

|||

BIDS is part of the SQL Server 2005 Workstation components and development tools - you'll need to go back and install that option in the installer.

Installing BIDS includes the SSRS support in Visual Studio. (BIDS actually is Visual Studio, just with little/no programming language support by default.)

|||

Rup,

Thank you for the help! That was the problem.

First Steps: Installing SQL Server?

Hello,

Thanks for reviewing my question. I am trying to install SQL Server 2005 but I keep running into the same error:

SQL Server Setup failed to obtain system account information for the ASPNET account. To proceed, reinstall the .NET Framework, and then run SQL Server Setup again.

The only documentation I find on this is configuring the issolation mode in IIS 6.0.

Any help on is will be appreciated.

Peter

PNKonstant wrote:

The only documentation I find on this is configuring the issolation mode in IIS 6.0.

Are you running IIS 6.0? If so, did you check to make sure it's not running the WWW service in IIS 5.0 isolation mode?

Otherwise, are you sure the .NET Framework 2.0 is installed on the machine?

Are you installing the release version of SQL Server 2005? Had there been a beta on the machine previously?|||

Hey Terri,

Thanks for reply. It's a Windows XP machine. The machine has VS 2005 installed on it. I think the version is 5.1. .NET Frameworks 2.0 is also installed on the PC. I noticed that there is no ASPNET user account.

Thanks for the help!

Peter

|||I think you should try to re-register ASP.NET on your machine (this shouldn't hurt anything). Run this command from c:\Windows\Microsoft.NET\Framework\v2.0.50727\, which will recreate the ASPNET account (and will also set up the script mapping in IIS):

aspnet_regiis.exe -i

This is the documentation for that executable:ASP.NET IIS Registration Tool|||

Hey Terri,

Thanks for the help. I figured out that the PC was missing the ASPNET user account. I turned off my virus protection (McAfee) and repaired my .Net Framework 2.0 and wa la the user account was created - SQL server installed correctly. I spent half a day trying to figure out what was wrong but ends well.

Thanks again for the help!

Peter

|||Are you saying that McAfee was preventing the creation of the ASPNET user account?