Thanks debasis.yours

Jeff Moden

Oh, I googled fnTally right away. The approach is great. I would definitely use it for creating random number values. And probably will. Though I need to deal with...

pietlinden

This should work for sure.

scdecade

I believe that's exactly what I was looking for.

Jeff Moden

Well, just random strings is not exactly what is needed here (if this is what you supposed...

Thanks Phil Parkin again. I'm not big fan of Microsoft products in general. Just open to work with any type of database. SSIS usage is just side effect of my...

Thanks Phil Parkin, it works fine with variable of 'Object' data type.

I must say, error text is not intuitive at all.

Ok, now additional requirements from customer. They need to set connection string in .conmgr file and put variable there instead of hardcoded value, so that they are able to set...

frederico_fonseca, thanks again for your reply. My assumption regarding small companies was wrong.

what you can do is change the connection string parts or in full (full preferred) (server name, database...

Hi frederico_fonseca, thank you for your reply. Actually I can explain this to my management and they would probably accept it as useful information. I believe your advise is great...

Hi Jeffrey Williams,

I believe your reply is helpful indeed in general, though this is enterprise customer with a lot of peculiar policies and it doesn't work in this case just...

Thank you for all your replies.

Well, stage SQL Server is the only software that works on that machine (I installed it, so I know what is going on). Also it...

Hi Grant Fritchey,

How do I start? I'm new to SQL Server. Please, be so kind, give me hints to begin, like path in SSMS menu. I'm using SQL Server 2017.

Thanks!

The copy database should be as much real-time as possible.

This is assignment for learning purpose.

Looking into transactional replication.

First of all, I found out that replication distributor is not available on...

• This reply was modified 5 years, 7 months ago by  marchello.