Integration Services

• Topics

  Started by

  Posts

  Last post

• Create Table Excel Destination in SSIS

  Hi Everyone. I have the following SQL Data types: 1. NVARCHAR(255) 2. INT 3. NUMERIC (38,2) Can som…

  ganteng1

  3 replies

  11 years, 8 months ago

  By: Lempster

• SSIS - REST SPI - Parameters

  Hi Gurus, I'm trying to implement data passed from SQL database to REST API using SSIS. Background:…

  kamal_ece

  2 replies

  11 years, 8 months ago

  By: kamal_ece

• Best way for SSIS log...there are so many

  Hi, Everywhere somebody talks about logging a different way in SSIS packages. What is the best wa…

  vanamali

  8 replies

  11 years, 8 months ago

  By: vanamali

• SQL SSIS to Oracle CLOB Performance Issue..

  Hi I'm attempting to push data from SQL via SSIS DT_TEXT to an oracle CLOB field, but performance i…

  dave-dj

  3 replies

  11 years, 8 months ago

  By: dave-DBA

• How to Create custom error log

  Hi All, I am new to ssis ,i want to send customized email notification in the below scenario i am u…

  ambedkar.asu

  2 replies

  11 years, 8 months ago

  By: herladygeekedness

• populating an Excel spreadsheet beneath header rows

  Hello, trying to use SSIS to populate a spreadsheet is a labor for Hercules. Why Microsoft, with a…

  cafescott

  1 replies

  11 years, 8 months ago

  By: cafescott

• SSIS Package Execution

  Hi All, I need help to execute a taxk. I have text file which has SQL Statements something like Sel…

  cvkk2010

  5 replies

  11 years, 8 months ago

  By: Eirikur Eiriksson

• Mapped Network Share

  Hello - I am trying to find out what is the best way to have my ssis package export data to flat fi…

  Keejli69

  7 replies

  11 years, 8 months ago

  By: Phil Parkin

• how to add Aggregated Transform as a new column

  Hi, I have a flat file with 2 colums: TradeID and Nominal. Now I would like to add third column sho…

  jaakkojuntunen

  2 replies

  11 years, 8 months ago

  By: jaakkojuntunen

• ADO.NET connection manager can't run Execute SQL Task

  Hello, I am working on a SSIS package. I wish to use the Connection Manager (CM)'s Connection Stri…

  cafescott

  2 replies

  11 years, 8 months ago

  By: cafescott

• Avoid Loading the same Excel File twice to a OLE DB Destination

  Hi Everyone, I have an SSIS package that loops through a folder looking for and then loading excel …

  ganteng1

  3 replies

  11 years, 8 months ago

  By: ganteng1

• OLE DB Destination

  Hello everyone. Can anyone please tell what effect of Selecting "Keep Nulls" and "Keep Identity" ha…

  ganteng1

  2 replies

  11 years, 8 months ago

  By: ganteng1

• How to enable or disable LOGGING using task,package?

  Hi All, I have created SSIS package which keeps the track of SysSsisLog table into another table. H…

  nikku

  7 replies

  11 years, 8 months ago

  By: Eirikur Eiriksson

• The given key was not present in the dictionary. SSIS XML SOURCE

  Hi folks Just looking for suggestions really. I've got to load multiple XML files into a database…

  MikeLPlates

  1 replies

  11 years, 9 months ago

  By: Eirikur Eiriksson

• Data Flow Tasks takes forever to render in BIDS

  I am having an issue with BIDS rendering a Data Flow Task on the screen. The task has over 50 steps…

  michael.french 172

  1 replies

  11 years, 9 months ago

  By: Koen Verbeeck