Integration Services

• Topics

  Started by

  Posts

  Last post

• Using variables in Lookup transformation

  Hi, I have a requirement to use variables in a lookup transformation, does anyone how can this be i…

  pwalter83

  5 replies

  4 hours, 32 minutes ago

  By: AlphaTangoWhiskey

• Immediately Fail Package Uppon Failure

  Hi, Very simple question here but can't seem to find the answer... I have a SSIS package that does …

  Vince Poirier

  6 replies

  1 day, 4 hours ago

  By: Vince Poirier

• ExecSQL outputs multiple updates script to variable

  Hi, I have an ExecSQL task that generates many UPDATE statements which I would like to store as a v…

  EamonSQL

  2 replies

  4 days, 5 hours ago

  By: Phil Parkin

• excel destination

  hi i am loading data in excel file dynamically everyday .it was working fine but lately the file is…

  coool_sweet

  1 replies

  5 days, 20 hours ago

  By: coool_sweet

• SSIS never gets past 50% in Pre-execute phase

  This is a fairly straightforward SSIS package that builds a set of "summary" tables used by a group…

  Michael L John

  2 replies

  6 days, 5 hours ago

  By: Michael L John

• SSIS 2016 Excel stops working

  Hello, I am using SSIS 2016 and Visual studio 2015 to create an SSIS package that just gets an exce…

  Siten0308

  1 replies

  1 week ago

  By: Siten0308

• PSFTP using SSIS

  hi   i m using psftp utilitie to post file on sftp server using execute process task.Its runni…

  coool_sweet

  3 replies

  1 week ago

  By: frederico_fonseca

• Extract dates from the file name in SSIS

  Hi, I have a requirement to extract the 2 dates from the file name in SSIS (2010) as a derived colu…

  pwalter83

  4 replies

  1 week, 3 days ago

  By: pwalter83

• SSIS Job Stopped Working After Change to Office 365 on Server

  We have a SSIS job that archives reports, by scraping the attachment from the email and saving it t…

  rdsb_2170

  6 replies

  1 week, 5 days ago

  By: frederico_fonseca

• Data Flow - One or more component failed validation

  I am doing tasks from "Microsoft SQL Server 2012 Integration Services: An Expert Cookbook ". I am g…

  yrstruly

  4 replies

  2 weeks ago

  By: Jonathan AC Roberts

• "The given path's format is not supported."

  I am following examples out of the book "Microsoft SQL Server 2014 Business Intelligence Developmen…

  yrstruly

  4 replies

  2 weeks ago

  By: Thom A

• VSTA editor window layout cannot be reliably configured.

  I can’t stand it anymore. Using VS 2017/SSDT  for SSIS development, when I start the VSTA script…

  palandri

  1 replies

  2 weeks, 4 days ago

  By: palandri

• SSISDB Corruption.Does anyone know steps to follow to restore SSISDB from backup

  I restored SSISDB as is to test server. Here is the full CHECKDB result with ALLOW DATA LOSS from t…

  Ash

  1 replies

  3 weeks, 1 day ago

  By: Ash

• Import data from Word Custom Controls

  I'm just wondering how hard this would be in SSIS... I got it to work in Access using Word automati…

  pietlinden

  1 replies

  3 weeks, 3 days ago

  By: pietlinden

• Detailed logging for Transfer SQL Server Objects Task

  Hi all, I need to use 'Transfer SQL Server Objects Task' to  transfer sql server object(specific t…

  JoNTSQLSrv

  0 replies

  1 month ago

  By: JoNTSQLSrv