Viewing 15 posts - 7,651 through 7,665 (of 59,072 total)
I have to admit that I foolishly used the MSDB method (i'm no ssis expert, but i'm the best we have at our company) and...
February 28, 2020 at 11:15 pm
I think we went backwards...
I especially agree with that sentiment.
February 28, 2020 at 7:47 pm
Personally, I'm REALLY happy that the whole world hasn't adopted EDI. IMHO, it's another hierarchical nightmare of data that's even worse than things like "packed decimal".
This is what I'm talking...
February 28, 2020 at 7:06 pm
I got it right only because I mentally limited the question to "typical documented" methods. It's also why I hate tests. It's like asking the question of "Which is the...
February 28, 2020 at 4:40 pm
Hi,
I have a 80 character piece of text that I wish to convert to a table structure that represents that data.
Is there a simple way to take those 80...
February 28, 2020 at 4:09 pm
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for...
February 28, 2020 at 4:01 pm
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone else.
In...
February 28, 2020 at 3:53 pm
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone else.
In my...
February 28, 2020 at 3:47 pm
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone else.
In my experience it's...
February 28, 2020 at 1:46 am
I don't think things overwrite, but if you give a URL to the post, we can remove the attachment.
I recently did the same thing and can confirm that things...
February 27, 2020 at 8:30 pm
Is this coming to you in a file?
You beat me to that question, Lynn. If it is (and I think this is where your going with this), we can...
February 27, 2020 at 8:26 pm
How to you get 26 different columns from the string
'BSNC001481905191912080000001 PEE5P01 124650005 EMU 090D P'? I see 6 at most. Where are the other 20 coming from?
Fixed field...
February 27, 2020 at 8:19 pm
I was looking at native option. So you saying using sql server native method data masking can be done from SQL server 2016 onwards?
If you look at my definition...
February 27, 2020 at 12:34 am
Absolutely agreed. To me, the term "mask" or "data masking" actually has nothing to do with changing the underlying data. It's a poorly chosen term (IMHO) except when it's used...
February 26, 2020 at 11:46 pm
Viewing 15 posts - 7,651 through 7,665 (of 59,072 total)