SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
1 answer
SSIS and determining Day-Of-Week and branching if "Monday"
I want to evaluate the Day-Of-The-Week and then branch to an Execute SQL Task that will derive my @GloabalStartDate and GlobalEndDate Variables to set Friday thru Sunday if the Day-Of-The-Week is determined to be "Monday". Can someone share…
asked 2020-08-17T18:41:37.687+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(310.4, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Bobby P
221
Reputation points
commented 2020-08-28T06:34:16.437+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(294.40000000000003, 37%, 38%)' 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)
Monalv-MSFT
5,896
Reputation points
1 answer
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
je suis incapable de déployer les packages ssis car je n'ai pas le catalogue ssisdb après plusieurs essais je trouve que l'origine de problème le manque de la fonctionnalité integration services j'ai essayé de modifier l'installation en ajoutant cette…
asked 2020-08-11T12:45:34.333+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(262.40000000000003, 39%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
emna khiari
1
Reputation point
commented 2020-08-28T06:32:28.77+00:00
Monalv-MSFT
5,896
Reputation points
4 answers
String Change in T-SQL
Hi All, I have a requirement, i want to replace string with id value from another table value. Another table id's: 4698,50470,50490,4698,5047 ID NAME 4698 ABC 5047 DEF 5049 GHI Source String :…
asked 2020-08-23T09:25:55.697+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(182.40000000000003, 17%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
BHVS
61
Reputation points
commented 2020-08-28T06:28:56.713+00:00
MelissaMa-MSFT
24,176
Reputation points
1 answer
How to query sql server 2019 graph database in .NET Core 3.1
How can I query and add/modify a SqlServer 2019 Graph Database in .NET Core 3.1. Is it possible to do a code first implementation (migrations)? Is the graph database accesable via entityframeworkcore? Is documentation / example code available?
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,818 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,187 questions
asked 2020-08-27T13:52:01.397+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(80, 27%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXV%3C/text%3E%3C/svg%3E)
Xander Valenkamp
6
Reputation points
answered 2020-08-28T06:03:46.913+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,611
Reputation points
1 answer
Data warehouse features in SQL server versions
Hi, A was comparing SQL server versions and features and i noticed that in versions 2017 and 2016 Data warehouse features there is a feature: -Create cubes without a database …
asked 2020-08-17T11:55:19.783+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(144, 0%, 23%)' 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)
Aleksandar Stojanovski
1
Reputation point
commented 2020-08-28T05:53:40.4+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,816
Reputation points
1 answer
Calculate cost per product per user from budgeted data
Hi, I have a requirement where i have the following data model and unable to arrive a correct measure for calculating cost per product per user.I want to be also able to slice by date and empl dim. Can someone pls correct and post ideas to…
asked 2020-08-17T12:16:35.453+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(28.799999999999997, 7.000000000000001%, 12%)' 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)
PV
21
Reputation points
commented 2020-08-28T05:51:57.583+00:00
Lukas Yu -MSFT
5,816
Reputation points
1 answer
mdx issue for multilevel dimension hierarchy
I have a requirement where i had to apply dimension security to one of the dimensions "CompensationItem". But the problem was it has dependency on another dimension "Scenario". We have a mapping table/measure (COMP SECURITY) with…
asked 2020-08-19T09:54:10.52+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(256, 10%, 34%)' 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)
sudipta sen
1
Reputation point
commented 2020-08-28T05:50:08.457+00:00
Lukas Yu -MSFT
5,816
Reputation points
1 answer
Create folders inside the "Tables" folder
Hello community. I have a model with more than 20 tables and I would like to group them by processes within the folder "Tables", being as follows: Tables > Process A >>> Table 1 >>> Table 2 >>> Table 3 …
asked 2020-08-24T22:13:08.213+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(153.6, 18%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Daniel Castillo
1
Reputation point
commented 2020-08-28T04:09:21.493+00:00
PRADEEPCHEEKATLA-MSFT
84,051
Reputation points Microsoft Employee
2 answers
SSIS Foreach Loop with Conditional Data Flows/Flat File Connections?
I'm setting up a process to bulk insert daily flat files into a staging warehouse. The flat files are not very clean. The files for the first 40 days contains 20 column and the days after contain 22 columns. How can I set up my foreach loop to switch…
asked 2020-08-27T14:46:12.453+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, 91%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERO%3C/text%3E%3C/svg%3E)
Robert Ong
1
Reputation point
answered 2020-08-28T03:24:47.317+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
Connect to SQL server using jdbc with AD username and password
We want to In order to avoid SQL server accounts we want to use Active directory accounts in out java programs to connect to SQL server. We are not always able to use integrated security (e.g. different applications running on the same Wildfly instance…
asked 2020-08-27T19:10:08.373+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(169.60000000000002, 44%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Schuetze, Peter
1
Reputation point
answered 2020-08-28T03:09:11.917+00:00
m
4,271
Reputation points
2 answers
Query does not return any results
Hello, I am running the following query on SSIS on the AdventureWorks2012 database.. select c.CustomerID as CustomerAK, p.Title, p.FirstName, p.MiddleName, p.LastName, p.Suffix, em.EmailAddress from Sales.Customer c join Person.Person p…
asked 2020-08-27T16:18:44.39+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(54.400000000000006, 89%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EET%3C/text%3E%3C/svg%3E)
Edgar Toia Neto
1
Reputation point
answered 2020-08-28T02:50:19.957+00:00
Monalv-MSFT
5,896
Reputation points
4 answers
pdf makes top margin on first page slightly larger and adds blank page at end
hi we run 2016 enterprise and develop using vs 2017. my subreport has been changed to have a .04 cm top and bottom border so a rectangle at the top can always have a predictable bottom border location for tear off purposes. when i print stand alone…
asked 2020-08-27T19:48:05.027+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(41.6, 70%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
db042190
1,516
Reputation points
answered 2020-08-28T02:11:25.873+00:00
Joyzhao-MSFT
15,571
Reputation points
1 answer
Does SSRS 2019 have the ability to encrypt attachments?
We are going to be sending email attachments as part of a data driven subscription. Some of the attachments could contain PHI. Can SSRS 2019 encrypt the files that are attached to the email?
asked 2020-08-27T12:30:29.98+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(275.2, 44%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Sherri McDonald
1
Reputation point
answered 2020-08-28T01:50:17.257+00:00
Joyzhao-MSFT
15,571
Reputation points
4 answers
How to replace sub string by stuff separated by stick | to separate values?
I work on SQL server 2012 I face issue I can't separate values by stick | using stuff ? meaning i need to replace sub string by stuff and what statement below do as sub string ,type.value and XML path SELECT DISTINCT [InputID],PART_ID,[Vendor…
asked 2020-08-24T02:46:01.173+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(262.40000000000003, 77%, 35%)' 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)
ahmed salah
3,216
Reputation points
answered 2020-08-28T01:33:45.897+00:00
m
4,271
Reputation points
5 answers
Linked Server. Dont show ip or dynamic dns
Hello, I want to make a link between two sql servers 2019. My server is a local machine, the other server is a virtual machine in cloud. I can connect the virtual to the local very easily but the ip shows up. Can i make the link and have my own…
asked 2020-08-23T08:24:12.737+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(9.6, 99%, 10%)' 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)
Stefanos Spyridakis
21
Reputation points
answered 2020-08-28T01:33:17.58+00:00
m
4,271
Reputation points
4 answers
Hyper-V 2019 SQL 2016 Std on Windows 2012R2 slowdowns
Hello, Environment: Hyper-V 2019 256GB RAM, SQL 2016 fixed memory not dynamic 128GB on Server 2012R2. Only 2 VM's on the host, 10Gb nics (Broadcom), FC storage.CSV's. After several days, 4-5 SQL slows-down to a crawl, queries and writes. SQL is…
asked 2020-08-22T05:44:49.097+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(96, 0%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Colin Marshall
1
Reputation point
answered 2020-08-28T01:32:50.747+00:00
m
4,271
Reputation points
5 answers
Unable to import Sybase ASE native data file using bcp
Hi, I have a requirement to import native BCP file from Sybase ASE to SQL Server. Can anyone please advise on this? Thanks.
![](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(51.2, 81%, 14%)' 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)
6 answers
Arquivos MDF
Bom dia, tenho um banco de dados sendo o arquivo com 800Gb, e o disco onde ele está armazenado está praticamente cheio. Gostaria de saber qual é a melhor pratica para isso. Criar um novo drive, criar um novo MDF com autogrow e o arquivo atual…
asked 2020-08-21T11:46:46.687+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(41.6, 65%, 14%)' 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)
Alexander Benatti
21
Reputation points
answered 2020-08-28T01:31:35.553+00:00
m
4,271
Reputation points
1 answer
One of the answers was accepted by the question author.
Query takes long time to run
SQL Server: 2014 Problem: I am running a query that joins 3 views and produces results. Query takes over 8 minutes to run, but it runs without an error and produces correct output. Can you please take a look at my query and tell me why it takes 8…
asked 2020-08-27T14:38:34.403+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(284.8, 7.000000000000001%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES7%3C/text%3E%3C/svg%3E)
SQLIsGood-7036
176
Reputation points
accepted 2020-08-27T17:55:56.03+00:00
SQLIsGood-7036
176
Reputation points
1 answer
One of the answers was accepted by the question author.
Is there a way to auto-create all of the columns in a tablix?
Is there a way to auto-create all of the columns in a tablix? I have a SQL view with 100+ columns that the user wants to see in a spreadsheet created from an SSRS report and I do not want to manually create each column for the tablix.
![](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, 82%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)