Thanks!

This should remove some confusion.

The proc and it's TVP already exist.

The proc is a massive 1000+ line beast that does heavy processing.

The exising call to that proc is old vb...

thanks!

I am testing out OpenRowSet.

One problem I am having is permissions as the the files are on a share.

What permission do I need to give to the share? The account...

Unfortunately, the people that will be dropping these files are comfortable with excel and asking for a tab delimeted file (I know it's as simple as "save as") will be...

I'm sorry, I don't believe I understand what you are trying to say.

If you are asking why I want to turn that validation when I open a package to continue...

Thanks!

Hi

No execution.

When I open the package, in the bottom left corner of vs it reads "validating blah..."

The more items in there the more it has to validate which is where...

I'm going through a problem executing from ASP.Net myself.

This is just a guess, but under the connection objects did you set the expressions to the variables?

I hope I didn't offend...

Thanks a lot.

That was the code snippet I was loking for.

I am dissapointed that the file must be created first.

BCP is superior to the OPENROWSET method in this respect.

So...

Hi

Although that is correct, it is simply manual.

I need to eventually wrap this in a proc.

I finally was able to generate a working format file with the bcp.

I have...

Hi

So you are saying that the particular email account I am using is unable to send outside the domain?

I just ran a test, put in my email address and still...

So if I change the account that the SQLAgent runs under will that effect anythign else?

Also, I did try to change the account to a working domain account.

The service would...

That's great. It helped me out a lot.

Does anyone have any info/styles/code/opinions on how to retrieve on the other end?

Specifically how to parse this file into variables in VB.Net?

Thanks!

Turns out the database itself is Advantage.

How about that one? Anyone heard of that?

Geesh. Where do people get this stuff?

Thanks again.