Viewing 15 posts - 31 through 45 (of 157 total)
January 3, 2019 at 8:58 am
December 28, 2018 at 12:30 pm
You can start here:
https://www.mssqltips.com/sqlservertip/4165/how-to-read-data-from-multiple-excel-files-with-sql-server-integration-services/
This will show you how to create a loop that will look into a folder and import the file(s) it finds in that folder...
December 26, 2018 at 9:14 am
Your best bet is to create a separate data source and destination in SSIS for each Excel file. Populate two staging tables, and then combine them in SQL either by...
December 24, 2018 at 12:37 pm
If you're using SQL Server then LISTAGG isn't going to work because that's an Oracle function.
If you're using SQL Server 2017 or Azure, I think you can use...
December 20, 2018 at 12:48 pm
September 12, 2018 at 3:35 pm
September 12, 2018 at 1:44 pm
Eddie --
I was under the impression that you could only restore to a higher level if you were in recovery mode... ours all need to be in standby...
September 11, 2018 at 7:59 am
Go into report properties and make sure the width and height properties are set correctly to the page size you want... and make sure that you account for your margins. ...
May 4, 2018 at 2:47 pm
Joe Torre - Monday, February 26, 2018 10:01 AMSo create logins for al the groups in the domain
That's actually one of the...
February 26, 2018 at 12:45 pm
It does... but unfortunately it only seems to work if the AD group has been created as a login on the SQL server... I need to do all of the...
February 23, 2018 at 3:34 pm
You need a table alias after that last parenthesis. You're creating a derived table there, so it needs an alias.
Also, you're going to get an error from that...
July 10, 2017 at 9:06 am
Hello all,
I ended up implementing the trigger below, and for the most part it seems to do exactly what we need it to do... but there is a...
June 12, 2017 at 8:04 am
Viewing 15 posts - 31 through 45 (of 157 total)