Is there a way to conditionally (through a script task or anything else), control the flow of program in SSIS? Currently I have a package that would create 5 different excel sheets (through Execu...

Query should output a certain list of Items, along with info like store information and manager info. Uses a Cursor to flip through list of various different levels of management, selects relevant ...

While creating an SSIS package for SQL Server 2008 i run into the following error: Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transact...

I am pretty confused with the plethora of OLEDB providers found in creating a connection to a database in SSIS 2008 R2. I would much appreciate if you could tell me what the following providers st...

I'm trying to write a program that automatically add columns from the OLE DB Sources in all of the components in a .dtsx file (the target is SSIS 2005). When I process the .dtsx with my program see...

I have following Dataflow: Control: I just wanted to copy all the data from flatfiles in sourcefolder to sql database and after copying move those files to folder named Done. But when i run ...

I executed an SSIS package using SSDT and Visual Studio. When I try to execute another package I get an error saying "The process cannot access the file XXXX.ispac because it is being used by ...

installing the Microsoft.DataTools.IntegrationServices.exe on a Windows 10 PC, with Visual Studio 2019 already installed, I got this error: Can anyone help me understand why this happens? Thanks a...

I'm a newbie in SSIS... I'm exporting data from a DBSource and outputing any errors to a Flat File. Now, when I connect the red arrow to the Flat Destination I'm receiving a warning from the DB Sou...

Our SSIS package fails 2 seconds into the run with the following error: An item with the same key has already been added.; at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) ...

I have a SSIS job which run well in SQL Server 2008 but no longer working in SQL Server 2017. The error message I get is: Cannot create a task from XML for Task "Email", type "Microsoft.Script.T...

I get an error message when I try run my SSIS Package, I get an error: [Flat File Source [1]] Error: The column delimiter for column "Column 8" was not found. [Flat File Source [1]] Erro...

I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS package The Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine. (System.Data) ...

This question was asked here before but the solutions proposed don't seem to be working for me. I'm trying to import a text file pipe delimited text qualifier ". The SSIS package is returning the ...

I recently got this error in every SSIS package (using Visual Studio 2012), when I want to open a OLE DB source component: =================================== Method not found: 'Void Microsoft.Da...

I'm currently updating all of our ETLs using Visual Studio 2015 (made in BIDS 2008) and redeploying them to a new reporting server running on SQL Server 2016 (originally 2008R2). While updating on...

Our dev server has SQL Server 2008 R2 64-bit with SSIS. In order to be able to import XLSX files directly from T-SQL (via OPENROWSET), we installed on the dev server the Microsoft Access Database E...

I have a Script Component where I buffer all the rows, then do some processing, and then I want to create the output rows. I tried accessing the Output Buffer object in PostExecute but apparently t...

When I open a Script component, I can choose a Connection Manager from a dropdown list: This Connection Manager has it all, if I had it as an object in the C# code, I would not need to write a har...

I have a control flow where I create a temp database and table with a T-SQL Command. When I add a dataflow I would like to query the table but I can't because the table doesn't exist to grab inform...

In my SSIS package, I have to converting values from DateTime to a corresponding INTEGER value. The following sample has been provided. Any ideas as to how I can convert these? DATETIME INT -----...

In an ssis package consists of data flow task,contains OLEDB source and OLDB Target ..provider is sql native client..This used to run fine ..but now got an error as shown below.. Please tell me how...

I have a few SSIS packages that were password-protected (their protection level is apparently EncryptAllWithPassword) by a developer who left the company and can't be reached anymore, and trying to...

I'm trying to create a data flow task which brings data from Excel File to SQL table. I'm doing it in SQL Server Data Tools for Visual Studio 2012 as an SSIS package. However, when I run the task ...

I have a SQL Server Agent Job that previously had two steps. Today, I've had to integrate the third step, and soon I'll need to integrate a fourth. I want to be sure that the step will execute prop...