Stack Overflow
Stack Overflow

Questions tagged [ssis-2012]

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

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.

SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. wikipedia

1375 questions
6
votes
1 answer

Read SSIS Package File Name From Within Package (Package Deployment)

I created a SSIS Package in Visual Studio SSDT 2012, using Package Deployment model. Is there any way to get access to the package's file name as a readonly variable or property from within the package? I don't see it listed as a system variable,…
Jason R.
  • 379
  • 1
  • 6
  • 19
6
votes
3 answers

How to log the output of SSIS Execute SQL Task

I am new to SSIS. I created SSIS Package using Execute SQL Task. I called a Stored Procedure. My stored procedure prints few messages like 'Insert Started' 'Update Started' 'Update Completed' but it does not return any result set. How do I write…
StackUser
  • 5,370
  • 2
  • 24
  • 44
6
votes
3 answers

ErrorColumn value does not exist as Lineage ID

During the insert into a destination table, any error that occurs is redirected to Errors table where we can see the ErrorCode and ErrorColumn. The problem is that we got a value in ErrorColumn which does not exist anywhere within the package.…
Huske
  • 9,186
  • 2
  • 36
  • 53
5
votes
2 answers

Where to find Status details for SSIS execution id in SSIS

I have created an SSIS Package and deployed it on Server. While execution of Package i can see the report of Execution. i want to know that in which table SSIS execution id's information is stored? like if execution id= 2 that means packge is…
Shahab Haidar
  • 625
  • 3
  • 11
  • 25
5
votes
3 answers

Warning: Truncation may occur due to retrieving data from database column

I am importing a data set from Oracle using SSIS. SSIS is gives me a warning: Truncation may occur due to retrieving data from database column "Third Party" with a length of 28 to data flow column "Third Party" with a length of 25." The warning…
user716255
  • 352
  • 1
  • 6
  • 18
5
votes
5 answers

Cannot initialize the data source object of OLE DB provider Microsoft.ACE.OLEDB.12.0 for linked server (null)

DECLARE @PATH NVARCHAR(1000) = N'\\MY-SERVER\C$\Folder\\' DECLARE @TABLE NVARCHAR(50) = SUBSTRING(@FILENAME,0,CHARINDEX('.',@FILENAME)) DECLARE @SQL NVARCHAR(4000) = N'IF OBJECT_ID(''dbo.' + @TABLE + ''' , ''U'') IS NOT NULL DROP TABLE…
AMouat
  • 685
  • 15
  • 27
5
votes
4 answers

Exclude specific Sub Folders

I got a package that runs through a folder and it's sub folders to get client data. The agreement has changed and now the client will post his data in different folder name every time. I was wondering if I can do a foreach loop on the main folder…
Mustafa Alani
  • 51
  • 3
5
votes
2 answers

How to load grouped data with SSIS

I have a tricky flat file data source. The data is grouped, like this: Country City U.S. New York Washington Baltimore Canada Toronto Vancouver But I want it to be this format when it's loaded in to the…
William Xu
  • 241
  • 2
  • 12
5
votes
2 answers

SSIS Variable that pragmatically changed

This is a add on to this question that was asked previously with no answer. The problem I have is a need to occasionally update a set 35 children SSIS packages with one parent. They are all the same, differing only in what data they process. …
Jason R.
  • 379
  • 1
  • 6
  • 19
5
votes
1 answer

In SSIS, how to loop through the XML inside a specific element using XPATH in a Foreach NodeList Enumerator

I am trying to loop through the XML elements of an XML input file in SSIS. For this I am trying to use a 'Foreach Loop Container' with a Foreach Loop Container. Inside the ForEach Loop Container, I'd like to get the xml code as a String Variable. I…
Karel-Jan Misseghers
  • 797
  • 8
  • 31
5
votes
1 answer

Change font and colors in Visual Studio's SSIS 2012

Please see below image, I am using Visual Studio 2012 and I cant see when a data flow is enabled or disabled. In the below image only the first Data Flow is actually enabled!! Hard to see it hey! Would like to know where exactly I can change the…
Etienne
  • 7,141
  • 42
  • 108
  • 160
5
votes
2 answers

what is the use of Miscellaneous Folder in SSIS Solution

What exactly is the use of Miscellaneous folder in the SSIS Solution folder hierarchy? I have use many packages and solutions as a part of the project,but never used this folder.I do understand that ,one can import various files over here. Can any…
user1254579
  • 3,901
  • 21
  • 65
  • 104
4
votes
2 answers

Renaming a file source

I've been developing an SSIS package from a flat file source. The file comes daily and the file name has datetime indication like this: Filename_20190509042908.txt I was wondering how I can pass until the date part; I want the package to read the…
lije
  • 420
  • 2
  • 15
4
votes
1 answer

Access Database engine OLEDB in windows server 2016

I have an application that uses Microsoft ACE OLEDB 12.0 driver and hence I have installed 2007 Office System Driver: Data Connectivity Components in my system. I also have created SSIS packages to pull data from the excel and csv files which get's…
Karthik Venkatraman
  • 1,619
  • 4
  • 25
  • 55
4
votes
3 answers

SSIS script task can't find Newtonsoft.Json

I installed the dll to the GAC even updated the dll to install that into the GAC but I get this error: "Could not load file or assembly 'Newtonsoft.Json, Version=4.5.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies.…
user3266638
  • 429
  • 8
  • 25
1 2
3
…
91 92