Integration Services

• Topics

  Started by

  Posts

  Last post

• Need Help to implement the De Duplication

  Dear All, Good Day. I have a requirement to implement de-duplication on customer data in our policy…

  bala2014

  1 replies

  7 months, 1 weeks ago

  By: Mr. Brian Gale

• importing from PowerQuery... but with multiple powerqueries

  I finally got the PowerQuery source to "show" in SSIS (so I can see columns and data now). In my ca…

  pietlinden

  2 replies

  8 months, 1 weeks ago

  By: pietlinden

• SSIS Automatically Coverting a NULL to a Blank Space

  Hello, I was wondering if anyone knew how to prevent this issue I am experiencing. I have a SQL Sou…

  cpiacente

  7 replies

  9 months ago

  By: Phil Parkin

• how to export clickable urls in excel from SSIS

  I'm using ssis to copy excel file from a template, and update some cells on each copied files. prob…

  cascador84

  2 replies

  9 months ago

  By: kaj

• MDS migration - No data in the mdm view MasterDataServices

  Hi , I migrated a model of Master Data Services using   MDSModelDeploy.exe createpackage -pac…

  jaango123

  1 replies

  9 months, 2 weeks ago

  By: jaango123

• VS 2008 - SSIS Package has a "system" variable that I can't find the value for

  I have a production SSIS package that is on a SQL 2008 R2 instance, and looking at the package usin…

  sgmunson

  1 replies

  9 months, 2 weeks ago

  By: sgmunson

• Variables missing from Locals window when debugging SSIS packages

  I have a problem seeing local variables when debugging andSSIS package that is driving me batty.&nb…

  palandri

  2 replies

  9 months, 2 weeks ago

  By: sgmunson

• The requested OLE DB provider SQLNCLI10.1 is not registered.

  Im running BIDS 2013 on a 64 bit server, connecting to 64 bit SQL 2014. When i create a new SSIS pr…

  winston Smith

  10 replies

  9 months, 3 weeks ago

  By: Kunal Rathi

• Error when running SSIS package as a job

  Hello, I've created an SSIS package that collects data from SQL Servers and databases such as CPU, …

  ichervin

  11 replies

  10 months ago

  By: Tav29

• Call Snowflake Stored Procedure using SSIS Execute SQL Task

  Hi I am getting the below error when trying to call a Snowflake stored procedure in SSIS 2017 using…

  wk

  1 replies

  11 months, 1 weeks ago

  By: Phil Parkin

• bypass a non existing server

  I have an execute task(has server list from a table) pointing to foraeachloop foreachloop has dataf…

  mtz676

  1 replies

  11 months, 4 weeks ago

  By: Phil Parkin

• Avoiding duplicates stop and restart an ssis package that is using batch inserts

  Hi, I an using VS 2022 to build a package that selects and then inserts a large number of records i…

  Neo

  2 replies

  1 years ago

  By: Phil Parkin

• "External table is not in the expected format"

  Good Afternoon. I have been manually running an SSIS package on an adhoc basis, which populates an …

  Reh23

  1 replies

  1 years ago

  By: Reh23

• Building SSIS Custom Task

  Hi Everyone, Greetings of the day! I am working on building SSIS Custom task which logs variable va…

  bodempudi111

  4 replies

  1 years ago

  By: bodempudi111

• Convert Project model back to package model

  What started out as an attempt to use the SSIS Project-model combined with deployment using the SSI…

  blom0344

  5 replies

  1 years ago

  By: blom0344