I'm not guite sure what you're referring to when you say that you don't see EXEC(@MyString) in the proc.

Are you saying that it should be there and that's why...

VIOLA!! Using the Hex for the ROWTERMINATOR did the trick. It's now importing correctly.

Thank you for all of your responses on this issue. I've been at this all day!

Ronnie

Thanks to everyone for your input on this issue of mine. A lot of good information. I'll probably follow up with what I finally used to accomplish my task!

Thanks again...

This is pretty slick. I wouldn't have thought to use variables to store table information.

In looking at your post, it appears that you are copying the same data from...

Thanks Jared! You make some valid points. I think is does make sense to approach it that way from the aspect of one database...

Thanks again!

Ronnie

Hi Jared,

Thanks for the response.

Basically, my group supports a tool called SCCM and from time to time, we will develop a process to improve on a specific function. So,...

Thanks Johan for that great information. I'm sure there will be a few extra steps involved with getting this going. It's always good to hear about the pros and cons...

Thanks Babu for your input. I appreciate it!

Thank you all for your input on this and my apologies for my poor "Posting Data Etiquette" - another learning experience.

Just as an fyi - all three suggestions worked fine...

Thanks Chuck! I never thought about that. I'll give that a try and let you know.

Yes, there is a system level backup but I'm not sure what time it starts. I'll have to check on that. But we're not running any agents that backup the...

Thanks Ray!

Thank you all for your help and suggestions. This is good info. I am researching the functions that you've suggested to get a better understanding and will now add them...

I haven't found a solution yet for it. I would imagine that there has to be one. Even if it meant manipulating the .rdl file but I don't know what...

Geez...

Is that a bug or just a limitation? I can't believe they (MS) didn't account for that.

Thanks for the info!!