Thanks Ron. You stated your mail problem in the first sentence in your first post. "The Analysts I work with created tables...". Let me guess, they added...

Hey Ron, it looks like you've had quite a few reads on your post but no one has ventured to answer your question yet. It may help everyone if...

I don't see where you are adding in a carriage return/new line into the variable. I think you're missing something. I do quite a bit of email message...

It's hard to tell without knowing how your two tables are related. Can you post the table DDL and also mock up the sample data that matches your desired...

I totally agree Martin, in fact, I thought I had put it into my last post. When possible, adding/embellishing the facts/dimension in ETL would be the best approach.

It really depends on whether the OP needs it as a measure or a dimension member. The original post made it sound like an extension on the dimension. ...

These date values are in your dimension? I'm assuming you are OK with the Lead Time value being a dimension attribute? If so, replace your table in the...

I prefer changing the delimiter also. Adding quoted identifiers is nice, but then you have similar issues when you have commas and quotes inside your strings. I've see...

Jez-448386 (4/4/2016)

---

As Jeff said, SSIS might not be the best tool for this but you can achieve this using SSIS and without a script task.

1. Create a new SSIS...

Couple of things I see you're missing. Your join to Selection needs to limit by user and also, your check for non-existence for selection needed tweaked. Also, the...

Thanks Colin. I may have to try elevating my service account's permissions to sa, but I'd rather not as I'm pretty sure my hand will get slapped. Besides...

Are you trying to create a temp table? The #prefix in front of your table names makes them temp tables...

Anyways, if you need to create a table from a...

You can use Job Categories to group them. They will not appear grouped in SSMS, but when you view the jobs via the Activity Monitor, you can sort them...

Can you post what you've attempted already? How about sample rows of data to go along with it? Is there a specific problem that you've encountered while trying...

We had issues when we began importing from Oracle while using the Attunity drivers. You have to have both the 32 and 64 bit drivers installed on your machines....