Thanks so much!

I actually had to get this done a couple hours ago, so I dusted off my old RegEx skills and reformatted the properties node to look like a...

Thanks GM.

Please check my edits: I've made my question a lot simpler

What I'm really wondering is ... are there any changes you'd recommend, either to the way tblPerson view...

Okay, got it all imported, and the script you provided worked a treat Wayne. Chrissy, exact right call, I just had to import to .dtsx instead of the db...

A-Ha!

Yes, I did import them into the database. I see how to change the destination in the Wizard, so I'm going to try that now.

Hopefully that's the missing piece...

Thanks Chrissy ... I think Wayne's script does exactly what I need to do here, I just need to get the packages in a state such that they're 'available' to...

Awesome Wayne, thanks for the code :w00t:

I'll definitely be giving this a try today and report back.

Thanks Again,

Brett

EDIT: Okay, it looks like I have a problem ... perhaps a serious...

Bump for more help from Wayne 😀

Thanks Wayne.

That sounds like a great solution.

Is there any way I could trouble you to expound a bit upon this methodology? I've used Bulk Import in procedures that import...

Nevermind, I figured it out ...

Create function fnXample (pk int)

returns xml

as

begin

declare @xml xml

select @xml =

(

select * from foo

where pk = @pk

FOR XML PATH ('bar'), ROOT ('foo')

)

return @xml

end

;

And...

Unfortunately my requirements are rather specific and not entirely up to me.

In it's most basic form, here's my question:

Given the following stored proc:

create proc spXample (@pk int)

As

select * from tblFoo...

If you're talking to me, my handle is bvaljalo, not grasshopper.

And to be honest, I dunno what is going on with your problem. Does BOCLEARED live in the ROCAP...

Your solution is exactly along the lines of what I was thinking was likely necessary to pull off what you're trying to do.

To be totally honest, I'm kinda thinking a...

I'm thinking the problem here isn't so much the necessity for a literal in the contains table 'function' (for want of a better word), but it's more of basic SQL...

= MID(Fields!PhoneNumber.Value, 3)

No your database name is not the table name, its the database name. Your SQL Server has a name (the name of the Server itself on your network), and...