Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [ssis]

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

1
vote
1answer
48 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
16 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 ...
0
votes
0answers
21 views

Oracle connections broken in SSIS after uninstalling 32bit version of oracle client

I originally had 32 bit and 64 bit version of Oracle 12 client installed on my work machine. I uninstalled the 32bit version, because it was causing some conflicts with another application, but now ...
0
votes
1answer
213 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
44 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
527 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
287 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
559 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
902 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 ...
10
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
607 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 ...
3
votes
2answers
28k 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
8k 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....