Questions tagged [ssis]

SSIS (Microsoft SQL Server Integration Services) is a platform for building enterprise-level data integration and data transformations solutions. SSIS is used to perform ETL operations; i.e. extract, transform and load data.

1
vote
2answers
16 views

I want to compare the row count of two different Excel files in SSIS get an email alert

I am looking for a way to compare the row count of two Excel files in SSIS, and if the row count of one of the files is >= the row count of the second, I would like to receive an email informing me of ...
0
votes
0answers
12 views

For Loop Container in SSIS(Using Nested for loop)

I need to load data for four financial years every day(Around 60 Million Rows). In order to achieve that I created a for loop container which is for Financial year(comparing two variables StartYear ...
1
vote
0answers
19 views

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER- have tried everything

I have created a SSIS package and I am trying to run it locally. We use package configurations that point to sql tables and a XML config file. The package ran successfully for about a week, even when ...
1
vote
1answer
8 views

How capture an error like “Package Validation Error”

I what to read some Excel files put by users into a share folder. The issue occurs when the user changes the sheetname or changes the location in some rows or columns used to share data. In this ...
1
vote
0answers
14 views

SSIS how to execute dll in script-task (SharePoint function not found)

I can not use a specific DLL in SSIS script-task. In c# console-project anything is fine. SSIS throws the error: Error: The Type "Microsoft.SharePoint.Client.ClientRuntimeContext" in assembly "...
0
votes
0answers
17 views

Error in dynamic connection string for Excel

I have an sql server connection( source ) and an Excel destination on my d:/ drive. I would like to rvide a dynamic file name to the excel file using a expression: In the connection manager: ...
0
votes
0answers
17 views

How to assign a mapped column to a variable in update editor?

I need to assign a value that comes from column mapping to a variable that I've just declared, but the package throws a syntax error. I've tried setting the variables with string values and it works, ...
0
votes
1answer
10 views

How to run HTTP connection from a front-end application

I am integrating Quickbooks using SSIS to pull data into our SQL Server Database. The SSIS works fine but the problem is when I run the package from the front-end application. It cannot run it as the ...
-1
votes
0answers
13 views

Connecting to Postgresql through SSIS using PSQL

I am trying to connect to postgresql db through ssis execute sql task by calling psql.exe. have anyone ever tried that on SSIS?
0
votes
0answers
16 views

T-SQL Update task works with generic values in MSSQL but is not working on SSIS with variables

Trying to update a field after an e-mail is sent to it can reflect on that. I've already tried some things but I am not sure how to troubleshoot this... It gives me the green check on SSIS package ...
2
votes
1answer
21 views

Wants to connect oledb with mysql in ssis

I am working on a project where i have to get data from MySQL using OLEDB data source. I am facing a issue while connecting Ole db data source with MySql. I am using VS2015 version and i want to ...
0
votes
2answers
34 views

Flat file data extraction through SSIS with column name and data in same rows

I have to extract data from multiple folders. Each folder can have multiple text files. Text files can have multiple rows. If multiple rows are there there would be possibility of each row can have ...
1
vote
1answer
16 views

Jenkins - Visual Studio Command line arguments

Planning to Build & Deploy SSIS Projects(ISPAC) or Database Solutions (DAPAC) from Jenkins using Visual Studio Command line arguments. Question: I know i can execute Windows batch commands but i ...
0
votes
0answers
16 views

How to solve 0x80004005 error in Visual Studio while creating a Dimension Table

I'm starting from a database, let's call it D1, created by me and an empty data-warehouse. Using SSDT I'm trying to populate the dimensions of my data-warehouse from the D1. I'm doing a merge join ...
2
votes
1answer
17 views

SSDT Microsoft.AnalysisServices.Server connect throwing “Value cannot be null error”

I am trying to connect OLAP cube server from SSIS using script task(C# .net). I am getting following error "Value cannot be null". I am using the SSDT 2017. The same was working from BIDS 2008. ...
-1
votes
0answers
10 views

Ssis deployment

how to handle project parameter in git release. Details: I am using json as configuration. Deploying Ispac and json on ssis catalog version 2016. How should I tokanize variable value for project ...
2
votes
0answers
31 views

Trying to get the zip files via SFTP using SSIS script task (C#) [duplicate]

I am trying to connect to winscp and using below code as a reference to get the zip files from SFTP server. I have added reference for the WinSCPnet.dll assembly. I want to download the ABC_EMP.txt....
2
votes
0answers
41 views

SSIS package containing script task getting failed in Azure Data factory

I have recently moved SSIS packages (with target server version as 2016) to azure SQL database. I have followed below steps: Created azure ssis IR in azure data factory Created pipeline with execute ...
3
votes
1answer
50 views

SSIS SQL Executation Task error: unable to run some sql queries

I'm working to make some fact tables (taking some data from some resources, doing some transformations and putting them in a table). My main dilemma is that I can't run any SQL query other than select,...
2
votes
1answer
36 views

Custom dlls not found in SQL Server 2016 agent job

I have an ssis package in SQL Server 2016 which is using a custom dll that I have added in the gac. SSIS package works fine in visual studio but when I deploy it on SQL Server, it can not find the dll ...
-3
votes
1answer
21 views

While Creating SSIS Catalog ;I get fail about code PAGE

I can not create SSIS catalog. When I try to this, Iget this message: The code page 65001 is not supported by the server. (Microsoft SQL Server, Error: 2775) I searched but I could not find any ...
2
votes
3answers
80 views

error with ssis package in sql server job

Help solve the problem. There is a ssis package which in visual studio runs without problems, but returns an error in the sql task. The packet in the work takes the data from sql server and writes in ...
2
votes
1answer
25 views

Building SSIS 2014 Project deployment model from cmd line

Build SSIS 2014 Solution/project from cmd line is not working Used several scripts with no luck. C:\Users\Source\Repos\ETL "C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\...
2
votes
1answer
21 views

Query SSIS Configuration In 2016 SSISDB

I need to query the SSISDB to view the configuration information of each package. I can easily view the package names and their folders but am unable to query the XML behind it and more importantly ...
2
votes
1answer
36 views

SSIS Package Runs Manually but Not from SQL Job

I get series of Errors when SSIS package (deployed in file system) Executed from SQL Job , but same package works fine if executed manually. First Error : Directing the row to the error output ...
0
votes
1answer
38 views

How to convert a numeric value in a Object to String to be sent in an Email Task?

I'm trying to send an e-mail with values read from the database. So I have an Execute SQL task that Selects data from the db, the values are returned into an Object Variable, after that I have a ...
1
vote
1answer
42 views

ssis moving data between sql and access databases

In SQL Server Data Tools 2015, I would like to move data from a SQL Server 2012 database into a new access database(2005) and need to create the access table as part of the process. Can this be done ...
0
votes
1answer
26 views

How to update TFS older version of SSIS package to currently deployed version?

Using Visual Studio 2015, I checked an older version of an SSIS project into TFS. Now I want to update that version in TFS to the one currently running in production. I know how to get an *.ispac ...
2
votes
0answers
26 views

OraOLEDB ORA-01840: input value not long enough for date format

I have the following SQL in Oracle: SELECT CE.ENCNTR_ID AS CernerEncounterID ,TO_DATE(S.ACTIVE_STATUS_DT_TM,'YYYY-MM-DD HH24:MI:SS') AS ...
1
vote
0answers
42 views

How to set up OnError Event for Parent and Child Packages in SSIS

I am using 2016 version and have a master ETL_Extract package where I am executing three Child packages(ABC,DEF,XYZ) using Execute Package Task. I would like to capture the System::Error_Description ...
2
votes
2answers
26 views

SQL Select to SSIS Derived Column

I have this Select Query. SELECT REPLACE(LTRIM(REPLACE('000010A', '0', ' ')),' ', '0') '000010A'= Customer_And_Partner_Account_Nr I would want to Create a New column while loading data through ...
0
votes
2answers
41 views

SSIS Data Viewer not displaying correctly

Would like to seek your help regarding a Data Viewer bug. I am performing a simple Extract and Load with Data Viewer enabled. However when run the Data Viewer screen did show up, but it displayed a ...
0
votes
0answers
27 views

How to implement Row-Level-Security (RLS) in a SQL-Server database 2015 using AD groups?

I have a SQLServer database containing employees working in different provinces of the country. I'm trying to automate a report in SSRS that will be sent to executives. This report should only display ...
1
vote
2answers
34 views

Pivoting row values in one column based on values in two other columns

To expand upon my last question regarding a SQL query or C# code that can pivot or transpose values in one column into distinct columns based on data from another column: Upon further inspection of ...
1
vote
1answer
37 views

SSIS package can't access directory when run on SQL Server

I am running a SSIS package which includes a script to check if a file exists. When I run this in Visual Studio under my Windows credentials, it works fine and can find the file within the directory ...
2
votes
1answer
36 views

C# or BIML code for inserting records into db

I want to insert values into database when the biml code is ran and the package has completed expansion is this possible using BIML or c#? I have a table called BIML expansion created in my DB and I ...
2
votes
0answers
19 views

ODBC error when executed by SQL JOB AGENT

I am getting an error when I try to execute my SSIS Package by the Job Agent. If I run through Visual Studio it runs perfectly. The error is: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The ...
2
votes
1answer
22 views

XSD and SSIS: Error finding globally declared complex type

I finished writing my XSD for my XML and when I started to map it in SSIS, I've encountered an error saying: "There was an error setting up the mapping. Type '[my globally declared complex type]' is ...
3
votes
1answer
25 views

What image is used to automate SSIS package deployments to SQL Server through bitbucket cloud?

I'm trying to automate the deployment of an SSIS package to a SQL Server instance's Integration Service Catalog, using bitbucket cloud pipelines. Visual Studio based apps are normally fine, as you ...
0
votes
0answers
29 views

Is it possible to pass null value when the table is not present in the source database

I am trying to make a Dataflow Task which can be used by various clients. Here I am using two oledb commands to fetch values from two similar tables and ingest it in one staging table. When the client ...
0
votes
0answers
24 views

PrimeOuput start time is null after many hours?

Problem: My ETL (Deployed on SQL Server) is hanging on dataflow where it is extracting (from Oracle Source Attunity driver) information. In the past, it has processed 6 mil records. However in this ...
0
votes
2answers
36 views

Oracle connection issues from SSIS

Getting connection error on oledb source from the SSIS package to import the data from oracle to sql server. It is failing after deploying to server but runs fine when being run from BIDS from local ...
0
votes
0answers
33 views

Add data from column in source table to new column in destination table

I have a column organization in my source table and I need to add that same column into my destination table and I need to make sure it lines up with the correct AccountID. How can I do this in ssis ...
0
votes
0answers
25 views

Oracle: cannot convert between unicode and non-unicode string data types?

I created an SSIS package that will copy data between two Oracle tables in different databases. The only difference between both tables is the table name; both source and destination tables have the ...
0
votes
1answer
15 views

Could not find server error when parsing the import query

I'm trying to create a new import SSIS package on my production server. I'm receiving an error that I didn't receive on my development server. I'm using the SQL Server Import and Export Wizard ...
0
votes
1answer
13 views

SSIS won't save DB password

I'm trying to test an SSIS package. I have a connection manager pointing to a SQL Server DB. I edit the Connection Manager, SQL Server Authentication is selected which is what I want. The user name ...
3
votes
1answer
40 views

Using 'for' command to find and download the latest file on SFTP server in PSFTP

I have gone through the following guide to set up an SSIS package to retrieve a text file located on an SFTP server: https://www.mssqltips.com/sqlservertip/3435/using-sftp-with-sql-server-integration-...
2
votes
2answers
43 views

SSIS Lookup Expression for Formatting a Date in Dynamic SQL

I have a variable in my SSIS package. @LastFridayDateTime = Datetime Datatype = DATEADD("hh",17,(DT_DBTIMESTAMP) ( (DT_STR,30,1252) (DT_DBDATE) (DATEADD("dd", -1 - (DATEPART("dw", getdate()) % 7), ...
3
votes
1answer
43 views

How do I solve (use) ETL when columns and rows are unmatched from flat file

I have 2 large files, an Excel spreadsheet and a csv file, which are messed up, but still need to be uploaded into a table. I'm in progress learning how to use SSIS. Assume the columns and rows look ...
2
votes
1answer
34 views

SQL SERVER job is not executing SSIS

I have created SSIS by using SSDT 2015 and it is executing properly with in the SSDT tool, but when i try to run the package via SQL Server agent job it gives below error. need help. Message: ...