Microsoft SQL Server Management Studio 2017 is a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server. Use this tag specifically for questions related to Microsoft SQL Server Management Studio 2017.
Questions tagged [ssms-2017]
188 questions
0
votes
1 answer
Build trriger set on fire when an event occurs to the input dataset in azure data factory
i want to build a trigger in ADF that set on fire when an event occurs to the input dataset , i used linked service to import the input dataset from SQL server management studio.
I tried to create a storage event trigger, but it doesn't seem to be…
0
votes
0 answers
Unable to restore database when import .bak file
I'm trying to perform a database restore but display the message as follows.
enter image description here
Can anyone help me with this problem? Thank you very much.
On SQL Server Management Studio 2017
Right click Databases on left pane (Object…
Văn Vân
- 3
- 3
0
votes
0 answers
SSIS ETL Population began hanging and now takes twice as long to complete
Can Someone explain what these codes are and how they might explain why my ETL Duration times have doubled in the last
few weeks?
select collationname(0x0904D00034)
sys.sp_describe_first_result_set;1
Same for these messages, but they are from the…
user8675309
- 49
- 6
0
votes
0 answers
Find Bytes processed by SSISDB job on SQL Server Management Studio
Using SQL Server Management Studio, I am trying to gauge how many Bytes of data are being processed by SSIS packages. I know how to generate reports in Integration Services Catalogs to view statistics and messages, but these seem to only give…
user8675309
- 49
- 6
0
votes
1 answer
How do I return the most recent result for the week each week?
I have two tables to work from one has a list of dates and their corresponding week they belong, the other has the date a person has had any of a set of 8 tests taken (one row for each test).
I want to be able to show the most recent date each test…
Easily_Confused
- 1
- 3
0
votes
0 answers
SSIS and Oracle: "Cannot convert between unicode and non-unicode" meets "It works on my machine"
There are solutions to similar problems, but none of them quite match this one, and after two programmers researching for three days, it's time to ask.
I have a Task arrangement in Data Flow for an SSIS package that retrieves data from an Oracle…
CDove
- 1,940
- 10
- 19
0
votes
0 answers
Export Data from SQL Server to FlatFile using SSIS
I am learning SSIS.
Had a question regarding the same.
I have a SQL Table
`(File id, File name, File content)
(1,abc,hi)
(2,ghi,how)
(3,ghi,you)`
I want to give an input in SSIS:
File ID and Destination Folder
Output:
I want to export…
Prajakta
- 1
0
votes
0 answers
SSMS 2017 - connection error on one server only
I am having an issue with SSMS 2017 (latest build) on a single server only.
The set up is this: -
In preparation for upgrading SQL Server from 2012 to 2017, we have restored our two servers into an isolated network. This allows us to have the…
h20vrrq
- 13
- 5
0
votes
1 answer
SQL Server: the login is from untrusted domain and cannot be used with integrated authentication. SSMS
I have two SQL Servers on different domains. I am trying to connect to SQL server "A" using SSMS on domain "B", but getting this error.
Login failed. The login is from an untrusted domain and cannot be used with integrated authentication.…
angadai
- 1
- 1
- 1
- 2
0
votes
1 answer
I get this error Message "Invalid length parameter passed to the LEFT or SUBSTRING function."
enter image description hereThis code should return the street address without the street number. These EU address have their street number at the end of the address. I am not sure why the error is happening.
UPDATE…
Sdot4allg
- 9
- 6
0
votes
1 answer
Grouping Sum of Items by Month
I have a view for all invoiced transactions with fields item, qty_sold, and invoice_date. It displays like…
wvivas
- 3
- 3
0
votes
1 answer
Syncing Metadata from Azure DataFactory to SQL Server database
I am trying to sync metadata from an Azure DataFactory pipeline to a table in a SQL Server database.
The output visible in the Read Metadata activity in Azure is as follows:
{
"childItems": [
{
"name": "DemoFile1",
…
user17843794
- 23
- 5
0
votes
2 answers
Syncing Metadata output from Datafactory in SQL Server database error using stored procedure: Json - Unexpected character 'S' is found at position 0
I am getting this error while trying to write the metadata output from DataFactory to a SQL Server database.
"errorCode": "2402",
"message": "Execution failed against SQL Server.
SQL error number: 13609.
Error Message: JSON text is not properly…
user17843794
- 23
- 5
0
votes
2 answers
Creating multiple new rows using data from other rows
Is there a way to add extra rows to a table, pulling the data from other rows? Specifically, I am needing to relate all teachers of a specific subject to all classes. Currently, the code looks like this:
SELECT
class
teacher
…
Rob
- 59
- 8
0
votes
2 answers
Executing multiple queries in SSMS
Is there a possibility to run many queries, that are not next to each other in the text editor in SSMS, at one time?
Assuming we have:
select * from tab1
select * from tab2
select * from tab3
the aim is to somehow mark only first and last selects…
I.P.
- 300
- 2
- 16