Maybe try installing the Integration Services extension again, while running VS as Admin.

TrustServerCertificate=True is the setting you need. Or something like that ... I'm not at my computer right now.

You are the one asking for unpaid assistance, so we should not have to 'meet you half way', in my opinion.

I have made it very easy, gave data in more than one format. Its you guys that makes it difficult. Your all full of nonsense! What more do you...

If you try running your own code, you will find that no values get inserted into your tables. Not that useful to people who are trying to help you.

Please Only assist, if you want to. I don't need the negativity from the regulars who troll this forum only to attack those that are seeking help.

Are you suggesting that...

We can't tell from what you've posted.

No idea what a 'restraint' is. Constraint? Restriction? Something else?

Post some consumable sample data which highlights the issue you're seeing, so that we can...

thanks everyone for the suggestions

Its working with IP and comma. thanks. but still it fails with servername and comma ? any comments .Its a default instance and the only...

After all that coaching...

Have a look at my second post in this thread, for example.

https://www.sqlservercentral.com/forums/topic/sql-server-count-query

• This reply was modified 1 year, 3 months ago by Phil Parkin.

>6,000 points and can't be bothered giving us consumable data?

Eirikur, many thanks for the offer.

Excellent timing on your part, by the way, as I solved my...

Would anyone be prepared to help me with a few (seemingly) simple DAX questions?

I've been reading up and searching for answers, but can't seem to find the right way to...

I build and maintain databases using VS projects, but have configured VS to open .SQL files in SSMS – so a combination of the two.

I agree 100%. It has the...