comment on

The data type for at least one field is too small for the data you're trying to import. In your code, verify the data type (and length) with the data you're trying to import before you attempt to insert it.

I've done that. All columns are varchar(50), date, or decimal(18,2) and I've tested the command in sql management studio and line 1 inserts, but not line 2. I've included the actual data being passed (in the form of the print output) in my OP.

...why aren't you just using bcp to import your csv file?

Because this was SUPPOSED to be a quick script to get going. I have an existing script somewhere else on another server. Theoretically, I should just be able to copy/paste, change a few variables, and done. But no.

In reply to Re^2: DBD::ODBC insert first line, but not line 2 by ksublondie
in thread DBD::ODBC insert first line, but not line 2 by ksublondie

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


good chemistry is complicated, and a little bit messy -LW
	PerlMonks