SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
1 answer
Sharepoint online file download from SSIS script task
Hi there, I'm trying to download a file from share point online using SSIS script task. Referred the code available in below link by calling REST API. working-with-folders-and-files-with-rest However code fails with below error. {"Cannot contact…
SQL Server Integration Services
Microsoft 365 and Office | SharePoint | For business | Windows
11,716 questions
asked 2021-02-10T14:19:01.827+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 8%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGT%3C/text%3E%3C/svg%3E)
Guganathan Thirumalai
21
Reputation points
commented 2021-02-19T07:42:13.183+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 7.000000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MichaelHan-MSFT
18,126
Reputation points
1 answer
Client extracts are taking long time
Hi, In a business requirement, I'm giving an extract in text file from sql view (combination of multiple tables). This vies has more than 200 million lines with 150+ columns. I'm using using SSIS (OLEDB as source and flat file connection in destination)…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
SQL Server | Other
14,503 questions
asked 2021-02-16T16:23:58.407+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 74%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
ASHISH SINGH
21
Reputation points
commented 2021-02-19T07:27:35.82+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EchoLiu-MSFT
14,621
Reputation points
1 answer
Transfering data from one SQL DB to Another
Good day esteemed experts, We have a challenge ahead of us, being tasked with the following: We have a huge database on a server. This DB holds thousands of tables, views, etc. With years of historical data. the task is to create a more…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2021-02-12T19:53:37.54+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 95%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Edward Castro
1
Reputation point
commented 2021-02-19T07:26:54.13+00:00
EchoLiu-MSFT
14,621
Reputation points
3 answers
One of the answers was accepted by the question author.
Count members based on aggregated measure SSAS MDX
I want to count # of claims(Claim dimension) based on a measure(Case Loss). I have a transactional Fact table with the measure(Case Loss), but the value of the measure to be used in the condition has to be at the claim level and not the transaction…
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,344 questions
asked 2021-02-10T19:40:21.527+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 69%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKL%3C/text%3E%3C/svg%3E)
kiran l
21
Reputation points
commented 2021-02-19T07:12:16.493+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Alexei Stoyanovsky
3,416
Reputation points
1 answer
Azure automation account sqlcmd
I would like to use invoke-sqlcmd in azure automation account . using option -query I declare a query (multi line query) $query = @' declare @var1 varchar(10) declare @var2 varchar(10)...... and some other TSQL '@ then invoke-sqlcmd…
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,369 questions
SQL Server | Other
14,503 questions
asked 2021-02-18T06:14:43.35+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,346
Reputation points
commented 2021-02-19T07:10:17.613+00:00
tbgangav-MSFT
10,426
Reputation points
Moderator
2 answers
One of the answers was accepted by the question author.
Unable to see chosing Database option in Export table Task
Hi Experts, I am trying to export a table using the right click on database and select tasks and then Export option. Once the export editor opens and i select the SQL Server and enter the server name, I used to see an option on the bottom of the…
SQL Server | Other
14,503 questions
asked 2021-02-18T21:43:31.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 28.000000000000004%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Shyam Sreeramula (NSW Ambulance)
21
Reputation points
answered 2021-02-19T04:27:09.547+00:00
Shyam Sreeramula (NSW Ambulance)
21
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL server Column level security
I want to implement column level security to tables in SQL server 2008 and 2014 .What are the best options for this kind of scenario .
SQL Server | Other
14,503 questions
asked 2021-02-18T23:30:23.65+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 14.000000000000002%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Priyanka Kshatriya
21
Reputation points
answered 2021-02-19T03:11:08.297+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,661
Reputation points
2 answers
How to restore File Groups to retreive the data lost in SQL
Example: We have created file Groups in P4 Database. We have created another File Groups with Index in P5 Database, both file groups having same files, Is there any possibility to set all filegroups in one name.
SQL Server | Other
14,503 questions
asked 2021-02-05T10:50:06.81+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 48%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Parameswara Reddy
1
Reputation point
commented 2021-02-19T02:42:01.103+00:00
Cris Zhan-MSFT
6,661
Reputation points
1 answer
SSRS 2016- Custom form authentication and related configuration in SSDT Visual studio 2019
Hi All, Greetings of the day! In our project, we are migrating ssrs 2008 reports to ssrs 2016 env. Technical Environment details - SQL Server 2016, SSRS 2016 SSDT - Visual Studio 2019 Datawarehouse - Oracle 11g SSRS authentication - Custo…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,066 questions
asked 2021-02-18T09:02:08.857+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 84%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Sudhakar Chavan
6
Reputation points
answered 2021-02-19T02:16:12.767+00:00
ZoeHui-MSFT
41,496
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server Express 2019 Architecture
Is SQL Server 2019 Express edition available in 32-bit or is it 64-bit only?
SQL Server | Other
14,503 questions
asked 2021-02-18T19:19:56.927+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 52%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Adler, Ben
21
Reputation points
answered 2021-02-19T02:07:48.96+00:00
Cris Zhan-MSFT
6,661
Reputation points
1 answer
One of the answers was accepted by the question author.
Maximum Tables in Merge Replication
Have found the following article ( [maximum-capacity-specifications-for-sql-server][1] ) on the maximum number of articles for a MERGE replication and it states the following: Articles (merge publication) 2048 ...now is that per publication or total…
SQL Server | Other
14,503 questions
asked 2021-02-18T00:10:24.837+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 33%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBD%3C/text%3E%3C/svg%3E)
Barry Duncan
21
Reputation points
accepted 2021-02-19T01:52:13.753+00:00
Barry Duncan
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Max Filters to be used - SSAS Tabular
Hi, I have a restriction to implement in the measures calculations in tabular model cube. I should not allow more than 5 filters of a measure. e.g: I have the Number of Orders as a measure, and I have 7 dimensions (A,B,C,D,E,F,G). I should not…
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,344 questions
asked 2021-02-17T12:07:03.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 68%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESI%3C/text%3E%3C/svg%3E)
Sorrow In Yellow
66
Reputation points
commented 2021-02-19T01:39:59.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lukas Yu -MSFT
5,826
Reputation points
1 answer
SQL Enterprise elvaluatiion key downgrade to Standard
Now I have installed a MS SQL Enterprise evaluation key in server and all DB imported. Unfortunately, I purchased MS SQL Standard volume license and i have no way to use the license. Any other way?
SQL Server | Other
14,503 questions
asked 2021-02-17T03:05:20.967+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 55.00000000000001%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sere
1
Reputation point
commented 2021-02-19T01:36:56.307+00:00
CathyJi-MSFT
22,396
Reputation points Microsoft External Staff
1 answer
SQL 2016 services fails to come up on secondary node.
I have a two node cluster, recently for some reason SQL services fails to come up online on secondary node. It comes up on Node 2 but stays online only for 2 seconds or so and just terminates itself on Node 2. There are no errors logged in SQL files. …
SQL Server | Other
14,503 questions
asked 2021-01-30T03:58:17.367+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
answered 2021-02-19T00:50:40.167+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 69%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sean Gallardy - MSFT
1,901
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Stop user access when updating Tables?
Hi, We are going to run some scripts from consultant to update some tables in a SQL Server Database. We would like to block end users from accessing that database during our update. Is it feasible ? If not, can we disconnect all users from the…
SQL Server | Other
14,503 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 99%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Add a specific order to a trigger for a table with sp_settriggerorder
Hello, I have a problem and I think I might have a solution but I need more details. Here is my problem: I have developed a trigger trg_ProjectTransfer_A_to_B on a ProjectA table that retrieves information on a database from proprietary application A and…
Developer technologies | Transact-SQL
4,707 questions
SQL Server | Other
14,503 questions
3 answers
One of the answers was accepted by the question author.
Does BAG require Microsoft domain?
For testing purpose, could we setup primary replica and secondary on two independent servers, which is there is no domain or AD being setup
SQL Server | Other
14,503 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 15%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Extract a pattern of numbers out of a varchar(max) column
we have a table which has a column, and we need to extract only the value that matches the pattern of numbers defined as ####-#### where # is any digit from 0-9 and it's only eight digits with a hyphen in the middle, four digits on each side of the…
SQL Server | Other
14,503 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 74%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
2 answers
OneDrive Blocking Connection Strings?
Hello, I've been able to accomplish a basic content management system on my local machine in vb6 and sqlDeveloper. I have a static IP from my ISP, but only the machine that will be the cloud can connect. It's been over a decade since we discussed…
SQL Server | Other
14,503 questions
asked 2021-02-17T19:17:57.257+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 99%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Paulywog0667
1
Reputation point
answered 2021-02-18T22:01:37.457+00:00
Erland Sommarskog
122.3K
Reputation points MVP
Volunteer Moderator
2 answers
MS SQL server error
Seems I might have shrank my log file too small that now I can not run certain tasks. The transaction log for database 'database name' is full due to 'NOTHING'. (Microsoft SQL Server, Error: 9002)
SQL Server | Other
14,503 questions
asked 2021-02-17T16:10:16.107+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 6%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jonathan Brotto
1,076
Reputation points
commented 2021-02-18T16:06:33.053+00:00
Jonathan Brotto
1,076
Reputation points