Solved

SSIS process task for bcp hang

Posted on 2011-03-14
2
943 Views
Last Modified: 2012-06-27
I'm not sure why, when I run bcp within Process Task in ssis, it just hang without any result, any idea how ?
0
Comment
Question by:motioneye
2 Comments
 
LVL 11

Accepted Solution

by:
rajvja earned 500 total points
ID: 35126997
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 35128280
you should run PROFILER on the process and trace its activity
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Download ms sql express. 2 26
SQL USE DATABASE VARIABLE 5 27
SQL Quer 4 21
SQL Find Carriage Return and Delete it. 3 11
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question