Skip to main content
21,261 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
Tooling
0 votes
5 replies
47 views

I have multiple excel online files with question and responses in them but I can't read the checkbox responses of yes and no in python or ssis. I want to export them to BI tool and aggregate the ...
Kofisam's user avatar
  • 9
0 votes
1 answer
65 views

I am placing the following command in a data flow task in an SSIS 2022 project, and the parameter I have is of type int(32) and the ReceptionDate_Shamsi column is of type char(10), and this causes my ...
milad khanzabarlu's user avatar
  • 1
-1 votes
0 answers
61 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
Tooling
0 votes
0 replies
30 views

How can I create PDFs for members in an ADF workflow using an Azure Function App? The function needs to invoke an SSRS report URL. How can we call the SSRS URL from ADF—should we use a Web Activity or ...
Rohitsatya2000's user avatar
  • 1
1 vote
1 answer
70 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
0 votes
0 answers
47 views

I'm trying to make a package to download some data from host who implemented JWT authentication. Is this possible with stock SSIS components (as of 2025) ? I don't see dedicated API box for this, so ...
Mario Trento's user avatar
  • 393
0 votes
0 answers
91 views

I've an SSIS package in which data from text files are transferred to SQL tables using DFT. Multiple files inside the folder has been read through ForEachLoop Container. From the ForEachLoop ...
user1441204's user avatar
  • 1
0 votes
1 answer
44 views

Currently all of our SSDT packages have been created with SQL Server Data Tools 2015 We are looking to upgrade to SSDT 2022. I installed Visual Studio 2022 with the following selected during setup: ...
JetRocket11's user avatar
  • 314
1 vote
1 answer
51 views

I have multiple CSV files in a folder, each with different columns. I want to process each file in Azure Data Factory Data Flow so that: Only certain columns (specified per file) are kept. Unwanted ...
tesla 369's user avatar
  • 11
0 votes
0 answers
52 views

I'm building ETL packages in SSIS. My data comes from an OLE DB Source that calls a stored procedure in SQL Server. I want to add a new Lookup (or a similar transformation) that uses some of the input ...
sabotage's user avatar
  • 1
0 votes
0 answers
44 views

I have created an SSIS package to transfer a large bulk amount of data. Everything works fine on all my other Execute SQL Tasks, however on my only Script Task I keep getting the error Invalid column ...
Sheztc1977's user avatar
  • 1
0 votes
0 answers
88 views

I have an SSIS master package with a Script Task that launches other packages. Inside the Script Task, I load the package list into a DataTable and try to execute them in parallel using Parallel....
Saladin's user avatar
  • 36
0 votes
0 answers
36 views

I have the following in a script task at control flow level. string docServer = Dts.Variables["User::DocServer"].Value.ToString(); int port = int.Parse(Dts.Variables["User::Port"]....
Gulumal's user avatar
  • 69
0 votes
1 answer
91 views

Trying to execute SSIS package via script. Declare @execution_id bigint EXEC [SSISDB].[catalog].[create_execution] @package_name = N'SF_Appointment.dtsx' ,@execution_id = @execution_id OUTPUT ,@...
Dense_Dog's user avatar
  • 3
0 votes
0 answers
22 views

I created Class library (.NET Framework) dll in Visual Studio 2022 and signed it. I referenced it from SSIS Script Component but SSIS cannot find it after build and run. When I install my dll in GAC ...
sbrbot's user avatar
  • 6,545
0 votes
0 answers
115 views

We have hundreds of SSIS packages created with Visual Studio 2015 and currently they all run perfectly fine through batch commands that execute the following: C:\Program Files (x86)\Microsoft SQL ...
JetRocket11's user avatar
  • 314
0 votes
2 answers
71 views

I have a query in a SQL command: SELECT * FROM [tbl1] LEFT JOIN [tbl2] ON tbl1.id = tbl2.id WHERE id IN ('','') I have a lookup table the ID is. I want to use a variable to get the ID's from the ...
user22539527's user avatar
  • 9
0 votes
0 answers
69 views

In SQL SSIS, I have a package that has a single task. I only want that task to run if a boolean parameter called IsProd is True. I am struggling to do this with a precedence constraint. When setting ...
Martin Williams's user avatar
  • 31
0 votes
0 answers
58 views

We have a SQL Server Integration Services (SSIS) task that retrieves emails from a table in our Customer Relationship Management (CRM) system. The emails contain From:, To:, Cc, and Bcc: addresses, in ...
scooter133's user avatar
  • 1,317
0 votes
0 answers
20 views

Does anyone know how to create an SSIS custom connection manager that exposes a secure string property? I can create the custom connection manager fine and it works - but only if I pass the 'SecretKey'...
MrCraze's user avatar
  • 365
0 votes
0 answers
88 views

While importing Snowflake view to SQL Server using SSIS package, it's throwing this error: Error: SQLSTATE: 22002, Message: [Snowflake][ODBC] (10450) Indicator pointer is required by the driver to ...
Sathyanarayanan's user avatar
  • 149
1 vote
1 answer
88 views

I'm working on a project where I need to extract data from an EDI file and load it into a database. I'm using Cozyroc’s “EDI Source” component for this. The EDI Source produces three data outputs, and ...
Darwin Palma's user avatar
  • 13
1 vote
1 answer
285 views

I'm getting the "The requested OLE DB provider SQLNCLI11.1 is not registered" on my new SQL Server 2022 installation when I try to run my tasks. The catch is that I updated all of my SSIS ...
FlyFish's user avatar
  • 581
0 votes
0 answers
46 views

I am creating a SCD type 2 dimension and using start and end dates to identify current and expired records. In my destination table, there are start date and end date columns. I am unable to select ...
Oribim's user avatar
  • 1
0 votes
1 answer
104 views

Using SSIS and an ADO.NET connection, I need to update a column in a SQL Server table defined as nvarchar(max). I've generally done this without issue using the OLE DB command, but this isn't ...
Sam Alex's user avatar
  • 121
0 votes
0 answers
28 views

In SSIS I'm using an ADO.NET connection and depending on the Target it'll either use "Active Directory Integrated Authentication" or "Active Directory Password Authentication". I'...
Sam Alex's user avatar
  • 121
0 votes
0 answers
164 views

I have been getting this error message every time I run my saved SSIS package. And even though I have looked up this error message across the web, the solutions have not seemed to work. To provide the ...
Ryan's user avatar
  • 11
0 votes
0 answers
94 views

I've been working with SQL Server Integration Services (SSIS) and up until June 20th, 2025, I was able to use the software with no issue. On the 20th, Microsoft pushed an upgrade for the SSIS ...
Cole Wallace's user avatar
  • 1
0 votes
0 answers
39 views

I have created a package that does few different tasks on bunch of csv files one by one in a foreach loop container and then a File System Task (as a last step in loop) moves the file to a ...
Atif.SQL's user avatar
  • 1
-1 votes
2 answers
691 views

I am in the process of updating our local instance to SQL Server 2022. I have all of the SQL Server configuration done, but I am having problems getting our SSIS packages to open in Visual Studio and ...
Scotty Smith's user avatar
  • 11
0 votes
0 answers
58 views

Trying work out why datetime variable fails as parameter in SQL. So maybe datetime fails to convert to date. Changing the SQL to convert the value explicitly to date fails, Making the variable ...
Alocyte's user avatar
  • 343
0 votes
1 answer
84 views

I have a request to create an excel report with sheet containing data for a specific employee (1 sheet per employee). I would like to accomplish this by dynamically using variables or parameters. I've ...
Steven's user avatar
  • 139
1 vote
0 answers
37 views

I am creating a pipeline to copy data from an Oracle database table to a SQL Server table. The process is to add a “Data Flow Task” to the control flow and add a “Data Flow” to it. When I run the ...
Straitsuo's user avatar
  • 11
0 votes
1 answer
81 views

EDIT: I do not believe the Using temporary tables in ssis package question helps me. I can't use a stored procedure because I don't have write permissions in DatabaseA. I am toying around with even ...
RamenZzz's user avatar
  • 107
5 votes
1 answer
3k views

After upgrading from SQL Server Management Studio (SSMS) v20 to SSMS v21, the "Integration Services Catalogs" is no longer visible. Steps to reproduce Upgrade SSMS from version 20 to ...
Kasim Husaini's user avatar
  • 498
0 votes
0 answers
341 views

We've recently tried to upgrade from SQL Server 2019 to SQL Server 2022 Always on. SSISDB works fine up until I add it to the availability group. Since adding I get the following error when trying to ...
Msharma's user avatar
  • 3
-1 votes
1 answer
77 views

I have following problem: I use a variable: Server=DESKTOP-156DAO6\FILEWATCHERSER;Database=testDb;User ID=florian;Password=test123321;TrustServerCertificate=true;Trusted_Connection=False for ...
Florian Berwald's user avatar
  • 1
0 votes
0 answers
95 views

We are currently using Visual Studio 2017 and have several SSIS packages that were originally developed in older versions of Visual Studio. These packages utilize Microsoft Access Database Engine (...
Satya J's user avatar
  • 1
0 votes
0 answers
27 views

I want to load 10 SQL tables into SSIS and export them to flat files. Every table needs to be exported to separate txt file. How to use for each loop to do the same?
Ganesh's user avatar
  • 1
0 votes
0 answers
31 views

I'm testing existing working package, it's in TFS and unlocked. I was able to change string on connection manager, but cannot make any changes inside the package, let's say I want to make new folder ...
Mich28 's user avatar
  • 504
1 vote
0 answers
29 views

I'm using ssis to copy excel file from a template, and update some cells on each copied files. problem is that after generating the Excel filen when opening it, the cell that is supposed to contains ...
Cascador84's user avatar
  • 163
0 votes
0 answers
49 views

In SSIS I have Oracle Connection, and within a SQL task there I have query similar to this CREATE TABLE Blah AS SELECT ... (I drop table in another task.) I deploy SSIS project and run it through SQL ...
Eric Klaus's user avatar
  • 953
0 votes
1 answer
101 views

There are similar questions in this forum and elsewhere. however, none of the answers helped me. I'm trying to read data from an Excel file with SSIS. The filename is dynamic based on a date. the date ...
waza's user avatar
  • 11
0 votes
0 answers
81 views

CONTEXT We retrieve data from a local Gas Station where the company's vehicles go to refuel their tanks in a CSV file. So we save this data: VOLUME, TOTAL_AMOUNT($), PRODUCT (gas, premium, diesel), ...
Diego DuCast's user avatar
  • 1
0 votes
1 answer
35 views

I have an Excel spreadsheet connected with an ACE.OLEDB.12.0 connection manager. I'm having an issue with a column that should contain a date, but there is invalid data in the column. Most of the ...
TimC's user avatar
  • 1
0 votes
1 answer
59 views

I have a comma-delimited text file containing 4 header rows, the first of which has metadata that I'm trying to capture. However, it has only 8 columns while the rest of the file has significantly ...
beantreeze's user avatar
  • 47
0 votes
1 answer
107 views

Currently executing an SSIS package from C#, using catalog.create_execution, set_execution_parameter_value, and start_execution, wrapped in a TransactionScope. Here's what I'm trying to achieve (Only ...
KA-Yasso's user avatar
  • 641
0 votes
0 answers
18 views

When I call the oracle stored procedure in SSIS using execute SQL task, it is running with 1 parallel thread, but when the same procedure is called from Oracle developer, it is running with 10 ...
user23424831's user avatar
  • 1
0 votes
0 answers
37 views

I newly installed mysql92 server and vs 2022 in my local machine. I tried to access mysql server in VS integration service project, but I can't see Mysql under source assistant. As alternative, I ...
romex's user avatar
  • 1
0 votes
2 answers
281 views

I am trying to migrate a SSIS package that was developed using VS2019 for SQL Server 2019 on Windows Server 2019. Now we have this new test server with the following components installed: Windows ...
sydney's user avatar
  • 131

1
2 3 4 5
…
426