@tencenturies. It does work. I'm not certain why it wasn't returning properly when I was running it in phone app earlier this morning. I thought for sure I had syntax...

@tencenturies. I initially had a query similar to the one you have posted. ID is an identity column, so Group By ID doesn't work quite right.

This Code below works...

Hi Shawn,

That's the problem right there. Don't know how many times I looked at sp_helpuser last night, and never saw sp_helpgroup right there under my nose.

I created two new...

I'm working on SQL 2005 SP3 servers. Based on what you wrote I may have more concerns than I thought.

What columns do you get when you run sp_helpuser and...

Thanks for the info. I'll put in my vote, and hopefully we can get a resolution or workaround.

In the meantime, I will continue to search and test for a way...

DB_Newbie,

I wondering if you ever found out more info on this issue? I'm seeing the same issue.

bph

That's the path I have taken today and I need to do some fine tuning on getting the matches to hit more frequently. Thanks for the reply.

DBA Cabuloso,

Thanks to everyones replies above. It helped a lot.

This is what I did when I arrived at similar place as you.

Once BIDS is open, select File, New...

Answered my own question by going back through Module 5 Lab A from your SSIS calss a few years ago. The MarketingMailingAudit table provided the clues.

All the best, Brian

Hi Brian,

In your log table, how did you get the first column to insert the timestamp? Trigger?

Thanks, Brian

Huron Chicago

Success. I went through all 82 columns and set the output datatype and length for each column to match the table and data dictionary specs. I thought the engine would...

Thanks. First the data flow component.

Flat File Source (csv) >> Row Count Transform pointing at table in db for row count audit>> OLE DB DataSource pointing to db and...

As a former student of Andy's at End To End Training, I have implemented several of these pieces into my daily routine. Although the word "Routine" evokes for some a...

I don't see any issues with thus far, although all my file versions indicate 3050. I would expect to see 3200 if the service pack applied correctly. It said it...

Mark,

Awesome job!! With Count_Rows did the trick.

Thanks for all your help. enjoy the weekend.

Brian