Ask Question

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.

20,412 questions More

• Bountied 0
• Unanswered
• Frequent
• Score
• Unanswered (my tags)

Apply filter

1 vote 1 answer 96 views

SQL Job Execution Issue in SQL-Server 2012

I am Executing an SSIS Package in SQL-Server 2012 through SQL-Job. Individual package is getting execute in Visual-Studio and also after releasing it on Service-Catalog (Just for testing). But When I ... ssis sql-server-2012 sql-job Irfan

• 645

asked Jan 30, 2019 at 7:47 5 votes 2 answers 7k views

Is a licensed version of Visual Studio required for SSIS solution?

Is it possible to open a SSIS solution using Microsoft's free tools (Visual Studio Team Explorer and SQL Server Data Tools) or does it require a full installation of Visual Studio? I am trying to do ... visual-studio ssis Thorin

• 151

asked Jan 30, 2019 at 0:06 4 votes 2 answers 5k views

Get ROWCOUNT for all actions performed in MERGE Statement

I amazed myself with this MERGE statement, the company isn't truly doing a Type 2 Slowing Changing Dimension but close. Oddly it's not even analytical data but let's ignore that horrendous decision. ... sql sql-server merge ssis etl ChristianProgrammer

• 358

asked Jan 29, 2019 at 21:05 3 votes 2 answers 7k views

SSIS : how to run stored procedure in Data Flow Task

I have a Data Flow Task that does this: From OLE DB Source, run a SQL Command to select some data Lookup to a different SQL DB Source, check if the data already exists or not Based on Lookup Match ... sql sql-server stored-procedures ssis etl ichachan

• 615

asked Jan 29, 2019 at 20:12 1 vote 1 answer 76 views

SSIS : Excel Source detection type

i'm currently working in sql server 2012, and OLEDB JET provider 12.0. excel 13. i have to import many excel files ... but this bloody provider doesn't detect the rigth type in a very wierd and ... sql sql-server excel ssis Badr Erraji

• 131

asked Jan 29, 2019 at 18:28 0 votes 0 answers 193 views

Unable to debut SSIS Script Task with VS 2017 15.8.7 and SSDT for SQL 2016

I have an SSIS Project built in Visual Studio 2017 with Data Tools for SQL 2016, and I'm unable to debug any of the Script Tasks. I create break points which shows the red dot in the designer, but ... debugging ssis sql-server-data-tools ssdt-bi Sam Alex

• 63

asked Jan 29, 2019 at 18:12 1 vote 1 answer 306 views

Data Flow Violation of PRIMARY KEY

I have a package that do ETL between 2 data bases. For get the datas of data base source I use triggers in tables, so my datas are save in new table of agree with type of transaticion: insert, update ... sql-server ssis user11890

• 150

asked Jan 29, 2019 at 12:57 0 votes 0 answers 140 views

How to export from SQL Server using SSIS - Excel Destination - into an existing excel table

I'm having trouble exporting some data from SQL server (Azure) into an existing excel table using SSIS. Using the SSIS component "Excel Destination" and pointing at the sheet containing the table, ... sql-server excel ssis Weevie

• 33

asked Jan 29, 2019 at 10:57 0 votes 2 answers 1k views

What does ISPAC stands for (in SSIS)

Can anyone tell what ISPAC stands for (in SSIS) please. Today a junior DBA asked me this question, which I attempted to find out, googled it, looked through Microsoft documentation etc. to no avail. ... sql-server ssis Eddie Kumar

• 903

asked Jan 29, 2019 at 10:43 1 vote 1 answer 1k views

SSIS Package issue after upgrading from 2008 to 2017

I had a requirement to upgrade SQL server client from 2008 R2 to SQL server 2017. Previously i used SSIS packages build with SQL server 2008 R2, while upgrading the server i am facing connectivity ... c# asp.net ssis ssis-2017 Akilan Deivasikamani

• 21

asked Jan 29, 2019 at 10:42 2 votes 1 answer 5k views

Who disabled a job in SQL Server Agent

I have a job in SQL server Agent. Now I see that this job is disabled. Multiple people can log in to server and can modify jobs (department policy). I want to find out which user disabled this job. sql sql-server ssis sql-server-agent user2352554

• 511

asked Jan 29, 2019 at 5:09 1 vote 1 answer 83 views

SSDT2012 version SSIS package can be execute on SQL Server 2012?

I have upgraded my VS2005 - SSIS project to VS 2013 (SSDT2012). And I am using SQL Server 2012. Where I need to execute SSIS package using Integration Service Catalog for SQL Server job. But I get ... sql-server ssis sql-server-2012 ssis-2012 sql-job Irfan

• 645

asked Jan 29, 2019 at 1:23 0 votes 0 answers 70 views

How to pass sharepoint credentials in my code?

I have C# code that goes to all the libraries in sharepoint on-premises and gets all the files and put it inside an azure file share. The thing is I am executing it from the azure ssisdb and I am ... c# azure sharepoint ssis azure-data-factory deadtest

• 163

asked Jan 28, 2019 at 17:25 3 votes 1 answer 119 views

Code only converting last worksheet to csv

I wrote a program in C# that is supposed to convert each worksheet in my excel workbook to a csv and save it in their own files. The problem I'm having is that when I open each file, they all have the ... c# excel csv ssis script-task jim

• 878

asked Jan 28, 2019 at 16:34 1 vote 1 answer 958 views

date based condition in ssis

I tried the below code in my where condition in sql server and it is working. When i try to implement the same in SSIS conditional split transformation i am getting errors. Can anyone please guide me ... sql sql-server ssis abhi234u

• 13

asked Jan 28, 2019 at 15:53
15 30 50 per pagePrev 1…306307308309310…1361 Next