471,089 Members | 1,682 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,089 software developers and data experts.

BULK INSERT Help needed bad!

Morning all,

The following cmd says it executed but no rows appear in DB table.
I am running this cmd in QA on the server. The data file is on the server too.

BULK INSERT dbo.TBL_Master_DoNotCallList_Loader
FROM 'E:\SqlServerBackups\National Do Not Call List\VT_31_8_2006.txt'
WITH (FIELDTERMINATOR = '~')

Data looks like this:
8022028492~8022171040~8022172021~8022211006~802221 1017~8 ect

This is what QA comes back with: The command(s) completed successfully.

What am I missing here ?
Thanks
Deasun
Sep 5 '06 #1
2 2252
Never mind.
Found out our test server has problems.
Production server ran cmd no problem.
Sep 5 '06 #2
Never mind.
Found out our test server has problems.
Production server ran cmd no problem.
Hi,

I just got the same problem on my test server which used to work just fine.
Just wonder whether you did discover the root cause of the issue and how to fix it?
I re-patch the SQL instance with SQL service pack 4 but did not help...

Thanks,
John
Feb 17 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Jim Geissman | last post: by
5 posts views Thread by me | last post: by
20 posts views Thread by akej via SQLMonster.com | last post: by
6 posts views Thread by pk | last post: by
16 posts views Thread by Philip Boonzaaier | last post: by
1 post views Thread by Metal Dave | last post: by
reply views Thread by m31hu1 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.