SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,892 questions
1 answer
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
I have an SSIS package where Source: IBM DB2, Target: SQL Server. I have created a package in SSIS and able to run perfectly in my local machine. All connections work perfectly, data populates in the target tables. However, after deploying it to SQL…
asked 2021-02-12T19:42:54.193+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
commented 2021-02-23T22:18:47.33+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(278.4, 41%, 36%)' 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)
Bamford
1
Reputation point
2 answers
File system task error ; Access to the path " " is denied when copy file using file system task
Hi, I am using file system task to copy files from one folder to another folder. When i tried to copy fileA from folderA to folderB, an access denied to path error will pop up when folderB has fileA. I tried deleting fileA in folderB and run my…
![](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, 71%, 17%)' 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)
1 answer
One of the answers was accepted by the question author.
SSIS Encryption data tap
Dear, Via SSIS we need to load sensitive data into the SQL database. In this SQL DB we can use always encrypted as even DBA's may not see the data. However the next weakest link is a data tap in SSIS; is there a way to shield off everything so that from…
asked 2021-02-18T09:47:50.567+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(163.2, 77%, 25%)' 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)
Bram Decraene
21
Reputation points
accepted 2021-02-22T07:35:34.553+00:00
Bram Decraene
21
Reputation points
3 answers
One of the answers was accepted by the question author.
SSIS integration to run simple clustering task
Dear all SSIS fellow, Right now I work on SSIS pipeline to make automatic feature engineering which also have simple AI process to make the class. In the pipeline, we need to make a cluster based on simple feature (8 column pulled from database…
asked 2021-02-19T03:49:02.06+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(163.2, 10%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
yosafat saragih
21
Reputation points
commented 2021-02-22T03:22:02.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(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
25,201
Reputation points
1 answer
Encrypted columns in SQL Server database
Hi I have to retrieve data from database (DB1) which has encrypted columns. I have written a stored proc (as my query has lot of temp tables) to extract data from DB1 and to insert it to tables in database DB2. In SSIS package or direct insert from…
![](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(22.400000000000002, 52%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
4 answers
ODBC with SSIS On Linux
I have installed unixODBC 2.3.4 and Mysql ODBC Driver, when I use CMD "isql DNS" ,it can connect to MysqlDB； but when I use dtexec pacakge to run SSIS ,it can't recognize DNS. The Error is "INVALID_HANDLE - unable to allocate an…
asked 2021-01-25T13:30:51.537+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(220.8, 3%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWC%3C/text%3E%3C/svg%3E)
william.chen
1
Reputation point
answered 2021-02-20T01:38:22.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(236.8, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWC%3C/text%3E%3C/svg%3E)
william chen
1
Reputation point
1 answer
Not able to connect azure analysis service using sevice principal in SSIS
I am receiving following message “Test connection failed because of an error in initializing provider. The following system error occurred: “ (Without any error description) while trying to connect Azure Analysis Services in SSIS using service principal…
asked 2021-02-11T13:30:59.747+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(233.6, 33%, 32%)' 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)
Satish Sridharan (Cognizant Worldwide Limited)
1
Reputation point
commented 2021-02-19T13:17:21.21+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(201.6, 79%, 29%)' 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)
SQLDev2021
1
Reputation point
1 answer
SAP ODATA USING SSIS THROWS 401 UNAUTHORIZED ERROR
Hello, I am unable to connect to SAP Odata source using SSIS in visual studio. It always throws 401 unauthorized error using basic authentication method even though user name and password is correct. Could any one please help me with the solution. …
asked 2021-02-10T13:45:16.463+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(44.800000000000004, 42%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESU%3C/text%3E%3C/svg%3E)
swamy udayagiri
1
Reputation point
commented 2021-02-19T09:46:11.217+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
2 answers
Does CDC service keep sync between source and target Databases ?
Hello Everyone, I am new to CDC and wondering before we start implementing this if CDC in sql server will keep my target DB intact with data from source systems in all cases. for example - if i set up CDC service in sql server to read data from X no…
asked 2021-02-10T21:24:48.69+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(192, 89%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Saket Arora
6
Reputation points
commented 2021-02-19T09:33:08.033+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=12.0.0.0 on SSIS2019
Hi, I have found many posts regarding my problem. However, I did not see any solution or answer. So, ask for some help to regard it. I got a script task error at transfer the dim table from one server to another. Script task was working fine…
asked 2021-02-12T04:28:25.267+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(300.8, 52%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Chapagain, Dilli R
96
Reputation points
commented 2021-02-19T09:09:37.897+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
convert string date to datetime issue
Hi , I want to convert my string date 20201022 to datetime stamp. getting an error [Derived Column [2]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Derived Column" failed because error code 0xC0049064 occurred,…
asked 2021-02-10T15:15:35.317+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(307.2, 77%, 39%)' 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)
San
121
Reputation points
commented 2021-02-19T08:18:53.343+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
How to use x-api-key in SSIS connection manager
we have rewritten our api's to use x-api-key now i need to use that API in my SSIS. But the http connection manager will allow only basic authentication how can this be achieved ?
asked 2021-02-11T11:56:13.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(185.6, 41%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Prathima Alapati
6
Reputation points
commented 2021-02-19T08:16:02.847+00:00
Monalv-MSFT
5,896
Reputation points
3 answers
SSIS 2008: Illegal characters in path when trying to rename a file
I have a task that should rename a file I have a variable called RenameFileName \servername\csv\BACKUP\" + (DT_WSTR,4)DATEPART("yyyy",GetDate()) + RIGHT("0" + (DT_WSTR,2)DATEPART("mm",GetDate()) ,2) +…
asked 2021-02-11T13:26:45.273+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(220.8, 79%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MrJ
1
Reputation point
commented 2021-02-19T08:15:18.107+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
Problem passing list of int's in OLE DB Source parameter
I am using SQL SERVER 2012 and Visual Studio 2017 with SSDT (SQL Server Data Tools) installed, and have a query like the following in an SSIS OLE DB Source: The parameter is set up like this: and the ClientIDList variable is a string…
asked 2021-02-12T00:39:47.147+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(288, 31%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Ryan Rigby
1
Reputation point
commented 2021-02-19T08:08:15.307+00:00
Monalv-MSFT
5,896
Reputation points
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…
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,016
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)…
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,571
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…
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,571
Reputation points
3 answers
How to execute SQL Statement to make it as source and Load into Destination table in SSIS
I have a table dbo.Test whose columns (ID,Query_Column) ID Query_Column 1 SELECT CustomerKey, FirstName, LastName, MaritalStatus, Gender FROM CUSTOMER_DETAILS In Query column I have a select statement which have some data. Now In my SSIS…
asked 2021-02-17T16:07:00.977+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(304, 19%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
varaprasadmohan pinagadi
1
Reputation point
commented 2021-02-18T09:18:23.787+00:00
EchoLiu-MSFT
14,571
Reputation points
3 answers
One of the answers was accepted by the question author.
SSIS Deploy Error - Integration Services
Hello I made a package in SSIS that convert from a DBF file to the SQL server. Well in visual studio it works perfectly, but after i deployed my project in sql server it doesn't work. See the images: Someone know what is wrong? tks for…
asked 2021-02-15T11:44:38.64+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, 51%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vitor Mendes
21
Reputation points
accepted 2021-02-16T11:06:04.777+00:00
Vitor Mendes
21
Reputation points
2 answers
SSAS Cube process using SSIS packages were failing with Error: Error in high level relational engine. A connection can't be made to datasource
Hi All, Recently I migrated SQL Server from one server to another and also upgraded from SQL 2016 to SQL 2017. After migration and upgrade, a few SSIS packages designed to process dimensions and cubes started throwing errors like Error in…
asked 2021-02-07T21:12:41.923+00:00
Shivendoo Kumar
736
Reputation points
answered 2021-02-15T09:11:29.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(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