Sean Lange (6/19/2014)

---

GF (6/19/2014)

---

Thank you Craig and Sean,

The problem was user error.

There were in fact no duplicate but at the time I was certain there were.

I was at the end...

should work:

SELECT customer_id, CONVERT( INT, po_number), COUNT(*)

FROM customer_po_numbers

GROUP BY customer_id, CONVERT( INT, po_number)

HAVING COUNT(*) > 1

Replace @testdata with your column name and you should be good to go.

Like this?

DECLARE @testdata nVARCHAR(255)

SET @testdata = N'Update record GUID{1231jk-2322yy-2883487-dhe33}'

SELECT

SUBSTRING( @testdata, CHARINDEX( '{', @testdata) + 1, CHARINDEX( '}', @testdata) - CHARINDEX( '{', @testdata) - 1)

Are you looking for LTRIM/RTRIM for whitespace trimming, or some form of SUBSTRING() manipulation to grab the center of actual text? We'll need some more details to help you...

Well... better yes.

More understandable? Hrm. Hold that thought.

*wanders off...

What is the expectation for you moving the data twice? That's...

I have no idea how that could even run without an error stating T3 and T4 weren't defined.

If you yanked it out of context, it's probably something like this:

tblA

LEFT JOIN...

This just dumped off the deep end from the original question.

Paraphrased, first question: "How do I snapshot replicate a database on another server the quickest and most effective way repeatedly?"

With...

Heh, I don't mark up when someone tags me...

The Configuration Table can't be used for detection because Configurations can be re-used between packages. You can't rely on it.

There's really no way around it, you have to either...

A lot of smaller companies are trying to tighten their purse strings, thus the drive towards the open source items. The new tech is also nice and shiny.

DBD vs....

Any chance one of y'all with inroads to the powers that be at RedGate could get someone to update the spam filters on the site for the duration of the...

imani_technology (6/13/2014)

---

We are working on a new ETL process using SSIS 2012. As a first step, we want to extract data from a source SQL Server database into a...

Why does it matter?

I ask because a project for SSIS is basically just a container to allow for packages to be ran for debugging.

You *can* use shared Data Sources, but...