Within the SysInternals utility you can filter the output on a folder, the file handle will show up there during the Data Flow task execution. The question is whether SSIS...

Quick thought, grab the SysInternals utility which shows open files, cannot remember the name but should be easy to find. It will show if any process is accessing the file....

Duran (8/29/2014)

---

Thank you for reading and responding so quickly, Hmm, I'd have to check, but I'm fairly sure it's 2008 r2 64bit, I can confirm and come back Monday. Have...

Quick question, what SQL Server version are you on?

😎

Quick question, are you on SQL Server 2008 (not R2) 32bit?

😎

Quick suggestion, count each table content in a separate CTE and join them for the combined results

😎

USE tempdb;

GO

/* Test data */

WITH SYNCHMESSAGE (M_KEY,M_MSG) AS

(

SELECT

...

Evil Kraig F (8/28/2014)

---

Check to make sure your schema information is matching. I usually see that happen when I forget to slap dbo. onto the table name in the...

In my opinion, setting the actual port number for each instance should be avoided unless absolutely necessary. Leave this to the SQL Server Browser Service

😎

Here is the first part and the goal of this part is to improve the yearweek table which then allows us to do a direct join to it rather than...

Quick thought, isn't Merge Cells what you are after here?

😎

The code fails because the first character in the Pattern sequence is NCHAR(0). Any usage of the string will recognise this as the end of the string, truncating the string...

smart_analyst (8/28/2014)

---

I have created a my first SSIS package where I am using Execute SQL task and trying to run a simple select query.

I am using one input variable school_name...

sqlfriends (8/28/2014)

---

But sometimes those databases need to work with different SQL server versions.

For example some retired db is at version 2000 and only works with 2000, some with 2005 etc.

So...

Some good points you make there Steve, thanks!

But now a days computers are such a robust stable platforms, with such a stable reliable storage media, used by very competent and...

Quick thought, my preferred approach would be a named SQL Server instance, normally SERVERNAME_OLD. Kind of in line with Jeff's suggestion. Reason being that normally there are more than one...