Skip to main content
336,740 questions
Newest Active Bountied Unanswered
-2 votes
0 answers
58 views

I have two tables; the first one consists of clients' names and their id. For example: name surname1 519651 name surname2 496879 name surname3 848465 The second one consists of clients'...
solar dary's user avatar
  • 1
-3 votes
0 answers
68 views

I am loading a cleaned CSV file into SSIS using a Flat File Source, but the Data Flow keeps failing with the following error: Data conversion failed. The data conversion for column "...
HUYỀN NGUYỄN THỊ MỸ's user avatar
  • 1
-4 votes
1 answer
82 views

Let's say I have table A and table B table A has one column A, comprised of 4 values A 1 2 3 4 table B also has one column, called B, comprised of 13 values B 1 2 3 4 5 6 7 8 9 10 11 12 13 Now, ...
Trovs OnEmu's user avatar
  • 3
-2 votes
0 answers
63 views

I don't know what's wrong, or if there's a configuration problem. I can execute queries and create new stored procedures, but I can't commit changes to existing stored procedures.I don't know what's ...
jw Luo's user avatar
  • 1
0 votes
1 answer
115 views

I’m migrating SQL Server tables to Snowflake using Azure Data Factory. Direct Copy from SQL Server to Snowflake works, but I can’t use it because of the 100 MB row size limit. That forces me to take ...
Arud Seka Berne S's user avatar
  • 1,001
Advice
1 vote
2 replies
46 views

I am trying to create a visual overview / diagram for an old SQL Server database. I have already looked through similar questions and articles, but I couldn't find a program that suits the task. I ...
simplepoint25's user avatar
  • 1
0 votes
1 answer
98 views

I have an unique filtered index that is not allowing a PO to be inserted and there is no duplicate to be found. How can I allow POs to be inserted that are unique when the index thinks they are ...
Ken Watson's user avatar
  • 1
-1 votes
0 answers
49 views

When we are trying to connect the SSIS (Integration Services) from remote Server, we are getting below error. The SQL Server version is 2019. We are able to connect with SSMS 18 version from remotely ...
Shannu's user avatar
  • 11
0 votes
0 answers
53 views

in our package that we use for connecting to database and perform stuff on it (like read table, insert data, ...) we have a special method that we pass to pandas.to_sql method to insert data to ...
Saguro's user avatar
  • 151
0 votes
2 answers
154 views

I have a query that outputs the below result: users file_consumed John orders Martin orders Alice orders Bob payments Alex payments Julie payments John deliveries Bob deliveries I want to convert this ...
LearneR's user avatar
  • 2,591
0 votes
1 answer
59 views

Unless the query result displays in pretty much less than a second then I get this pop-up notification every single time I execute a query. Is there any way to disable this? I found under Tools -> ...
Fettster777's user avatar
  • 41
0 votes
0 answers
43 views

I’m running an Azure DevOps pipeline on an Ubuntu agent inside a container (rocker/verse:4.0.4). The goal is to push data from R to SQL Server after refreshing some datasets. I installed the Microsoft ...
Ferxani's user avatar
  • 1
1 vote
1 answer
64 views

I have created on SSIS(2019) package. The package is selecting the data from oracles tables in writing it to a flat file (CSV). The package is working perfectly in visual studio (SSIS designer). But ...
Rana_kgec's user avatar
  • 58
3 votes
2 answers
152 views

I am creating a varchar(max) string for submission to 'EXEC' and it is less than 1000 bytes long, yet the 'exec' errors out - seems to not get the entire string. Below is the code that errors out: ...
JackRay's user avatar
  • 53
1 vote
1 answer
165 views

Is it possible to pivot OPENJSON data for multiple rows in T-SQL (on SQL Server 2022). I have a case like below, it works fine for single ID (eg. CustID=111). Surely I can go this route processing ...
user1982778's user avatar
  • 141

15 30 50 per page
1
2 3 4 5
…
22450