halifaxdal (9/3/2015)

---

I found the issue:

The data row contains comma in one of the column, which makes the bcp thinking it is a delimiter.

Maybe I need to re-generate the data by...

Include the max errors option with a large number that will be enough for all the errors.

Don't remove the -e option so you can troubleshoot the problem later.

-m max_errors

Specifies the...

The version is repeated in the format file. Delete one of them.

9.0

7

1 SQLCHAR 0 128 "," ...

It could be with something like this:

CREATE TABLE numerator(

memberid int,

measureid int

);

INSERT INTO numerator

VALUES

(1,501),

(1,502),

(1,503),

(2,501),

(2,502),

(3,501),

(3,501),

(3,501),

(3,501),

(4,501),

(4,502),

(4,503),

(4,504),

(4,505);

SELECT memberid,

measureid

FROM numerator

WHERE memberid IN...

If you appreciate your sanity, avoid it. I didn't :hehe:

Welcome aboard! I hope that you'll be able to learn a...

Your format file is still wrong, and this is because you create it from the table instead of creating it from the file. The file doesn't have the id column,...

I usually avoid the money data type because it has some weird rounding issues. I prefer to use decimal in general. You can google for advantages and disadvantages on both.

Here...

I'd use the InsertSnippet option. That's precisely the functionality that snippets have.

You just need to create a new template.

Your problem was that the table didn't match the file.

I suppose that that's what you found out (or maybe something we couldn't see).

I suggest you to read the following article...

I would still encourage you to learn how to do this in Powershell or SSIS (DBAs prefer PoS, Developers usually go for SSIS). This will give you additional flexibility and...

You're welcome. I hope that you had finally understood the code and what does it do on each step.

It would be "estoy". Use "estar" for something that denotes a temporary...

No, you should call [spTryOut] from [spTryOutCreateFile]. That's how it's coded.

[spTryOut] will return...

This isn't a natural thing to do, but you should be able to get it done.

I might not have been very clear, but you need 2 stored procedures. One...

Judge

I've seen that Prompt handles snippets in a wonderful way. I know that templates have been available for a long time, but I'm not sure if you could create custom...