Integration Services

• Topics

  Started by

  Posts

  Last post

• ssis 2012 - write to application eventlog window

  Hello,I am working on a ssis package that someone else created.It seems whenever thepackage fails t…

  arkiboys

  1 replies

  8 years, 8 months ago

  By: Phil Parkin

• Grief importing date from Excel 2010 to SQL Server 2012, SSIS, Derived column task.

  Hello, First of all, I'm an SSIS Noob, and not great with Excel either, someone else created and im…

  Duran

  12 replies

  8 years, 8 months ago

  By: Phil Parkin

• Incremental Load with INSERT, UPDATE and DELETE on Fact Table with 100+ million rows

  Hi, I have to design an incremental load on a SQL Server 2016 fact table with 100+ million rows.&nb…

  Addicted2SQL

  9 replies

  8 years, 8 months ago

  By: frederico_fonseca

• Urgent ~ Can we load OLEDB Source to Excel Destination Without Data Conversion Task

  Hi,    Can we avoid Data conversion task while loading data from Sql server to Excel dest…

  subratnayak09

  2 replies

  8 years, 8 months ago

  By: tim.ffitch

• replace in condition

  i am checking 2 columns, column A != column Band i am getting all records from file although both r…

  coool_sweet

  1 replies

  8 years, 8 months ago

  By: tim.ffitch

• rename file with a dynamic file name and sheet name SSIS

  hi still fairly new to SSIS is there a script task that can be used in SSIS 2010 This task would h…

  joanna.seldon

  3 replies

  8 years, 8 months ago

  By: John Mitchell-245523

• zipping to .gz

  hi i am using execute sql task to zip my files to .gz extension. but getting error : executable : C…

  coool_sweet

  4 replies

  8 years, 8 months ago

  By: Jeff Moden

• conditional split

  hi i am getting 2 files where i need to check if data has been chnaged from previous file,i am usin…

  coool_sweet

  1 replies

  8 years, 8 months ago

  By: tychopotts

• Errors caused by nested calls of xp_cmdshell

  Hi, I have SISS package with data flow task (OLE DB Source -> Data conversion transformation -&g…

  maho125

  2 replies

  8 years, 8 months ago

  By: maho125

• How to Add Data Conversion task dynamically

  I am creating metadata driven SSIS package OLEDB Source to Excel Destination  where Data conve…

  subratnayak09

  6 replies

  8 years, 8 months ago

  By: RonKyle

• Importing user data from Excel/CSV

  Hi,I have a growing need to import recurring data from Excel  - it needs to be treated like pr…

  leehbi

  2 replies

  8 years, 8 months ago

  By: leehbi

• archive file which is older than week

  hi i am getting files like file181203 , file170225,basically last part is a date , which i am getti…

  coool_sweet

  2 replies

  8 years, 8 months ago

  By: Jeff Moden

• difference file and log it

  hi I have 2 files with key column. I have to compare by 1 key, if compare is match and other fields…

  coool_sweet

  4 replies

  8 years, 8 months ago

  By: JustMarie

• capture change and conditional split

  hi i m using merge join and using full outer join , i need to see if data is in first table not in…

  coool_sweet

  1 replies

  8 years, 8 months ago

  By: robert.gerald.taylor

• Calls Incoming / Oiutgoing and Missed in one Fact table?

  Hi All Still planning my DW and I want to ask this question. I work in a "call centre" let's say wh…

  MattieG72

  3 replies

  8 years, 9 months ago

  By: MattieG72