Azure SQL Database
An Azure relational database service.
5,428 questions
1 answer
One of the answers was accepted by the question author.
Workday and alternative
Hi, I have a table which needs to duplicate with weekday and alternative create table table3 ( col1 varchar(20) , col2 varchar(20)) expected results Insert into table1 values('catch', 'catch1') …
![](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(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
1 answer
SSIS Wizard new mapping file not found
Hi I am attempting to migrate a Sybase ASA database to SQL Server using the 'SQL Import and Export Wizard' within Visual Studio 2019. I am able to run the wizard and create a package but the datatype mappings are not correct, e.g. datetime is mapped…
asked 2022-02-14T20:11:32.557+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, 86%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Marshall, Richard J
1
Reputation point
commented 2024-07-15T12:58:08.4066667+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(259.20000000000005, 93%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEH%3C/text%3E%3C/svg%3E)
Eve Harrell
5
Reputation points
2 answers
Visual Studio 2022 unable to connect to excel
Hi Folks, I wish to connect to Excel sheet from my Visual studio 2022 however when I create a connection and ran it the following error was produced. I am running Win10 64bit. ERROR Exception from HRESULT: 0xC020801C Error at Package [Connection manager…
![](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(48, 31%, 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)
2 answers
SSIS : Decimal Places not loading from Excel Source to SQL table
Hi Team - I have an excel file with few columns but the issue is with one of the column, Lets say Column A. Column A : FY20 Work Extra Feb 4 4,401,0089 3,81,68182.01 27,381.59 - 42590062.77 99.8% Few of the numeric values above are rounding off in…
asked 2024-07-12T04:39:32.5766667+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, 36%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
kkran
831
Reputation points
answered 2024-07-12T09:00:49.7366667+00:00
ZoeHui-MSFT
35,551
Reputation points
2 answers
updare dateid in table
HI, Hw to update date datatype into integer column to varchar column create table table1(dateid date,dateid1 int,dateid2 varchar(23) ) dateid --------------------- dateid1 -------------dateid2 2024-01-01…
asked 2024-07-10T18:59:02.5066667+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(89.60000000000001, 94%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
RUPESH SHELAR
0
Reputation points
commented 2024-07-12T02:02:29.6333333+00:00
LiHongMSFT-4306
25,651
Reputation points
4 answers
VS 19, SSIS project, getting and error "The specified provider is not supported. Please choose different provider in connection manager" when choosing OLEDB as the connection type
Using Visual Studio 19 on new laptop. Have installed the SSIS template. I also have SSMS 19 installed. I create a new project and try and create a new Connection Manager. I select OLEDB and click Add... On the next screen to configure the OLE DB I select…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,883 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
asked 2023-04-26T00:34:01.27+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, 7.000000000000001%, 23%)' 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)
Seeley, Steve
15
Reputation points
commented 2024-07-11T08:21:06.97+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(16, 82%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Maxime Vyls
0
Reputation points
4 answers
How to fix - Excel Connection Manager fails in SSIS
Hi there! I am trying to ingest data from an Excel file (.xlsx) using SQL Server Integration Services (SSIS) through Visual Studio. The versions/specs that I am running are: Microsoft Visual Studio 2022 - 64 bit version 4.8.04084 SQL Server Data…
asked 2023-05-09T02:44:51.95+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(272, 45%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Martin, Daniel
15
Reputation points
commented 2024-07-11T03:02:06.55+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(131.20000000000002, 35%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
JD N
1
Reputation point
1 answer
One of the answers was accepted by the question author.
create the dateid table in sql server
Hi , how to populate the dateid and date in dimtime table using script as below output upto 2029 excluding saturday and sunday create table table (dateid int,day varchar(23), dateid | day 20240601 | 2024 June 01 20290601 | 2029 June…
3 answers
Unable to Add New Package Configurations in the Package Configuration Wizard
Why can't I add new package configurations? I am getting the error message below. TITLE: Microsoft Visual Studio Could not leave the wizard page. For help, click:…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,883 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
asked 2024-07-08T18:15:50.4766667+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(102.4, 5%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Chris Curran
0
Reputation points
answered 2024-07-10T15:47:54.37+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,731
Reputation points
5 answers
Cannot insert the value NULL into column and column does not allow nulls
HI Team i have build a physical table with some columns, where i have an identity column in my table [ProdID] [int] IDENTITY(1,1) NOT NULL I am trying to insert the records into this prod table using the destination table values ,insert fails…
asked 2022-10-03T10:35:41.323+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(217.60000000000002, 15%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENY%3C/text%3E%3C/svg%3E)
Naresh y
146
Reputation points
answered 2024-07-09T09:50:54.8966667+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(208, 67%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Muhammad Shoaib
0
Reputation points
1 answer
How to switch SSISDB after a shrink operation to the real one
Hi all, I'm finishing a operation on a copy of the SSISDB database. It was several GB due to incorrect settings in the log processes (verbose) and some jobs that continued indefinitely without stopping. Now, these issues have also been fixed with…
asked 2024-07-08T21:19:08.9066667+00:00
Alen Cappelletti
992
Reputation points
answered 2024-07-09T02:19:12.0566667+00:00
ZoeHui-MSFT
35,551
Reputation points
4 answers
One of the answers was accepted by the question author.
How to replace NULL with Not Available in SSIS?
Hi, I have my input data like below. I want to load the data after replacing NULL values with 'Not Available' in Manager column in SSIS Package. Dept Table: Id Dept_Name Manager 1 HR Kumar 2 IT …
asked 2024-07-07T15:23:51.32+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(208, 71%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Ramana Kopparapu
266
Reputation points
accepted 2024-07-08T07:26:40.8866667+00:00
Ramana Kopparapu
266
Reputation points
2 answers
What information do I need to use Microsoft Entra authentication methods in a local SSIS Package (other than MFA)
Hi, our team got an issue transferring to Microsoft Entra authentication methods in a local SSIS package to access data from Azure SQL Database from other teams. Backgroud: We used to use the userID and password using SQL server authentication methods…
asked 2024-06-25T22:56:26.4866667+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, 61%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
David Liu (CSI INTERFUSION INC)
0
Reputation points Microsoft Vendor
answered 2024-07-02T11:55:34.6633333+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
4 answers
One of the answers was accepted by the question author.
Getting error : to run a ssis package outside of sql server data tools you must install standard edition (64-bit) of Integration Services or higher
Hi Everyone, I developed a package in SSIS 2019, and now testing it by running it from the batch file getting an error: to run a ssis package outside of sql server data tools you must install standard edition (64-bit) of Integration Services or higher.…
asked 2021-04-14T21:07:51.09+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(108.80000000000001, 45%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
ajay rawat
116
Reputation points
answered 2024-07-01T13:56:28.59+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(57.599999999999994, 94%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kim Anical
0
Reputation points
2 answers
Vertica Data Provider missing in Visual Studio 2022
On my new windows laptop I am trying to set up SSDT for SSIS packages. Earlier I was working on VS Enterprise 2017 version which I connected with Vertica using .Net Providers connection like this - but the 2022 version doesn't seem to have that option.…
asked 2024-06-28T19:25:55.3766667+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(105.60000000000001, 16%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Deepali Pareek
0
Reputation points
answered 2024-07-01T08:28:15.01+00:00
ZoeHui-MSFT
35,551
Reputation points
2 answers
Faster way to data load from oracle to SQL server without Attunity 5.0
Hello, I am in the process of upgrading SSIS packages from 2015 to 2022 using VS 2022. we are having performance issues with data load from oracle to SQL and vice versa. we were using Attunity 4.0 with previous version of VS 2015 and that was a big help…
asked 2024-06-28T15:51:19.4233333+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, 7.000000000000001%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lodha, Nimisha M
0
Reputation points
answered 2024-07-01T02:11:55.0066667+00:00
ZoeHui-MSFT
35,551
Reputation points
2 answers
One of the answers was accepted by the question author.
How to load the data from source when there are two delimiters using SSIS?
Below is my data in source document. The document has two delimiters like tilde(~) and pipe(|).. ~id~|~name~|~gender~|~age~ ~101~|~ABC~|~M~|~28~ ~102~|~DEF~|~F~|~27~ How can I load the data into SQL table Emp? Please look into this and do neeedful Thanks…
asked 2024-06-26T06:22:16.23+00:00
Ramana Kopparapu
266
Reputation points
accepted 2024-06-27T05:10:08.18+00:00
Ramana Kopparapu
266
Reputation points
1 answer
SSIS 2019 - Identify and Redirect Duplicate Values in Data Flow
Hello, To be clear this is not a requirement to identify and redirect or dedupe rows in the data flow task leveraging the Sort Transformation. Instead, the requirement is to identify the duplicate values in a column then handle affected rows…
![](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(134.4, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
0 answers
Data Flow Cannot Support Error Redirection When Used in a Transaction Error
Hello, I'm attempting to leverage the built-in Transaction functionality but to no avail. I followed the MSFT Learn docs and enabled MSDTC on the database server (same server SSIS is running on). …
3 answers
SSIS 2022 Script Component Runtime Error
Hello, I've configured a Data Flow error redirection and is using a Script Component to capture the error description and column but is getting the attached runtime error. I am running the latest version of VS2022. Thanks