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
-1
votes
1 answer

Sql Server 2012 Custom/Standard Reports in SSMS

I want to develop my own Custom Reports in Sql Server. I would want to know the underlying report logic (tables used, joins etc) of the existing Standard reports in SSMS to get an idea. Is it possible to locate the source code (.rdl) of these…
Raj Aryan
  • 59
  • 3
  • 12
-1
votes
1 answer

How to write data from SSIS to Googlespreadsheet

I am new to all this and I am trying to write data google spreadsheet. Is that possible and if so can some one help me. Thank you.
Davor Turkalj
  • 11
-1
votes
2 answers

Nullable Datetime From Derived Column

Extracting data from a flat file. Field in question comes in as a string and is formatted to fit db column of type Datetime. Field allows null in the database and file contains nulls and valid strings that successfully convert to dates in this…
JGrimm
  • 399
  • 2
  • 4
  • 22
-1
votes
1 answer

ssis 2012 packages deployment error

when I deployed ssis packages that time I faced one error.please tell me how to resolve that issue in ssis package deployment time.it is seems permission related what i do exactely to give permission or any other ways.please tell me how resolve…
user3224208
  • 907
  • 2
  • 9
  • 12
-1
votes
2 answers

how can i continue for-each loop in SSIS when a task into for-each loop failed?

I have package SSIS package and i work with SSIS 2008. I have start package which call other package i want to read files in daily folder on WEB_DAV folder and insert records in tables and update some table and move this file to backup folder, …
sara Sodagari
  • 423
  • 1
  • 9
  • 23
-1
votes
1 answer

Hashbytes Column

I have a column with Hashbytes values: 0xDA39A3EE5E6B4B0D3255BFEF95601890AFD80709 which is a Binary data type. I need to create a column as DA39A3EE5E6B4B0D3255BFEF95601890AFD80709 without 0x using ssis. I have tried various methods but I just end…
Djbril
  • 745
  • 6
  • 26
  • 48
-2
votes
1 answer

SSIS PACKAGE_ How to update data in more than two table using single SSIS Package

I want to update three tables from CSV File in a single SSIS package. I am done with updating the single table by comparing CSV file and table, I have attach the screenshot its working fine. But when I trying to update more than 3 tables in single…
Akshay Bhole
  • 1
  • 2
-2
votes
1 answer

Get File Size from FTP (in SSIS, using Dts.Connections)

I have an issue sending big file to an FTP site and I would like to check the file size after the transfer (sometimes it works sometimes it fails). The transfer is within an SSIS and I'm using Dts.Connections in C#. My code: public long…
pdube
  • 593
  • 1
  • 11
  • 26
-2
votes
1 answer

How can I get return value from a stored procedure and use it in script task using OLE DB Command Task(Provider, Providerlocation) in SSIS?

enter image description here How to get return value from OLE DB Command Task and use it in Script task?
user2326218
  • 1
  • 1
-2
votes
1 answer

Extract Date from a string using Derived Column in SSIS

I have a column called FileName and I wanted extract the date from the column as a Date column using Derived Column in SSIS. The FileName Data type is nvarchar(260) FileName M:\Mapping\Workforce_Planning\ABC\ABClrmp.full.2016-01-07.csv Desired…
Djbril
  • 745
  • 6
  • 26
  • 48
-2
votes
1 answer

Retrieve Data from a csv file and assign to a SSIS Variable

Good day! Basically I am importing data from CSV file but would like to assign the value in cell C2 to a variable to be used in the SSIS flow. I know that this can be done using Script Task but I'm no c# person. Appreciate any help.enter image…
Imelda
  • 1
  • 2
-2
votes
1 answer

How to pass a parameter to SQL Query after conditional split in SSIS

I am fairly new at working with SSIS, and everything was straight forward until I came across this. I have a system that has data everywhere and I am trying to clean everything up by normalizing it. Now my issue is, in my SSIS I have a conditional…
user2597012
  • 581
  • 4
  • 9
  • 28
-2
votes
2 answers

Identifying duplicate files based on data content in SSIS

I get files to a shared location . Every file has different meta ie. file name, date created. I have to extract the data using SSIS if and only if file content is different than previously processed files.
sandeep rawat
  • 4,797
  • 1
  • 18
  • 36
-2
votes
2 answers

SQL Sending values where code matches another table

I have a table with data records: T1: Example T1 Data: Unique_id RatingA RatingB RatingC 123 1 3 Null 456 -1 Null 2 I have another table with a code that equates to the ratings, T2: Rating_Name …
Mrodonis
  • 1
-2
votes
1 answer

How to seperate out ERROR FILE from Correct file using SSIS and archive them

I have a scenario where there are two source file ABC.txt and DEF.txt. i want to make sure that if any files are present in that folder with naming convention as ABC.txt, it has to be moved to the different folder prior to loading to the SQL server,…
user255826
  • 41
  • 8
1 2 3
…
91
92