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
4 answers

Custom Logging to SQL Server table in SSIS

I have a SSIS package that has three DataFlowTasks. 1st dataflow load data to destination table1 2nd dataflow load data to destination table2 3rd dataflow load data to destination table3 I configured logging by default to SQL Server table…
StackUser
  • 5,370
  • 2
  • 24
  • 44
-1
votes
1 answer

Get file size and Name into two different column using C#

I want to get all the files name and their size and save it into an Excel using C#. I have done this but the problem is I want two different column: one for filename and one for Filesize, but my output is saved in one column. The code I'm…
SaNa3819
  • 337
  • 5
  • 19
-1
votes
2 answers

Export data from sql table to excel without Data flow task

How can I export a table from sql to an excel using SSIS script? In addition I have to maintain an excel template so everytime it matches the header name and export data into it.
SaNa3819
  • 337
  • 5
  • 19
-1
votes
1 answer

Best Way to get values from Managed Objects Attribute in C#

When getting values Active Directory in C#, my normal process is to use the principal context to get most of these values. There are still some things I need LDAP to get because they aren't available from a user principal object. For these…
Jason R.
  • 379
  • 1
  • 6
  • 19
-1
votes
1 answer

SSIS Expression

SELECT CAST(Count(1) as VARCHAR(30)) AS SourceRowCount FROM table where countryid= '" +@[User::Id] +"'"+ " "+" AND locationid ="'+@[User::ID1]+'" Expected output SELECT CAST(Count(1) as VARCHAR(30)) AS SourceRowCount FROM table where…
jes
  • 1
-1
votes
1 answer

I want to dynamically read columns and concatenate values by using in SSIS

I want to read columns dynamically and concatenate values by using in SSIS. And it should generate a string of concatenate value which is delaminated by '|'. Nunber of columns will be not constant. Here is an example of what I am trying to…
Nitin
  • 7
  • 1
-1
votes
1 answer

avoid error in ssis package using winscpcommand

Hi I have doubt in ssis using winscp commands on excuteprocess task I need download/move .zip file from remote server to local server machine. Here I follow few steps: step1:I install winscp software in local server . step2: I configure winscp…
balu kum
  • 1
  • 2
-1
votes
1 answer

How to extract only the recent data from a source table in SSIS?

I have a 'Modified Date Column' in the source table and I need to extract the recent data Recent data - Data in the date between the recent execution of SSIS package to till date(Current execution date). How can this be acheived in SSIS?
Gowtham Ramamoorthy
  • 111
  • 1
  • 2
  • 13
-1
votes
1 answer

Exporting XML Data to mutiple files but retain structure

I have been searching on the net for the last couple of days and unfortunately cannot find quite what I am looking for. I have a SQL Server 2012 table that contains 2 columns, one is PurchaseOrder DataType varchar(10) the other is Data with a…
PJD
  • 743
  • 2
  • 12
  • 38
-1
votes
1 answer

Bad request error from Google Analytics API

//Please help to make this code workable using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Net; using System.IO; using System.Xml.Linq; using System.Globalization; …
Babu Kannan
  • 3
  • 1
-1
votes
1 answer

SSIS package which runs biweekly but there is no reverse out plan if it fails

Step 1- This is X job that creates the (b) job.dat file Step 2- This is an SSIS package that splits the output dat file into 4 different files to send to Destination Step 3-Moves the four files from the workarea to another location where MOVEIT…
Sunny
  • 3
  • 3
-1
votes
2 answers

How to load SSIS package for any specific date

I have a ssis package which runs daily. This ssis package has couple of execute sql tasks which load data for yesterday's transaction. Ex. INSERT INTO Shipped (Div_Code, shipment_value, ship_l_id, shipped_qty, shipped_date, whse_code, ord_id,…
ramu
  • 121
  • 1
  • 13
-1
votes
1 answer

How to update the origin table in the CDC workflow (via SSIS)?

I have a CDC process setup, whereby TableA's additional rows (or updates) are automatically picked up by an ETL and put into a TableB TableA >>CDC>> TableB The CDC works fine, except I want to update the first table once the CDC process is finished.…
LearnByReading
  • 1,813
  • 4
  • 21
  • 43
-1
votes
2 answers

How to load three Different Excel files into different Tables

I Have three Excel files which will update weekly with name including updated Date.xlsx. I need to load this three Excel files into my three tables using SSIS Package. I also need to make this automated as I have to schedule a job for that. How can…
Binny
  • 101
  • 1
  • 6
-1
votes
1 answer

Large file, SSIS to Small chunks, parallel enrichment

I have a pretty large file 10GB in Size need to load the records into the DB, I want to have two additional columns LoadId which is a constant (this indicates the files unique Load number) ChunkNumber which would indicate the Chunk of the batch…
bhushanvinay
  • 449
  • 1
  • 5
  • 21
1 2 3
…
91 92