Skip to main content
Stack Overflow
  1. About
  3. For Teams
Filter by
Sorted by
Tagged with
-3 votes
0 answers
63 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 "...
-4 votes
1 answer
74 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, ...
-2 votes
0 answers
39 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 ...
0 votes
1 answer
112 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 ...
Advice
1 vote
2 replies
45 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 ...
0 votes
1 answer
93 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 ...
-1 votes
0 answers
47 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 ...
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 ...
0 votes
2 answers
152 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 -> ...
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 ...
1 vote
1 answer
63 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 ...
3 votes
2 answers
151 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: ...
1 vote
1 answer
154 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 ...
-4 votes
3 answers
165 views

I'm searching for duplicate values per column and need a count of them and data from some additional columns. Table sample BillNr Name email 1000 Shakira [email protected] 1001 Shakira [email protected] ...

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

AltStyle によって変換されたページ (->オリジナル) /