Error using bulk Insert on a comma delimited file

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Error using bulk Insert on a comma delimited file

Author

Topic

Trudye
Posting Yak Master

169 Posts

Posted - 2008-03-18 : 06:58:54

I am having a problem using the Bulk Insert task. I am getting the msg:
SSIS package "Package.dtsx" starting.
Error: 0xC002F304 at Bulk Insert Task, Bulk Insert Task: An error occurred with the following error message: "You do not have permission to use the bulk load statement.".
Task failed: Bulk Insert Task
SSIS package "Package.dtsx" finished: Success.

I have been granted ownership of the database. I also tried in one of my old databases that I just finished
developing and I got the same msg.

The file I am importing is comma delimited. I am importing it into a table that has 50 bytes allocation for each field (the max input field size is 40 bytes).

The connection is solid;
Format = “Specify”
RowDelimiter = {CR}{LF}
columnDelimiter = Comma {,}

No other options are set.

The data looks like:
"tstLName","tstFname","000 N Tst DR","IDAHO sp","ID","00000000",

Any ideas why I am getting this message?

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2008-03-18 : 09:21:13

I have been granted ownership of the database. I also tried in one of my old databases that I just finished
developing and I got the same msg.

You need sysadmin or bulkadmin permissions, refer to:
http://msdn2.microsoft.com/en-us/library/aa225968(SQL.80).aspx

Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.