Viewing 15 posts - 16 through 30 (of 146 total)
the new SQL Server powershell module, installed by the SSMS 2016 installer, has a parameter/option for Invoke-sqlcmd to output data to a DataTable as well. It's nice, and does save a few steps.
April 27, 2018 at 9:50 am
Hmm... in my last job where I did SSIS work, we had .dtsConfig files with database connections for all our database servers and databases, one .dtsConfig file/database. They're stored in...
March 2, 2018 at 10:04 am
...or here: http://www.rlmueller.net/PowerShellEscape.htm
January 22, 2018 at 1:00 pm
Sure! If you're using double-quoted strings, be sure to double-up the backslashes:
gci "\\\\server\\folder\\to\\file.txt"
or
get-childitem "\\\\server\\folder\\to\\file.txt"
Post reply
Something like this could...
January 22, 2018 at 12:58 pm
January 2, 2018 at 6:39 pm
By definition, a flat file...
October 30, 2017 at 8:04 pm
Question... using the BIML DOM stuff (ala the BIML-emitter file), is it possible to set up the BIML code to define package configuration files to store login information for servers,...
October 3, 2017 at 12:51 am
Don't even have to go to India to try and experience this. If you live in an urban or suburban environment, it's interesting if you can somehow experience living in...
August 31, 2017 at 12:22 pm
Hmm.... at a previous job, we used config files (the xml ones) to at least deal with connections - one file per resource (e.g., server+database).
The convention we used...
July 31, 2017 at 4:35 pm
July 6, 2017 at 11:12 am
Hmm... I did it slightly crazy this way. Yes, it was all in SSIS and some C# script tasks, but I just don't like the "Import/Export Wizard" in SSMS.
...
February 23, 2017 at 3:10 am
January 25, 2017 at 6:17 pm
January 24, 2017 at 11:03 pm
January 24, 2017 at 6:36 pm
Viewing 15 posts - 16 through 30 (of 146 total)