Questions tagged [ssis]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions.

Filter by
Sorted by
Tagged with
2
votes
2answers
101 views

SFTP using Ciphers and Key Exchange

Previously I was gaining access and transferring files (SSIS execute process task) with a .txt file configured as: option batch on option confirm off open sftp://Username:password@hostsite.com:22 -...
0
votes
0answers
41 views

Trying to center an excel column but it centers the whole sheet?

I am generating an excel sheet from a sql query to an excel template file in ssis. I only want some columns centered, but if I center any one column in the template file, all of the columns in the ...
0
votes
0answers
26 views

Tab-completion not working in SqlServer provider

It appears that tab-completion not work for SqlServer provider objects. In the commands below, neither variables nor gettype() would tab-complete. Is this expected? Is there any setting I can change ...
0
votes
0answers
14 views

SSIS Derived Column component breaks program that executes SSIS package via DTS.Rutime

I execute an SSIS package via a small program that uses DTS.Runtime. This works fine until the inclusion of a Derived Column component in the package. I then get an error stating I need SQL Standard ...
0
votes
1answer
571 views

Visual Studio (SSDT) SSIS create new project issue

When I open Visual Studio SSDT click on new project for Integration Services Project then I get the following error.. Cannot load the component 'Microsoft.AnalysisServices.Database'. Make sure that ...
0
votes
0answers
8 views

Cannot add Microsoft.Exchange.WebServices reference to SSIS ScriptTask

I have been given a DTSX package that consists of a ScriptTask object. Within the ScriptTask there is a Reference to Microsoft.Exchange.WebServ
0
votes
1answer
36 views

SQL Server 2017 SSIS run packag in command line

We wanted to migrate to SQL Server 2017. After we set up everything, we had a problem with the performance of the server. After a few weeks, we found out that the SSIS packages requires exact 10 ...
1
vote
0answers
126 views

SSIS OLE DB Destination transfer decreased between SQL to SQL DB

Short Story, after a weekend I started getting errors about some jobs IN the SQL Server Agent failing. What I found out is that the issue is only present in X server and when I try to use a Data Flow ...
0
votes
0answers
21 views

SSIS- creating a CSV file with text qualifier "

I am trying to create a CSV file in SSIS 2012 with the text qualifier as ". I want the end quotes for each column to end at the end of the string for each field no matter how long the string is. ...
0
votes
1answer
26 views

Why is my header format applying to all cells when I insert to excel file from SSIS

I am using SSIS to export a sql query to a pre formatted template excel file. The template file has the header row formatted with text wrapping, and the rest of the rows normal formatting. I want the ...
1
vote
0answers
16 views

Re-use An Import-Mapping of a CSV into SQL Azure DB using SSMS

In https://stackoverflow.com/questions/12503430/import-csv-into-sql-azure-database-using-ssms/35876305#35876305 one solution was to save the import dtsx so as to reuse. However, I cannot find how to "...
0
votes
0answers
204 views

Run SSIS package in SQL server or run SSIS package in command line use dtexec

All, I have troubles with running SSIS package in either SQL server or in command line use dtexec. I can run the SSIS package successfully in visual studio 2017. But when I deployed in SQL server ...
1
vote
0answers
253 views

Why is my microsoft visual studio always busy?

I am currently trying to do an SISS project using microsoft visual studio. However, after i edit the project for no more then 1 minute, the software suddenly says Microsoft is delayed or busy... ...
0
votes
0answers
28 views

I have a CSV file that has 3 column. Need help to format correctly via SQL SSIS Import

I have an CSV file being dropped to a file location once a day. When SSIS picks it up it's failing due to format issue since it has 3 columns and not delimited with 1 column. Can someone help me ...
0
votes
0answers
29 views

Missing lookup item in SSIS toolbox

I am currently implementing a project for a demo using SSIS. In the tutorial I am reading, I have to add a lookup item in the flow control. But I can not find the lookup item. I have tried several ...
0
votes
1answer
2k views

Unable to uninstall SQL Server Integration Services Projects Extension

I installed SQL server, then SSDT from VS installer and after that the SSIS Extension v3.0 for VS Community 2019. But now that I try to uninstall it I get the following error: Some components will ...
0
votes
0answers
9 views

SSIS Attunity Connector dropping conection

I am having an issue with our Oracle connection dropping. We are using the Attunity connector provided by Microsoft to establish these connection. How many concurrent processes can be running at a ...
1
vote
0answers
125 views

How do I increase the font size in SSIS?

I have a new windows instance on which I am running SSIS and the font sizes are so tiny I have to squint my eyes to see the names and text. Is there a way to increase the text font size ? Now I have ...
0
votes
0answers
10 views

Visual Studio 2010

I am modifying a SSIS package that was created by my predecessor, and am running into a very frustrating issue. I simply added 2 columns to a csv file that that is exported and saved to a ftp site. ...
0
votes
0answers
109 views

Issue while importing CSV file, having data with double-quote(") ,to database via BIDS 2008

Trying to import a csv file from flat file source to OLE DB Destination table using SSIS 2008. The CSV has text qualifier as double-quote(") and Column Delimiter as comma (,) but there are few rows ...
0
votes
0answers
127 views

Running SSIS package with script component on SQL Server 2016 gives error : Component Mismatch Exception

I have SSIS project deployed on SQL Sever 2016, the project has a package that uses script component, the package runs with no errors locally on VS 2017 but when deployed gives the Error. Solutions ...
0
votes
1answer
16 views

SSIS won't download data to Excel Spreadsheet

I have data being downloaded to 2 different tabs in an excel spreadsheet from SSIS. The first tab gets data, I see the data I want in the 2nd tab in the data viewer but when I retrieve the ...
1
vote
0answers
90 views

Error in import SSIS package in SSDT Visual Studio 2017

enter image description hereI want to import an SSIS package into SSDT Visual Studio 2017 but while doing so I am getting an error i.e. Unable to create the type with name "Azure Storage".(Microsoft....
0
votes
0answers
17 views

SSIS Package Failue

I'm running a package that gets data from a MySql Server and loads data into a SQL Server database. This all works in my development environment fine until I deploy it to the server. Drivers are ...
1
vote
0answers
33 views

How to check which SSIS package updates my table?

I am troubleshooting some missing QlikView data. My setup is: Source ERP -> ODBC + SSIS -> SQL Tables -> SQL Views -> qvw creating qvd's -> loading qvd`s -> front end design There is some data ...
0
votes
1answer
155 views

After installing SQL Server Studio 2017 with Integration and Reporting services, in the Integration Services Catalogs- Create New Catalog shows error

SQL SERVER Management Studio 2017 - The error says "The catalog backup file 'C:\SQL\SHARED\X64\140\DTS\Binn\SSISDBBackup.bak" could not be accessed. Is this error fixing requires "Integration ...
0
votes
1answer
107 views

Running SSIS project take over c drive

I have a SSIS project that loads almost big data in OLEDB Source component and with some changes, Insert them in another destination. when I run this project with SSDT, It takes all of free space in ...
1
vote
1answer
72 views

Check Status of All SQL Services

I wanted to List all the SQL Services including Reporting Services. Wmic service where (PathName like '%Binn\%sql%') get caption, name, startmode, state, PathName, ProcessId This one will give all ...
0
votes
0answers
204 views

FTP connection failing when runing SSIS package with SQL Agent

I have an SSIS package that is fully functional that generates files and places them on to my ftp server. I have a connection manager for my FTP server and have the ftp server details and credentials ...
2
votes
1answer
3k views

Visual Studio 2017: “Extension Microsoft integration services projects 2.2 likely caused 43 seconds of unresponsiveness”

extension Microsoft integration services projects 2.2 likely caused 43 seconds of unresponsiveness ISSUE: Visual Studio is VERY slow for Microsoft Integration Services with VS 2017. not possible to ...
2
votes
1answer
274 views

Does IIS FTP Lock Files when Client is Downloading?

I've been sent here from the nomral Stack Overflow with my issue TL;DR : Does IIS FTP service lock files while said files are being accessed, specifically downloaded, by an FTP client? So I've got ...
0
votes
1answer
3k views

Navigating to folder structure of remote server

I am aware that this is a really simple question and maybe that's why I haven't found a simple and concise answer. My task is the following: I am using SSIS to connect to a remote server and save ...
0
votes
1answer
406 views

(SSIS) Data Flow Task – export SQL to excel file

I'm looking for a solution / tutorial following case. In the MS SQL database I have two tables (invoice, invoice item). I need to export data to excel. My problem is the structure of the export ...
0
votes
1answer
788 views

how to find out session id of executing ssis package through SP_target

I am executing a ssis Package which contains only one data flow task. Simply SELECT statement in source and Table in destination. I want to find out session id of this running Package in SP_TARGET. I ...
1
vote
1answer
1k views

SSIS Package Corrupted - How to resurrect?

A SQL Server SSIS project is corrupted when I pull it up in Visual Studio. However, the job behind this project/package is still running correctly and it is creating the proper extract file. Is ...
11
votes
1answer
25k views

When will SSDT-BI be available for Visual Studio 2015

From Microsoft's download page, SSDT-BI (SQL Server Data Tools Business Intelligence) for Visual Studio 2013 is available but not for 2015. When will Microsoft release SSDT-BI for VS 2015? https://...
4
votes
2answers
13k views

Visual Studio 2015 SSIS compatibility

Does the 2012 SSIS install that was for VS2013 work in 2015 or does 2015 have the SSIS/BIDS and Reporting components built in?
0
votes
3answers
763 views

I need to make a master Excel workbook that references other workbooks so I can search for items in one place instead of multiple Excel sheets.

I have co-workers that keep track of product they work on using an Excel workbook, each person has their own. Currently if I want to find out who worked on an item, I have to search each workbook ...
4
votes
2answers
31k views

automatically Save outlook attachment

Is there a Windows-based method that can automatically pull save email attachment from a outlook 2010 to a server? I get aan email daily with an attachment that I manually save to a folder on a server....
1
vote
1answer
2k views

Import PGP key to windows user for SSIS

I have used Kleopatra to generate a pgp key. In SQL Server I am running an SSIS package that should decrypt files using the above key. The SSIS packages runs as ImportFiles which has the identity of ...
3
votes
2answers
9k views

Event log warning Registry setting specifying configuration file does not exist

Microsoft SSIS Service: Registry setting specifying configuration file does not exist. Attempting to load default config file. For more information, see Help and Support Center at http://go....