HELP!! Transform Data Task Properties: Tranformation Tab Hangs...

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: JN (anonymous_at_discussions.microsoft.com)
Date: 04/05/04 

Date: Mon, 5 Apr 2004 09:36:06 -0700

Hello,

I am importing a large data file as part of ETL, but it freezes at the Transformations Tab on Transform Data Task Properties box! My input files used to come as a CSV and its size could be around 130 MB, but this time, we are experimenting with input file coming as a SQL Server VIEW instead of a CSV file. The only difference is that the source VIEW is built using multiple joins between various dimension tables and the source input file where as the CSV file obviously came with final extract of all data with applied dimensions in a static format. I am wondering if the freeze of Transformations tab due to source file being a SQL Server view with multiple joins? I tried opening the view, but it's so large, SQL Server times out each time. I can't even get top 10 rows of the view - it just times out!

Does anyone know a work around to importing this file (into a different SQL Server database on a different SQL Server)? Of course, there are also Lookup values from dimension tables at the destination during the import process. What can I do to read the data from source and assign appropriate transformation on the source data for the destination data/table? Do I need to go back using CSV format as the source file or need to "fine tune" the SQL Server view so that it doesn't hang like it's doing at the present in spite of multiple joins and large dataset the source file has? I don't know much about which data source file is the best to import in SQL Server or why using a SQL Server view as the data source hangs, though the same source file in CSV format works fine so any help you could provide is greatly appreciated.

Thanks much.

JN