Integration Services

• Topics

  Started by

  Posts

  Last post

• Two 'for each file' loops and one data flow task

  All, I have a data task which I want to use for two 'for each file' loops which run in parallel. I …

  as_1234

  11 replies

  4 years, 6 months ago

  By: Phil Parkin

• Dynamic Scheduling of a SSIS Step

  Hi All, I need a favor, regarding the below topic: I have an SSIS to update a table on multiple ser…

  shubham.saxena67

  2 replies

  4 years, 6 months ago

  By: GaryV

• Have txt/csv files, but header need to find from which row it will start

  I have data in text files as attachments/below. SO header row position will be change and delimiter…

  DBA.k

  18 replies

  4 years, 6 months ago

  By: DBA.k

• Encryption Level Problems - Can't Build after Checkout

  We have a project with 650+ packages for datafeeds and order files.  Most of this work was done on…

  ltgrady

  7 replies

  4 years, 6 months ago

  By: ltgrady

• Package migration from version 6 to version 3 failed with error 0xC001700A

  Forum, Im trying to execute and migrate a package which was developed in SQL 2012 on to a SQL 2008 …

  JSB_89

  5 replies

  4 years, 7 months ago

  By: JSB_89

• API call with no wsdl

  I have an API call that passes parameters via the query string and then returns either JSON or CSV.…

  SQL Espo

  1 replies

  4 years, 7 months ago

  By: Phil Parkin

• SSIS Not writting all records to OLE DB Destination

  Hi, I am importing data from csv flat file  with 481 278 records to  my  database table with  1…

  tmmutsetse

  3 replies

  4 years, 7 months ago

  By: Phil Parkin

• Cannot extract Filename from Filepath using GetFileName in C#

  Hi there I have a SSIS package with a connection manager as follows: Package.Connections[Output_Exi…

  Weegee2017

  7 replies

  4 years, 7 months ago

  By: Jeff Moden

• SSIS Lookup transform - populating the cache is done with one CPU core

  Hi all, I am currently building the ETLs for my Data Vault Business DWH. I have huge transactional …

  svenflock

  14 replies

  4 years, 7 months ago

  By: svenflock

• ssis expression on dt_dbtimestamp

  I'm working on a package using a conditional split where I need to work against updating rows and t…

  wm_wbt

  1 replies

  4 years, 7 months ago

  By: wm_wbt

• "Execute SQL"-tasks sent to MS SQL Server are not processed in parallel

  Hi all, I am using SQL Server 2016 with SSIS (latest patches installed as of January 2020). It has …

  svenflock

  4 replies

  4 years, 7 months ago

  By: svenflock

• Refresh Power Bi Dataset using API

  Hi , Can some one suggest me with the best approach to refresh power Bi using API in SSIS solution …

  Steve Dell

  1 replies

  4 years, 7 months ago

  By: Martin Schoombee

• Reading 'BLOB' data out of AS400 to SQL

  I have success in moving data from our AS400 to a new SQL instance, however there are a few tables …

  Brad Allison

  1 replies

  4 years, 7 months ago

  By: Brad Allison

• Reading 'BLOB' data out of AS400 to SQL

  I have success in moving data from our AS400 to a new SQL instance, however there are a few tables …

  Brad Allison

  1 replies

  4 years, 7 months ago

  By: Brad Allison

• How can you change the shape of a Precedence Constraint flow?

  I have an SSIS package with quite a lot of data flows and precedence constraints coming out of them…

  Weegee2017

  5 replies

  4 years, 7 months ago

  By: Thom A