Questions tagged [ssis]

1

votes
1

answer
4.4k

Views

How to download SSIS Packages from SSISDB

I'm still fairly new to SSIS. I've figured out how to download packages from a server by connecting to Integration Services. How do I download packages from SSISDB? Background: We have a TON of packages that the previous people created. All packages SHOULD be kept in the same folder structure on...
Rich Uchytil
0

votes
1

answer
11

Views

Optimizing SSIS package for millions of rows with Order by / sort in SQL command and Merge Join for millions of rows

Hi i am currently trying to optimize an SSIS package when i do an Upsert/delete which handels about 93+ million rows from a table in a remote MariaDB source. The table also contains approximately 63 columns. Currently i'm using Sort and Merge Join in my package but as i've read some guides its recom...
John
1

votes
1

answer
39

Views

Zero not returning in DB2 when select query yields no result

I am running the below select query in SSIS which is using DB2 connection. SELECT (SELECT COUNT(*) FROM tbl.Test) AS NoOfDest FROM tbl.Index FETCH FIRST 1 ROW ONLY; When this query yields no result, I am getting the below error in SSIS. single row result set is specified but no rows were returned....
Shesha
1

votes
2

answer
32

Views

Import from XML drops leading 0

I have an SSIS package that imports an XML file into SQL. The data of one particular field could be '112' or '039', for example. It is always three characters and gets padded with a leading 0 if only two. The Destination field in SQL is varchar. For some or other reason SSIS is changing it to DT_UI2...
opperman.eric
1

votes
1

answer
13

Views

How to use variable in select statement?

I'm trying to use the logic for using SSIS select top 2 * from table How can I replace 2 with variable name and make it customize?
Tirath Singh
1

votes
0

answer
14

Views

SSIS Package in SSMS - ADO NET Source has failed to acquire the connection - Could not create a managed connection manager

I have some problems with getting my SSIS Packages to work from my Azure SQL SSIS DB in Azure. I built the SSIS packages in VS and they run without any problem. What i am doing is getting data from a remote MariaDB (Source) with a '.NET MySQL Data Provider (mysql-connector-net-8.0.15)' and inserting...
John
1

votes
3

answer
48

Views

In the SSIS Export package, How to rename the destination excel file with time stamp attached to it?

In the SSIS Export package, How to rename the destination excel file with time stamp attached to it? I have Excel as my Destination file. How to rename the destination file with time stamp attached to its suffix? such as myfile_010120191100.xls Generating dynamic file name will help us to avoid o...
goofyui
1

votes
2

answer
126

Views

JSON Serialization in C# SSIS

RESOLVED: I stopped treating the string like an array and instead added a line-feed delimiter to the connection manager, so that each row was treated like a new line. This has resolved the issue and eliminated the need to handle this via a C# script. I've built an SSIS package that uses a C# script...
SamFarr
0

votes
0

answer
5

Views

Importing Json data into SQL table from a web page by using SSIS

I have a web URL it has Json data as shown on the image, I need to export the Json data from the web page into sql table by using ssis. I need some help please. Json data from web page
Jenn
1

votes
1

answer
54

Views

Is there a simple method to import data from multiple excel flies to SQL including names of the files using SSIS?

I need to import salary data from multiple excel files where filename of each file is a date. I used SSIS and with success followed typical tutorials for importing multiple excel files. The thing is none of them show simple method how to add one extra column (with the name of the file) to the resul...
Kilma
1

votes
0

answer
24

Views

SSIS - Write a log in existing package

I would like to include a log to check the DB source in existing package to track DB source details in different environments. This is existing package and I am totally new to SSIS. I am not sure how to implement in SSIS package. Is there any built in functionality available in SSIS 2008? It would...
Ask_SO
1

votes
2

answer
523

Views

running SSIS package as SQL agent job failed

I created SSIS an project, which exports some data to Excel. In Visual Studio 2017 it works fine, but when I run it using a SQL Server Agent job (MS SQL Server 2017), it throws this error: 'Executed as user: Administrator. Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for 32...
WhiteB1
1

votes
0

answer
62

Views

SSIS: Sequence container counts Warnings as Errors

I'm debugging an SSIS package that I've just developed. I've found the package failed because a sequence container is Red though all the tasks on it are green. I checked the process results and found there were 4 Warinigs (=exclamations) and no fatal errors. I want to have the container ignore Warni...
yobioo
1

votes
2

answer
74

Views

SSIS SCD Wizard with multiple incoming records

PlEASE FORGIVE. I am very desperately looking how to ask this eloquently. Not doing to good here. In SSIS, if you have an incoming dataset that has multiple records for the same PK (like intraday records in a daily processing method), how do I tell the SCD Wizard to expect that? in my case, even th...
arcee123
1

votes
0

answer
53

Views

Error Message in vs2015 enterprise

my machine has VS2015 enterprise installed with following settings: Microsoft Visual Studio Enterprise 2015 Version 14.0.25431.01 Update 3 Microsoft .NET Framework Version 4.6.01590 SQL Server Analysis Services 14.0.806.134 SQL Server Data Tools 14.0.61707.300 SQL Server Integration Services V...
rt2800
1

votes
0

answer
112

Views

SSIS package failed to execute ssrs report from schedule job

i have a problem with ssis. when I run it manually, the process runs smoothly and its reports are formed. but when I run it with a schedule job in the sql server, the job is successful but the report is not formed. in the task script settings (task to generate ssrs) I have set to save the credential...
irfan kusuma
1

votes
0

answer
150

Views

how to run SSIS packages from within AWS

I would like to know if there's a way to run ssis packages without using windows authentication.If running ssis package using sql authentication is possible, i will take that as well.
MJ8
1

votes
1

answer
304

Views

Best way to Move/Merge Tables between 2 Azure SQL databases

I have 2 Azure SQL databases, each with identical schemas. Each database has about 200 tables. I need to MOVE the data from 70 of the tables in db1 to db2 I need to MERGE the data from 5 of the tables in db1 to db2 One of the tables involved in the MOVE has 120 million rows and is 100GB in size. Of...
Terrence
1

votes
0

answer
206

Views

Why do datetime values from AD show up as 'System.__ComObject' in SSIS?

I am trying to create a package in SSIS that will read values from my AD and save into a table in a database. When I run this query: SELECT * FROM OpenQuery ( ADSI, 'SELECT whenCreated, whenChanged, [...], badPasswordTime, sAMAccountName FROM ''LDAP://mydomain.com/OU=ouUsers,DC=MYDOMAIN,DC=com'...
azulu
1

votes
0

answer
221

Views

SSIS Package execute returns Failure, but no errors or execptions appear

I'm having a big issue with executing SSIS package from c# code. Package is loading fine, I can see all its parameters, values etc. But when it comes to executing the package it runs fine, no errors on package, no exception on application site, but the result is Failure. My package is really simple...
marczulajtis
1

votes
1

answer
55

Views

SSIS Data Tools for SQL Server 2014 (none of vb.net script tasks are working, even with default code)

I have installed SQL Server 2014 Data Tools. When I add the script task and use C#, it work. But when I add script task and choose vb.net 2012, and then clicked on edit script and save. After that click ok and getting this error message for all scripts, please note that I have not even added vb.net...
user3577355
1

votes
0

answer
35

Views

SQL Server database table to oracle server using WebAPI [scheduled]

I have an application which is build recently and pushes data into SQL Server. And I have another application which uses an Oracle database and gets data manually so far. Now I need a way how I can insert the data that comes into SQL Server into Oracle daily. Is there a way to do this with Web API i...
Surendra Rayapati
1

votes
1

answer
154

Views

DownloadString works for HTTP but not for HTTPS

I have webclient call in my SSIS package which call an API to get JSON response. using (var mySSISWebClient = new System.Net.WebClient()) { mySSISWebClient.Headers[HttpRequestHeader.Accept] = 'application/json'; var result = mySSISWebClient.DownloadString(jsonURLwithDate); } When I change the URL to...
Sam
1

votes
0

answer
41

Views

VS 2015 Executing SSIS Package Error

I have an SSIS package that when I run them from within VS 2015 Update 3, fails on a step. I asked another developer to try running the package on his machine, and it works fine on his machine. He also has VS 2015 update 3. [name of step] Error: The [name of step] was unable to process the data. Ob...
Rick Hodder
1

votes
1

answer
30

Views

Determine segregating SQL column in known sets

I have a known target set of records in a large Oracle DB table that I want to pull. Rather than querying them by ID though, I want to find a a column within the table that holds a value(s) that is only assigned to the known set and not assigned to any records that are not in the set, thereby giving...
BradV
1

votes
1

answer
54

Views

How to perform a join on two tables in an SSIS package, where the table names are dynamic

Just for reference, this question is more or less a follow-up to this question which I asked a few weeks ago. In that case I suspect the problem was essentially that I had picked up someone else's incomplete code and was trying to update it without completely understanding what they'd been trying t...
Nick
1

votes
2

answer
84

Views

SSIS 08 job runs a SSRS 08 report but fails when ran in SQL Server

I have created an SSIS package (08) that has a script task which runs an SSRS report (08) with given parameters. The report creates a pdf version of the file on a file share drive of my choosing. When I run the SSIS manually it works perfectly, however, when I upload SSIS into SQL and then run it...
Marie
1

votes
0

answer
87

Views

Error OData Source SQL Server 2016

I'm using SQL Server 2016 with SharePoint 2013. I'm trying to access to SharePoint List. I use the OData Source in my Package. The connection works succefully and I can preview (with the Preview button) data from the list. But, when I try to execute it got an error : Error: La connexion « Connexi...
Sara
1

votes
2

answer
391

Views

SSIS 2012 Error Output from Ole DB Command

I have a SSIS Package that calls an OLE DB Command to Update/Insert/Delete records from the data flow. Now the problem is occasionally the command may error, due to duplicate Key errors, missing required columns or whatever, and I want to log these errors because the SSIS errors are cryptic and don'...
MBulava
1

votes
1

answer
266

Views

Job failure on OData - OData source was unable to process the data

I have a SSIS package which pulls data from OData source and stores it in database at local server. This package runs perfectly at a scheduled time daily but sometimes the package execution fails and i get the job failure notification. The error comes as 'OData source was unable to process the data...
mrityunjay kumar
1

votes
2

answer
1.5k

Views

SSIS Package stopped working with Error code: 0x80004005

I got this SSIS package working this past December. It only runs on Friday mornings. Last Friday it failed with this error message: Package:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: 'Microsoft Access Databa...
Mike
1

votes
2

answer
254

Views

SSIS redirect empty rows as flat file source read errors

I'm struggling to find a built-in way to redirect empty rows as flat file source read errors in SSIS (without resorting to a custom script task). as an example, you could have a source file with an empty row in the middle of it: DATE,CURRENCY_NAME 2017-13-04,'US Dollar' 2017-11-04,'Pound Sterling' 2...
Грозный
1

votes
1

answer
270

Views

Transfer SQL Server Objects Task Error: Execution failed with the following error: “Invalid column name”

I am using Transfer SQL Server Objects Task in SSIS to create a package for copying procedures from prod to dev. [Transfer SQL Server Objects Task] Error: Execution failed with the following error: 'Invalid column name XYZ' Any help on the above error will be appreciated. Raghu SQL Server Objects T...
Raghu
1

votes
2

answer
109

Views

SSIS Data flow task implicit conversion automatically

I have following scenario: I have one data flow task with OLEDB source, taking data from source tables using query with inner join. One of the column is varchar(8) and few values are float, rest are int into this column. The OLEDB destination is storing above data into a table where corresponding co...
Murali Dhar Darshan
1

votes
0

answer
209

Views

SSIS package connection is not working in sql server agent

I'm trying to connect to a AS/400 system with a IBM DB2 for i5/OS IBMDA400 OLE DB Provider as a connector. I want to write data to a table in the AS/400 system and read data from the same location. So I build a package that writes data from a sql server db on a SQL Server 2008r2 to the AS/400 syste...
chr1s84
1

votes
1

answer
1.9k

Views

Run a SSIS Package outside of SSDT (2017)

I have searched multiple forums and found question similar, but doesn't match my environments. Problem: Cannot execute a package within a package Error: To run a SSIS package outside of SQL Server Data Tools you must install st_Check_Files of Integration Services or higher. SQL Server 2017 info SSMS...
Dan Peter
1

votes
1

answer
64

Views

Run Azure Automation runbook after SSIS completed loading data into Azure SQL DWH

I have a scenario where after lift and shift load from on-premises to Azure SQL Datawarehouse is done using the on-premises SSIS, I would like to trigger the Azure Automation runbook. Is there any way to get this done.
1

votes
1

answer
419

Views

MSSQL 2016 Package execution failed | SSIS error: Index was out of range

I've made a copy job with Copy Database Wizard using SMO(leave DB online). The DB is to be copied to the same SQL instance. This fails with The package execution failed. The step failed. If I execute the SSIS package it has created, the following occurs: Event Name: OnError Message: Index was out...
Vaskemaskina
1

votes
0

answer
149

Views

DownloadString return 502 bad gateway error from SSIS script task

I have a webapi from which I am getting JSON data by using WebClient DownloadString method. When I run the URL in the browser, I get the JSON response, but when I run it using SSIS package, it is failing at DownloadString call with the following error. [Download Json] Error: Download failed: The re...
Sam
1

votes
0

answer
33

Views

SSIS package - wont run from SqlAgent but ok when run Manually

I have a SSIS package that references a remote database through an OLE DB connection to remote database. The connection is using a SqlServer account on the remote database and this all works fine. When I enter the password in Visual Studio Package editor I have the 'save password box' ticked, and i...
Ab Bennett

View additional questions