?
Solved

SSIS process task for bcp hang

Posted on 2011-03-14
2
Medium Priority
?
952 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 2000 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

607 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