The error messages mention Teradata and Attunity, so I am assuming that the packages have one or more connections to a Teradata database.

Such connections are not natively supported in SSIS...

Made me laugh. Hope it was deliberibiberate 🙂

Lynn Pettis (9/27/2016)

---

ScottPletcher (9/27/2016)

---

Lynn Pettis (9/27/2016)

---

ScottPletcher (9/27/2016)

---

So you want to go from DBA-level SQL...

You should consider making some changes, to open things up and get closer to best (or at least, 'rather good' :-)) practice:

1) Use the project deployment model, to deploy your...

Have you got the Attunity SSIS Connectors installed on your local PC?

Dynamic table names in queries require the use of dynamic SQL.

I'm not sure whether you think that you've provided...

shanegair (9/27/2016)

---

I have a table that houses inventory data by Warehouse, item and a lot#. If a item is a random weight item it includes 2 records one for lbs...

Adding Rows in Incremental Loads - Level 3 of the Stairway to Integration Services[/url]

Updating Rows in Incremental Loads –...

As SSMS now uses the...

Spiff (9/27/2016)

---

--

If you absolutely need to validate the format then SSIS expressions are rubbish and the best way is to use a Regex's in a script task. Good article...

Redirecting any errors on INSERT...

Try to solve the various T-SQL problems that other people post here ... and compare your solutions with those written by others. You'll learn a lot if you take the...

Brandie Tarvin (9/27/2016)

---

SET RANT Brandie ON;

I just spent the past week working on a bug fix to get into our production systems before month end. Last night, after I leave...

Thanks for posting. I just tried it again and it seems to have gone away, thankfully.

13.0.15900.1.

Having my environment settings reset every time I get a version update remains irritating, however!