Our fix was to rollback the version of Symantec and remove NTP (network threat protection). This seems to have stopped the file locking issues and unstoppable SSIS packages.

MWise

Bids runs fine or at leastwise stops when you request it to. Running in 64bit still results in the process hanging and the DTExec process not stopping when the...

Yes there is logging and it clearly hangs on File System Tasks either native or written as a Script task. The most recent time was when it was hanging...

There is no Office automation going on. The packages are pretty standard: FTP task to download, File load to SQL Server in standard data flow task, File Copy...

Michael Meierruth (11/8/2012)

---

So in those several thousand cases what do you see as the main cause of these corruptions. It's ovbiously something bad at the hardware level. But what I'm...

We use an environmental variable too to point to the configuration database. It's a pretty cool method.

Right now for your problem you might want to look into...

cmcc (11/1/2012)

---

OK, I doubled up on the slashes within the path, and put four slashes at the beginning to indicate the UNC path. My expression evaluates to this.

\\johnson\clientFTP\users\UBM\ATOM\GEN_V2_DAT_ENT_IUXA9_PRE_20121101_888888.txt

I set the...

Instead of a loop, I'd say it's more like a pipeline with the records flowing through each component in the data flow task. Check out the 2nd article in...

The For Each loop is used for things like looping through a set of files in a folder, or a list of records from a table usually for some sort...

Try putting your sql statement in a view and then select from the view in the BCP statement.

MWise

danielfountain (10/16/2012)

---

Apart from the other stuff that has been said i would also suggest that from what i have seen the number one cause of the log file becoming big...

If you are doing data driven subscriptions, then you have to have Enterprise edition. You can fire a subscription to run right after the package finishes. IIRC you...

Lee Crain (10/3/2012)

---

GSquared,

One more thing: I would sit in on the technical interviews to observe the candidate's demeanor when answering questions. Observations of body language can often reveal things about...

You might just be able to use a CASE statement to determine which datepart to use in your DATEADD:

select todo_date, CASE interval_type

WHEN 'day' THEN DATEADD(day, interval_freq, todo_date)

WHEN 'month' THEN...

1. Load the full file to a staging table.

2. Then use a SQL task to populate a recordset variable using a "SELECT DISTINCT CITY_NAME FROM StageTable"....