Your Data File still does not much your Table definition or contain the delimiters specified in your BULK INSERT Command.:-)

Could you please post the DDL, INSERTS for Test Data, etc.

Check out the first link.

You have one column of data in your file but you have two columns in your table.

Refer to the follow URL on the BULK INSERT Command.

http://msdn.microsoft.com/en-us/library/ms188365.aspx

sql2k8 (7/16/2011)

---

Hi,

i have a table called Table a

CREATE TABLE [dbo].[TableA](

[ServerName] [varchar](100) NULL,

[DatabaseName] [varchar](100) NULL,

[LogicalFileName] [sysname] NOT NULL,

[PhysicalFileName] [nvarchar](520) NULL,

[FileSizeMB] [money] NULL,

[FreeSpaceMB] [money] NULL,

[UsedSpaceMB] [money] NULL,

[FreeSpacePct] [varchar](7) NULL,

[FileSizeGB] [money] NULL,

[FreeSpaceGB] [money]...

You are going to have to GRANT EXEC Permissions to the User Account that you are Executing the Stored Procedure from.

http://sqlblog.com/forums/thread/12431.aspx

This post was initially created over 3 years ago. 🙂

opps. Sorry.

What error are you getting?

Can you execute it interactively?

What do you mean when you attempt to create a query? Could you be more specific on what you are doing that generates the error?

That is a .NET error.:-D

I would...

opc.three (7/17/2011)

---

Reading Jamie's blog has sent my brain's CPU to 100% at times (so has reading Paul's for that matter) but my computer has never had an issue 😛

Seriously though,...

I clicked on the link to the blog. It maxed out my PC to 100%.

After cliking on the link it started several Internet Explorer Processes. I tried to kill...

Jamie Thomson (7/14/2011)

---

Koen Verbeeck (7/14/2011)

The most impressive feature for me is the whole new project deployment model with parameters (already present in CTP1). This revolutionizes the way we work with...

What is in the 240,000 row? Bad Data...

I did not know that everyone on this forum was a fellow? :hehe:

Why are you using the naming convention "tbl" as a prefix?

I don't know how many records you have in your table table you may want to reconsider the use of...