Integration Services

• Topics

  Started by

  Posts

  Last post

• move cdr and cmr files

  Hi, I have a folder which receive the CDR and CMR files sended by Cisco. There is no datetime for t…

  Hadrian

  5 replies

  11 years, 10 months ago

  By: Hadrian

• Use of Parameters instead of hardcoded values

  In the derived column i am defining one of the values as v_type = ((v_provtype == "62" && (FIN…

  sattar419 10789

  2 replies

  11 years, 10 months ago

  By: sattar419 10789

• How can I improve execution time for pulling iSeries DB2 data into SQL Server using SSIS

  I have been tasked with improving the speed of a data pull from iSeries DB2 V5R4 into a stage table…

  nmccormick

  7 replies

  11 years, 10 months ago

  By: Oleg2222

• Execute SQL Task to Delete Rows from a Excel Sheet

  Hi Everyone. Is there a way to delete rows in an excel spreadsheet using the execute SQL Task in SS…

  ganteng1

  1 replies

  11 years, 10 months ago

  By: Umer Akram

• You need to specifiy the full path to a SSIS deployment manifest file

  Before you read any further, this is more of an answer not a question as such, I just wanted to be …

  Sequelsurfer

  1 replies

  11 years, 10 months ago

  By: Alexandra Ramos

• 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 months ago

  By: cafescott