Rechana Rajan (9/28/2016)

---

Phil Parkin (9/28/2016)

---

Rechana Rajan (9/28/2016)

---

The transaction is not getting commited or rollback when run in different db. The execution might throw error but its not commiting for below...

Rechana Rajan (9/28/2016)

---

The transaction is not getting commited or rollback when run in different db. The execution might throw error but its not commiting for below

BEGIN TRY

...

quinn.jay (9/27/2016)

---

Phil Parkin (9/27/2016)

---

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...

quinn.jay (9/27/2016)

---

Phil Parkin (9/27/2016)

---

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,...

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...