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
3
votes
2 answers

How to Get latest folder details dynamically in ssis

I have folders in this path C:\Customer\ Folder Names: 04012019 04022019 04032019 ... I want to pick the latest folder(04032019) dynamically. Can anyone please help me how to achieve this in ssis . Thanks in advance!!
Balu
  • 39
  • 2
3
votes
1 answer

SSIS Importing Excel Data

I've been tasked with importing data from an excel spreadsheet in to a table in SQL 2012. The spreadsheet will have data added to it monthly. My plan, is to use SSIS to create a workflow to do this, I then will use SQL Job agent to execute the…
Clem_Fandango
  • 254
  • 2
  • 18
3
votes
1 answer

Is there any way to insert below nested json data into sql server

I am working on a nested JSON data which I need to load into SQL SERVER 2012. The nested JSON contains two roots i.e. one column and another rows. I need to put value from row into the column. Please see the structure as below: { "tables": [ …
Utsav
  • 33
  • 3
3
votes
1 answer

How to insert data in encrypted varbinary field from flat file using SSIS?

I have a table called demo with three fields. ID int identity, Name varbinary(128), orderdate datetime Demo table has the field 'Name' which is encrypted. Now I have a flat file which has data like 1,John,2016-01-01 How would I go about achieving…
Jerry
  • 127
  • 1
  • 9
3
votes
1 answer

How to Append two rows from two source in SSIS?

I have to table in MySQL Server. Header Table. ╔════════════╦════════╦═════════════╦═════════════════╦══════════╗ ║ RecordType ║ CustID ║ DataGenDate ║ DataCreatedDate ║ SourceID…
Shahab Haidar
  • 625
  • 3
  • 11
  • 25
3
votes
1 answer

How to get desired output in SSIS by grouping by and count?

I'm creating an SSIS package wherein a user needs to be notified if there is a duplicate productcode for one productlabel. We retrieve the products thru a csv flat file being sent to us in a shared location. In this example I have Productcode = 1a…
Chadwick
  • 47
  • 1
  • 5
3
votes
2 answers

In SSIS, How to convert unicode datatype to excel column?

I am working on SSIS Package to export the output data to Excel file. ( Excel Destination ). I am running into conversion error. Error Description : cannot convert between Unicode and non-Unicode string data types Input Column Details ColumnA…
goofyui
  • 3,362
  • 20
  • 72
  • 128
3
votes
1 answer

Loop 10 records at a time and assign it to variable

I have a table of 900 records. I want to get 10 records at a time and assign it to variable. Next time when I run the for each loop task in SSIS, it will loop another 10 records and overwrite the variable. Any help will be highly appreciated. I…
dunes
  • 41
  • 2
3
votes
3 answers

SSIS Error "To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition (64-bit) of Integration Services "

I am using Visual studio ultimate 2012, SQL Server 2017 and Sql Server Data tools 2012. I am working with windows 10 64 bit. My package consists of script tasks(c#) and Sql commands and it runs successfully from SSDT, but while trying to run my…
Priyanshu
  • 55
  • 1
  • 1
  • 6
3
votes
2 answers

Use variable parameter in Execute SQL Task multiple times SSIS

hey guys so i created two variables: startdate and todate and I am attempting to pass them through my SQL query in SSIS and I have added them in my Parameter Mapping but how does SSIS which variable to use after if it sees a third question mark? for…
Kamran
  • 147
  • 4
  • 14
3
votes
1 answer

how to check column structure in ssis?

I have a table customer in my sql server. Columns Distributer_Code Cust_code cust_name cust_add zip tel dl_number gstin we receive customer files from the distributor on a monthly basis. so sometimes they send files with the wrong structuer.. like…
Shahab Haidar
  • 625
  • 3
  • 11
  • 25
3
votes
1 answer

SSIS Error : Non-SysAdmins have been denied permission

I am running this SSIS Package but I am getting this error Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed. There are many other packages that are working fine but this one I get an…
asmgx
  • 7,328
  • 15
  • 82
  • 143
3
votes
3 answers

Split comma separated string into several rows in SSIS?

I want to achieve the output in 2nd table based on the input from the first table. I want to do this via a SSIS package. So far I tried creating a package with bypassing error whenever there comes a comma (,), but that didn't work. Also tried using…
user7756155
3
votes
1 answer

difference between data conversion and derived column in ssis?

I am learning SSIS for a new requirement. I came across these two transformations - Data Conversion and Derived Column. But we can convert the datatypes in Derived Column itself. So what was the need that Microsoft added this 'data Conversion'…
Be1ng_Kr1Sh
  • 293
  • 2
  • 13
3
votes
2 answers

How to create an SSIS Package that will run a list of T-SQL queries located in a specific folder?

I am using SQL Server 2012 and I need to create an SSIS package that will run a list of T-SQL queries from a specific folder. My list of T-SQL queries have been named starting with '01 (name of query).sql' and the folder contains a list of 25…
user3115933
  • 4,303
  • 15
  • 54
  • 94
1 2 3
…
91 92