Hi, I have a simple SSIS task that extracts data from view and inserts it to a table. When the SSIS validates this task, it takes him about 20 minutes.....During that time i can do nothing in my solution and i get a small popup saying if this issue persists, to contact Microsoft. Any idea who i can do so? Thanks in advance, Uzi

Hi Raad, Thank you for your reply. The issue is i still face it when i run the task. It takes 30 min to copmlete... Uzi

you can not avoid validation at runtime! just you can decrease load time, maybe your view takes long time to load.http://www.rad.pasfu.com

Hi, The view takes 90 sec to load. the validation takes more than that.... I think it is more VS issue. Do you know where i can post support case to Microsoft?

Hi, The view takes 90 sec to load. the validation takes more than that.... I think it is more VS issue. Do you know where i can post support case to Microsoft? do you have any other sources? like flat file or oracle or .... ? do you connect to another sql server instance to fetch data from view ( I mean another machine ) , if yes, there might be some network problems on bandwidth or in source server configuration and hardware. after all, you can post your bug reports to Microsoft in MS Connect here: https://connect.microsoft.com/http://www.rad.pasfu.com

Hi Uzi, Could you provide more information about your package and the view/table, like what component you used, what kind of view and how large is the data size if you can't provide the original data. That will help us to identify the problem. Thanks. Best regards, Rodge

What if you run it with DTEXEC? Can you run a Profiler session and see what is happening?Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Hi, Can you please elaborate on what is Profiler session?

Check out the following link: Step-By-Step: An introduction to SQL Server Profiler SQL Profiler is a tool that captures SQL Server events from the server and saves those events in what's known as a trace file. You can then analyze or use the trace file to troubleshoot logic or performance problems. You can use this utility to monitor several areas of server activity, such as: Analyzing and debugging SQL statements and stored procedures. Monitoring slow performance. Stress analysis. General debugging and troubleshooting. Fine-tuning indexes. Auditing and reviewing security activity. http://articles.techrepublic.com.com/5100-10878_11-5054787.html Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Hi Rodge, I am using the regular component - Data Flow Task and in it, I am using or OLE DB source (from SQL) or Excel Source) to OLE DB Source (SQL). The task that takes the most time is a simple view that extracts data from a local DB (DB located on the same machine). This query takes 8 min to run. Every operation I am doing on this solution I get the popup 'Microsoft Visual Studio Delay Notification' and then need to wait a few minutes to do any other operation like navigating to other task block.......! My feeling is that this solution is somehow defected. Any way to check it? I will provide any needed info. Uzi

The task that takes the most time is a simple view that extracts data from a local DB (DB located on the same machine). This query takes 8 min to run. Are you using BIDS? In Help, Installed Products, you should see: SQL Server Integration Services SQL Server Analysis Services SQL Server Reporting Services What is @@version from SSMS Query Editor? Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Hi, The SSMS version i am using is: Microsoft SQL Server Management Studio 10.0.2531.0 Microsoft Analysis Services Client Tools 10.0.1600.22 Microsoft Data Access Components (MDAC) 3.85.1132 Microsoft MSXML 2.6 3.0 5.0 6.0 Microsoft Internet Explorer 8.0.6001.18702 Microsoft .NET Framework 2.0.50727.3615 Operating System 5.1.2600 Does SQL Server Profiler is a free tool or i should by it?

Hi Uzi, I believe you are using BIDS (Visual Stuido) to execute the package. Could you try to use DTExec to execute it and see whether the problem still exists? 1. You can find DTExec.exe at {Microsoft SQL Server Folder}\110\DTS\Binn\DTExec.exe 2. Open an command line, cd to the folder and run command: DTExec /f "{your package name.dtsx}" You can find more detail about the DTExec utility at http://msdn.microsoft.com/en-us/library/ms162810.aspx if you are interested. Thanks, Rodge

What is the result of SELECT @@version when you execute it in Management Studio. SQL Server Profiler is on the Tools drop-down menu in Management Studio.Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Hi. Maybe your package is several big, about 2mb of size in a DSTX file is a big work to parse. Note that this files are xml inside, and this traslate in workload to show the design of control and data flows. If in addition the package contains some data sources and it try to validate the query, more workload. Test create a new and simple package, with a table source instead a view or complex query and counts the time to load. Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it.

Hi, The version is: Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Hi Victor, The file Package.dtsx size is 786KB.