tagged [ssis]

SSIS - The process cannot access the file because it is being used by another process

SSIS - The process cannot access the file because it is being used by another process I have following Dataflow: ![enter image description here](https://i.stack.imgur.com/svYIz.png) Control: ![enter i...

c#.netsql-serverssis
18 Dec at 13:13

Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot I'm trying to import a flat file into an oledb target sql server database. her...

sqlsql-servertsqlssis
28 Aug at 17:14

Import Package Error - Cannot Convert between Unicode and Non Unicode String Data Type

Import Package Error - Cannot Convert between Unicode and Non Unicode String Data Type I have made a dtsx package on my computer using SQL Server 2008. It imports data from a semicolon delimited csv f...

sql-server-2005unicodessistypesnon-unicode
25 Sep at 18:11

Should programmers use SSIS, and if so, why?

Should programmers use SSIS, and if so, why? As a .NET developer, for what reasons should I prefer SSIS packages over writing code? We have of packages in production where I currently work, and they'r...

c#.netsql-serverssis
24 Aug at 15:52

Set Script Task code dynamically in SSIS 2012

Set Script Task code dynamically in SSIS 2012 In my application, a script task is created dynamically. In SQL Server 2008's implementation of SSIS, the following method worked fine. ``` private void S...

c#ssismigrationsql-server-2012
23 Nov at 20:57

Get Last non empty column and row index from excel using Interop

Get Last non empty column and row index from excel using Interop I am trying to remove all extra blank rows and columns from an excel file using Interop Library. I followed this question [Fastest meth...

c#excelvb.netssisetl
21 Jun at 10:48

Integration Services and Isolation Level

Integration Services and Isolation Level We have a data-warehousing package that our clients run during the day against their live transactional system. On most clients this seems to work fine but on ...

ssistransactionsisolation
22 Jan at 01:48

SSIS how to set connection string dynamically from a config file

SSIS how to set connection string dynamically from a config file I am using SQL Server Integration Services (SSIS) in SQL Server Business Intelligent Development Studio. I need to do a task that is as...

ssisconnection-stringconfiguration-files
8 Apr at 15:0

How do I fix the multiple-step OLE DB operation errors in SSIS?

How do I fix the multiple-step OLE DB operation errors in SSIS? I'm attempting to make a DTS package to transfer data between two databases on the same server and I'm getting the following errors. Iv ...

sql-serverssis
28 Jul at 17:49

What is the best way to consume REST APIs from DTSX packages?

What is the best way to consume REST APIs from DTSX packages? We have recently migrated our SOAP services into REST APIs. With that, we had changed all consumers to point to new REST APIs successfully...

.netsql-serverrestssisservicestack
8 Jun at 13:21

How do I access Excel data source from an SSIS package deployed on a 64-bit server?

How do I access Excel data source from an SSIS package deployed on a 64-bit server? I have an SSIS package that exports data to a couple of Excel files for transfer to a third party. To get this to ru...

sql-serverexcelssis
30 Sep at 16:43

Watching variables in SSIS during debug

Watching variables in SSIS during debug I have a project in SSIS and I've added an Execute SQL Task which sends its result out to a variable. I wanted to confirm the value because I was worried that i...

sqlsql-server-2005debuggingssiswatch
26 Feb at 22:3

How to loop through Excel files and load them into a database using SSIS package?

How to loop through Excel files and load them into a database using SSIS package? I need to create an SSIS package for importing data from multiple Excel files into an SQL database. I plan on using ne...

excelssis
2 May at 18:42

Using SSIS BIDS with Visual Studio 2012 / 2013

Using SSIS BIDS with Visual Studio 2012 / 2013 I want to use SSIS /BIDS project in Visual Studio 2012. I have both Visual Studio 2010 and Visual Studio 2012 installed along with Microsoft SQL Server 2...

visual-studio-2012ssisvisual-studio-2013bidssql-server-data-tools
23 May at 11:45

SSIS Convert Between Unicode and Non-Unicode Error

SSIS Convert Between Unicode and Non-Unicode Error I have an ssis package where I am using an OLEDB source linking to SQL Server 2005 table. All columns except a date column are NVARCHAR(255). I am us...

unicodessisnon-unicode
21 Mar at 12:28

SSIS Connection not found in package

SSIS Connection not found in package I'm kind of new to SSIS programming, and I'm having some problems deploying an SSIS package. This package runs correctly on my PC, does everything it needs to do ....

sqlsql-serverssis
20 Jun at 09:12

Post Build in SSIS Project

Post Build in SSIS Project I am trying to have a PostBuildEvent in my SSIS project. This is my original .DTProj file from a test project with one test package. ``` 10.0.2531.0 9.0.1.0

sqlsql-servervisual-studio-2008ssispost-build-event
17 Aug at 18:23

Could not load file or assembly 'Newtonsoft.Json' Version=11.0.0.0

Could not load file or assembly 'Newtonsoft.Json' Version=11.0.0.0 I have read a lot of the responses to previous versions of this issue but none seem to work. Every time I open my script component in...

c#visual-studiossisjson.netscript-component
5 Mar at 20:8

The value violated the integrity constraints for the column

The value violated the integrity constraints for the column I am trying to import the data from Excel file into SQL Server database. I am unable to do so because I am getting following errors in the l...

ssis
20 Jun at 09:12

"Runtime error Exception has been thrown by the target of an invocation" from Script task

"Runtime error Exception has been thrown by the target of an invocation" from Script task I have a SSIS package with a script task, I get the following error when i try to run it in my local system. I...

c#ssisscript-task
16 Mar at 19:31

SSIS storing logging variables in a derived column

SSIS storing logging variables in a derived column ## I am developing SSIS packages that consist of 2 main steps: : Grab all sorts of data from existing legacy systems and dump them into a series of s...

sql-server-2005ssis
15 Jul at 18:17

SSIS Script Component Cannot Load Assembly Until Manually Opened

SSIS Script Component Cannot Load Assembly Until Manually Opened I am creating a SSIS project via Biml (Using the current version of BimlExpress per the [Varigence BimlExpress page](https://www.varige...

c#sql-servervisual-studiossisbiml
24 Jul at 15:8

SQL Server 2005 SSIS job that writes a file to another server will not run, but will run through MSDB

SQL Server 2005 SSIS job that writes a file to another server will not run, but will run through MSDB I have a SSIS package that writes to a csv file on another server. It will run fine when I execute...

sql-server-2005ssis
1 Jan at 19:24

How to produce documents (docx or pdf) from SQL Server?

How to produce documents (docx or pdf) from SQL Server? I know this is a little subjective, but I'm looking into the following situation: I need to produce a number of documents automatically from dat...

c#sql-server-2008ssispdf-generationms-office
9 May at 04:39

"Unable to read data from the transport connection: net_io_connectionclosed." - Windows Vista Business and SMTP

"Unable to read data from the transport connection: net_io_connectionclosed." - Windows Vista Business and SMTP Unable to test sending email from .NET code in Windows Vista Business. I am writing code...

c#.netwindows-vistassissystem.net.mail
3 Feb at 17:12
from the blog
Analyzing Voting Methods
Generating the PvQ Leaderboard
Getting Help in the Age of LLMs