Ok, Not sure exactly why, but I did get it to work finally.

I created an SQL view of the data using RTRIM to eliminate trailing spaces in fields. ...

I do not think the DISTINCT is the issue --- I tried that to see what I would get but with or without it in SSMS the Select without...

Thank You! I will give it a try! I knew someone would understand what I am trying to do!

Yes! This is going to work beautifully -...

Would really like to see Part 3 --- need more information and the style here has been great (and entertaining!)

Thank you for the responses. I wasn't sure if there was a way to check or not. I will pass this information along to the manager that...

Wow do I feel small! I figured this out finally (after a couple weeks of trying).

This was permission related on our server. Not only did I get...

Hi and thank you for the responses.

I do only want a single instance of the job to run at any given time so thank you for the input. ...

I can do it in excel but I need to know how to call an SSIS package from Excel then??

Hi Alvin (love the gif!) ,

Thanks for the input. Mind to tell me how to do this stuff though? We would like to be able to turn on...

Thanks! I did figure out that I was referencing incorrectly but I didn't think of doing it that way, which is easier than what I ended up doing....

Thank you to all who replied.

ps - it does look like I can use the FORFILES to do what is needed - I will give this a try on Monday.

David...

Thanks for the info!

One question tho - if I change the db_owner to db_ddladmin, what will this do?

The user is not a domain user. It is a generic user found only in SQLServer so connection will require SQL Authentication. This way we can give...

Thank You Jack. Looks like I can figure out what I need to do with that blog information! I appreciate it ALOT!

~MJ

Hi all. Thank you for all the input. Last week was a super stressful week as you could probably tell. 🙂

After finding a quiet place...