Integration Services

• Topics

  Started by

  Posts

  Last post

• Parallel package locking issue

  All, Firstly this is just a self teaching exercise so there is no urgency. Secondly I suspect this …

  as_1234

  12 replies

  6 years ago

  By: as_1234

• SQL Agent SSIS imports data but still fails

  Hello, This is from another issue I was dealing with, but Phil help fix this, but now I am running …

  Siten0308

  2 replies

  6 years ago

  By: Siten0308

• Using msrepl_tran_version as method to select records for an upsert operation

  I have a situation where I am pulling data into my DW from a server that is populated by replicatio…

  latkinson

  1 replies

  6 years ago

  By: latkinson

• Relative Path for Packages

  We are at a client that is using SSIS 2014 File based packages, and we are in the process of deploy…

  imani_technology

  7 replies

  6 years ago

  By: imani_technology

• Run Packages from command line on my workstation

  I know that it would be a ton easier to be able to deploy SSIS packages to a sql server & run t…

  Steven.Grzybowski

  2 replies

  6 years ago

  By: Steven.Grzybowski

• SSIS datatype mapping of Oracle Number columns

  Hello all, I am struggling with an issue regarding data transfer from Oracle (Release 11.2.0.1.0) t…

  Martin_A

  7 replies

  6 years ago

  By: convertIssue

• Export dtx package but doesnt work on SQL Agent

  Hello, So I am trying to get this simple SSIS package to work on SSISDB, it has 1 variable called S…

  Siten0308

  19 replies

  6 years ago

  By: Phil Parkin

• SSIS - Connection Problem when outputting to an Excel Binary Workfile (.xlsb)

  Hello All, I'm just about trearing my hair out with a Connection problem when I'm writing to an Exc…

  Magical Horn

  7 replies

  6 years ago

  By: Siten0308

• Export SQL data to Excel with subtotals and the same subtotals

  Hi, I am using SSIS 2019 to export data from SQL query to Excel. The issue is that I need to put a …

  henkvl

  1 replies

  6 years ago

  By: Mr. Brian Gale

• 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

  6 years 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

  6 years 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

  6 years 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

  6 years 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

  6 years, 1 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

  6 years, 1 months ago

  By: Phil Parkin