Mark Fitzgerald-331224 (4/17/2012)

---

Matt, agreed there should be no presumption of a single ultimate parent in a hierarchy.

Answering you questions

Is it:

- node(s) which have the longest lineage -> in this case...

Thanks Mark, and I did get that part. It's just that depending how you define top-most parent, you might not need recursion at all . Having to put...

SQLCrazyCertified (4/16/2012)

---

Lynn Pettis (4/16/2012)

---

SQLCrazyCertified (4/16/2012)

---

Mike John (4/14/2012)

---

If a column is defined as a primary key, then by definition it cannot be null, so you cannot do anything to allow nulls...

Assuming you can get the ID's assigned correctly, here's the CTE with no recursion:

with startCTE as (

select ROW_NUMBER() over (order by ID)...

Just be careful with this. You will have to ensure that SSIS actually assigns the ID's in the correct order (if they're...

Are we saying "the" top level parent is the one with the longest lineage? I wouldn't have defined it that way (to me, top level parents = records where...

Rich Yarger (4/12/2012)

---

Jack, thank you for the response. The new system is still on SQL 2005, but will be Enterprise Edition instead of Standard Edition. Also - I...

If you look at the tables defined within the dataset, the table structure matching tblprod has no column marked as the primary key or the unique key. This doesn't...

You may still have a shot: JDBC and ODBC both offer kerberos authentication options to use in connection strings, as does Informatica natively (for external service calls). What I...

Note: while cadavre's code will generate a sequence number within the query run, it's not a deterministic sequence number. As a result, rows might get different sequence numbers...

With no specifics, it's going to be awfully hard to give you anything meaningful. The only insight I could give you is to identify what part of the loading...

How is excel helping you at all in this process? You'd have a lot better functionality on this if you were to keep this within Access.

As far as I...

sqldba_newbie (4/5/2012)

---

Matt Miller (#4) (4/5/2012)

---

Depending on which type of connection you're setting up, you've got conflicting instructions.

integrated security=sspi

means "use the current windows credentials over Kerberos", so then passing the...

Depending on which type of connection you're setting up, you've got conflicting instructions.

integrated security=sspi

means "use the current windows credentials over Kerberos", so then passing the user ID and password...

I would actually go one further - why not use the deploy option from within Visual Studio? You don't have to build out the scripts at all. Build...