A Transformation Script Component in your Data Flow Task should work fine. This article explains the technique well in that it creates two output streams, one for rows containing numeric...

But you do have access to read the SQL that is run. You can setup an Extended Events session or a Server-side Trace to capture all SQL statements issued against...

Milton, John

Do you have logging in place that tells you exactly which task (and command) is executing when it begins hanging?

Are you using File System Tasks or some other method to...

kramaswamy (12/13/2012)

---

Interesting - so for cross-database calls, this approach will not work? In which case, what will need to be done - the calling login will have to have access...

peter-661823 (12/13/2012)

---

Thanks for Reply

I looked at the growing Events as told in the link, with the script

ECLARE @path NVARCHAR(260);

SELECT @path = REVERSE(SUBSTRING(REVERSE([path]), CHARINDEX('\',...

That is not likely to help. All server logins automatically get a database user created...

tempdb can also grow due to maintenance jobs, e.g. if CHECKDB spills. Have you established a timeline when tempdb does most of its growing? If it is happening during a...

I use option 2 all the time using a login-less Database User. This way the procedure executes as a Database User with elevated permissions but no one can ever connect...

aaron.reese (12/12/2012)

---

Hi guys,

I have an SSIS package that currently bulk inserts 21 files using SQL Tasks that all call a stored proc. The sp takes 5 variagles (db, schema,...

There are lots of reasons why an SSIS package can hang. The fact that when you kill the job yet the instance of dtexec.exe persists means you have something going...

This SSC article covers this topic well and shows both the window function method and the cross apply method:

Returning the Top X row for each group (SQL Spackle) by Dave...

There is no one-size-fits-all collation. If you are asking because some of your characters appear to have been eaten by SQL Server and replaced with question marks when you store...

opc.three (12/12/2012)

---

This response from Jonathan Kehayias to a similar question talks about possibly using a technique where we would capture the "sqlserver.lock_acquired event with the sqlserver.sql_text and sqlserver.tsql_stack actions" which...

It would be advisable to create User-defined Database Roles, add your Database Users to the Roles, and only grant permissions or Fixed Role Membership to those Roles. The Roles will...