Skip to main content
Question

Using Bulk Insert in a dataset for a report.


Forum|alt.badge.img+3

I need to create a report that management can use, that compares server data in another database, to server information in Commvault.

Unfortunately, I can’t get access to the other database, and need to run a report against it, and save the results into a tab delimited file.

Using this, I have the SQL set up to bulk insert the data into a temp table, and do what I need to get information from CV, based on that data.  Runs fine.

However, when I try to paste it into a dataset in a report, and “Preview” the data, prior to saving, I’m told that I don’t have permissions to bulk insert.

It appears to be a jdbc error, so I’m assuming they are running java in the background.  I can find what I need to add to a java connection, to allow bulk insert.  However, I have no access to the background java.

 

Does anyone know of a way to allow bulk insert in a web console report?

3 replies

Forum|alt.badge.img+11
  • Vaulter
  • 115 replies
  • October 8, 2024

@Billyg03038 - what user are you using to load that data? I suspect you need to grant bulkadmin role to that user in SSMS.


Forum|alt.badge.img+3
  • Author
  • Bit
  • 5 replies
  • October 8, 2024

I’m using bulk insert.  It works in SMSS, as I have the bulkadmin role.  The problem is when I try to use it in a report.  There, I don’t have permssions.  It does show it as a jdbc error, so I’m thinking they are using java in  the background.


Forum|alt.badge.img+3
  • Author
  • Bit
  • 5 replies
  • October 8, 2024

Ah… I believe I found the issue.  Had bulk insert for sqladmin_cv, but not sqlexec_cv...


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings