Integration Services

• Topics

  Started by

  Posts

  Last post

• 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

  2 weeks, 2 days 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

  1 month, 1 week ago

  By: Phil Parkin

• SSIS package 'Unexpected Termination' status when running from SSISDB catalog

  We are trying to run SSIS package to read Access Database (.mdb) files using Native OLE DB\Microso…

  gagansth

  14 replies

  1 month, 2 weeks ago

  By: gagansth

• 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 month, 2 weeks 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 month, 2 weeks 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 month, 3 weeks 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 month, 3 weeks ago

  By: blom0344

• Connecting Oracle Database with SSIS

  Hi, I have Visual Studio 22 and I am trying to connect to Oracle database among other sources. I ca…

  WilburSmith

  6 replies

  1 month, 3 weeks ago

  By: NickEvans

• Connecting To Quickbooks via SSIS

  Hello everyone, Been doing some googling trying to find some info on connecting to Quickbooks deskt…

  stricknyn

  7 replies

  1 month, 4 weeks ago

  By: NickEvans

• Replace OLEDB source editor task with a powershell script

  I want to replace all the oledb source editors as shown below with powershell script tasks that exe…

  jaango123

  7 replies

  2 months, 1 week ago

  By: jaango123

• How create a Google bigquery connection manager in SSIS

  Hi So I have created a system dsn to google bigquery data warehouse. However I am not able to figur…

  jaango123

  2 replies

  2 months, 1 week ago

  By: jaango123

• PowerQuery.... don't meet SSIS

  I have a powerQuery that reads and transforms a table in a PDF.  Works a champ. If I wanted to wri…

  pietlinden

  3 replies

  2 months, 2 weeks ago

  By: frederico_fonseca

• DTEXEC Not working for my project: Cannot create a task from XML for task

  I recently created an SSIS package and then converted it to a Package Deployment Model.  I have th…

  Owen White

  3 replies

  3 months, 1 week ago

  By: Phil Parkin

• Date data type not recognized with oledb type provider

  Hello, We recently made the following observation working with  VS2022  combined with the SSIS ex…

  blom0344

  5 replies

  3 months, 2 weeks ago

  By: blom0344

• Issue after updating Data Tools

  I updated the Data tools on my VS2017 installation, and now pretty much anything I try to do, inclu…

  tcheung-x

  4 replies

  3 months, 2 weeks ago

  By: marconogueira