I am not seeing a Power BI forum on this group. Is there one and I'm just missing it?

One of our Devs has a question. He's trying to get...

SELECT base_object_name
      ,DBName = PARSENAME(base_object_name, 3)
      ,SchemaName = PARSENAME(base_object_name, 2)
      ,ObjectName =...

Sure. Something like this (untested) should do it:

            for (int i = 1; i <= 632;...

Please explain why it's "not really the solution".

Easy. Use PARSENAME():

SELECT base_object_name
      ,CONCAT(QUOTENAME(PARSENAME(base_object_name, 3)), '.', QUOTENAME(PARSENAME(base_object_name, 2)))
FROM sys.synonyms;

• This reply was modified 3 years, 11 months ago by Phil Parkin.

Sounds like you need to add a loop to your C# code. Which part of the process are you having trouble with?

When you say that you get half the rows, have you verified that it is the first 50% of the rows in the file? Or perhaps it is skipping rows?

Another...

• This reply was modified 3 years, 11 months ago by Phil Parkin.

Hi

Thanks for the replies

I can run the package from a catalog on the server so I think the path is correct I the package for the server.

There does sound...

This sounds like something SSIS would be good for.

You can avoid that error by modifying your SELECT:

SELECT TOP (100) PERCENT ...

Upgraded from an Access 2010 ADP database, linked my tables, but I can't connect to the server when the main module is loaded.  Can't figure out the change in...

Probably, but how can we write a solution for you if you don't provide DDL, sample data etc?

Phil:

Happy to comply, but I'm not sure I know how to do those things.  I will try to figure it out.

Other sites have controls for these things, which I...

• This reply was modified 3 years, 11 months ago by Phil Parkin.

You've been here long enough to know about

a) Putting T-SQL code in a code block and

b) Providing data in a consumable format (which can be pasted into SSMS)

What results do you get when you run that?

• This reply was modified 3 years, 11 months ago by Phil Parkin.