In the connections manager for flat file source, I have a column AcqDate which I have declared as a Date. When I run the package, the package fails after processing...

Tara-1044200 (7/12/2013)

---

If its a permissions issue how could that loop make half way through hitting the same tables and database/server?

just so you know my loop iterates almote 50k times, do...

Tara-1044200 (7/11/2013)

---

I am getting this error half way through the loop container in SSIS, why would it fail connection after certain point of successfull execution?

Failed to acquire connection "server.DB". Connection...

From the reading I've done, there are a number of different scenarios that can lead to this message. I've found the following article to be helpful: MSDN Social:...

Glad you got it working. 🙂

gsmith 7350 (6/5/2013)

---

Incident Description: I can execute an SSIS package with no error using the SQL Execute Package Utility.

....

Error: 2013-06-05 12:20:44.44 Code: 0xC0209303 ...

Thanks Sean. You're right. I never use the designer. Only type. It sounded like a snippet--didn't realize the designer did something like that. 🙂

Curious. SSMS doesn't generate that snippet for me (2008 R2). Thanks for the reference. Are you using 2012?

RedBirdOBX (5/30/2013)

---

I use a few different methods of creating a view. I can Right Click on the Views folder in SSMS and simply select New View. I can...

Nice! Thanks for posting. Was just starting to tackle a situation with lead...

Here's one approach that might work.

With cte_agenttime

As

(

Select

Name0,

Agenttime

From

v_AgentDiscoveries AGD

Inner join dbo.v_GS_COMPUTER_SYSTEM CS

On CS.ResourceID = AGD.ResourceID

Where

AGD.AgentName = 'Heartbeat Discovery'

),

cte_boottime

As

(

Select distinct

sys.Name0,

os.LastBootUpTime0

From

v_R_System sys

Inner join v_GS_OPERATING_SYSTEM os

On sys.ResourceID=...

rs80 (4/3/2013)

---

The format of the variable being passed was incorrect. The variables were set correctly with evaluate to expression. Sorry for extending this post. It was...

rs80 (4/3/2013)

---

Unfortunately, it is complex. And I think it's more of me not setting up the fst correctly. Do I need to set the source and destination...

Glad to hear that you got it working! 🙂

rs80 (4/1/2013)

---

I didn't have evaluate as expression set to true for ExceptionReportName. After making that change and running the package, a package validation error comes up. "Error at...