barry.pettis (1/24/2012)

---

I'm at a loss tho... If I have a table that has a "DATETIME" column... How do I tie in this procedure? Should this be a function? I...

A couple of things to check. First, find out if your testuser is associated to any other roles. Then, double check there isn't an explicit deny on this...

Hm. 11 records that won't associate, they're...

Then we haven't seen the original, which makes troubleshooting things like this tougher.

This is the test server where we got the issue...

Microsoft SQL...

+1 for OLEDB on both sides for SQL to SQL transfers. It's simple to setup, easy to use, little difficulty in transferring it to others, and uses the native...

Ran into this myself. There's no way to prioritize multiple streams in the same data flow.

However, create two separate dataflows in the same controlflow. Use a script component...

What is the metadata type of the column with the GUID as it enters the lookup component? I've seen that end up funky before, and then it tries to...

Than FOR XML is probably best. Why avoid the easy method?

Could you gimme some samples to do this in script component..?

i am not...

For raw data copying I'd go with replication. For immediate data transfers with asynchronous transactions (ie: sending to an audit table on every update via trigger), or manipulated data,...

Laura_SqlNovice (1/24/2012)

---

The query above should have pulled Name starting with Contract for those PID and INDID, but it pulled all the records with those PID and INDID... I changed the...

Sounds a lot like the information description storage for something like CNet, or any other massive product review database. There's some free to try ones out there that you...

Jeff Moden (1/23/2012)

---

I have to ask... is a FOREACH loop in SSIS going to be as effecient as creating a result set in a stored procedure that uses FOR XML...

Charmer (1/23/2012)

---

so i need to check the ModID column for repeated ID's, so i need while loop condition in ssis rather than T-SQL query..is this possible in ssis with out...

*blink*

9/11 boat lift. Apparently it took forever for someone to document this. Half a million people in 9 hours.

http://forum.woodenboat.com/showthread.php?136581-BoatLift-An-Untold-tale-of-September-11-Resilience

You'll want to use the FOR XML trick.

This article will walk you through it:

http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/