Integration Services

• Topics

  Started by

  Posts

  Last post

• SSIS task and transformation types in SSISDB

  Hello   Does SSISDB hold the type of task anywhere It would make querying for slow tasks or da…

  DamianC

  4 replies

  6 years, 2 months ago

  By: DamianC

• SSIS 2016 Script task runs but file not created

  So I have a Visual Studio 2017 Package Deployment package (ProcessOrders) that has a Script Task Ed…

  dwilliscp

  4 replies

  6 years, 2 months ago

  By: dwilliscp

• How do you organize your SSIS projects?

  Hi, I'm currently organizing/deploying my SSIS projects as: Integration Services Catalogs SSISDB…

  Scott In Sydney

  3 replies

  6 years, 2 months ago

  By: Scott In Sydney

• how to check if file contains only column headers without data

  Hi All, i have a task to check file (excel & text) before loading to a table. checking conditio…

  caojunhe24

  3 replies

  6 years, 2 months ago

  By: palandri

• SSIS Excel Import Error

  Hello, I'm an SSIS newcomer, but, far as I can tell, have done everything correctly.  In a nutshell…

  John524

  15 replies

  6 years, 2 months ago

  By: annjunk

• Can't stop script task from escaping my string

  public void Main() { // TODO: Add your code here string filePrefix;…

  Jay@Work

  4 replies

  6 years, 2 months ago

  By: Jay@Work

• Export to csv then FTP using variables

  Hi, Ive created a package that exports using a dynamic filename but for the life of me, i cannot ge…

  Darryl Wilson

  1 replies

  6 years, 2 months ago

  By: Phil Parkin

• compression file - Error: Exception has been thrown by the target of an invocati

  #Region "Imports" Imports System Imports System.IO Imports System.IO.Compression #End Region Public…

  HernaniGarcia

  1 replies

  6 years, 2 months ago

  By: Phil Parkin

• Is it a bad idea to create a user-defined stored procedure in SSISDB database?

  Hi, I hope this is the right forum... I have created some SSIS packages that a rather inexperienced…

  Scott In Sydney

  5 replies

  6 years, 3 months ago

  By: Phil Parkin

• SSIS package

  Hi, I’m new to Integration services SSIS. I have developed a package & want to deploy it. Befor…

  VSSGeorge

  3 replies

  6 years, 3 months ago

  By: frederico_fonseca

• Automate the SSIS package to take Start and enddate

  I have a master/parent package, that calls the child packages in SSIS. The Master package takes the…

  komal145

  2 replies

  6 years, 3 months ago

  By: heb1014

• Execute SQL task, fail component if stored procedure enters try catch regardless of throw

  I have stored procedure with a structure of begin try / end try ........ begin catch / end catch, a…

  ipisors 92539

  8 replies

  6 years, 3 months ago

  By: ipisors 92539

• SSIS merge 2 files with different columns

  Hi I am trying to create a pipe delimited file with double quoted qualifier. It also needs to inclu…

  spin

  4 replies

  6 years, 3 months ago

  By: ashley.moller1

• execute process task with curl

  hi i need to use rest API to authorize url. i am using curl.exe. in response, i should get session-…

  coool_sweet

  1 replies

  6 years, 3 months ago

  By: Steve Collins

• Package deployment error

  When I try to deploy SSIS package using package deployment, I am getting the error message below: T…

  VSSGeorge

  5 replies

  6 years, 3 months ago

  By: Phil Parkin