Integration Services

• Topics

  Started by

  Posts

  Last post

• Importing Avro Files with SSIS

  Thanks in advance for any input. I’m attempting to import data within an .avro file. My understandi…

  ClockSpeed8

  4 replies

  4 years, 10 months ago

  By: ClockSpeed8

• SSIS Custom Task for creating Excel with formulae

  Hello everyone, I am currently looking for a way to create Excel reports that include formulae (pro…

  msdeibel

  8 replies

  4 years, 10 months ago

  By: vsanchezjauregui

• Issue in using Smartsheet CSharp SDK in SSIS Package

  Hi, I am using Smartsheet CSharp SDK in SSIS Script Task. I added it by nuget package, but getting …

  rajeshlohar

  1 replies

  4 years, 10 months ago

  By: rajeshlohar

• converting smallint to int in ssis

  Hi clever guys   I have two tables named dbo.jade.store and dbo.stage.Store.  The first has a …

  frdrckmitchell7

  1 replies

  4 years, 10 months ago

  By: frdrckmitchell7

• ispac file association broken

  I updated my visual studio 2019 professional recently, and when I try to double click an ispac file…

  kyagi.jo

  4 replies

  4 years, 10 months ago

  By: Phil Parkin

• XML Load Error

  Hello everyone,  I'm attempting to connect to an xml file so I can later load it to a SQL DB, but h…

  stricknyn

  1 replies

  4 years, 11 months ago

  By: Eddie Wuerch

• Visual studio 2019- Better performance to load 6.5 million record from flat file

  Visual studio 2019- Better performance to load 6.5 million record from flat file to ole db destinat…

  Jimmy@buster

  10 replies

  4 years, 11 months ago

  By: Jimmy@buster

• Anyone using Kingswaysoft ETL integration components?

  We're using their SharePoint integration toolkit. We only have a few jobs and have it installed on …

  TangoVictor

  2 replies

  4 years, 12 months ago

  By: Martin Schoombee

• SSIS Import Data - Dynamic filter for Date Where Date Field is Numeric(8,0)

  My apologies in advance as my SSIS knowledge is of a noob.  I can create simple packages importing …

  SoCal RS

  2 replies

  5 years ago

  By: TangoVictor

• csv file with dynamic field counts

  i have a csv file with dynamic field counts that i need to import into a table using data flow task…

  peacesells

  1 replies

  5 years ago

  By: Phil Parkin

• PowerShell Process Task fails in locked down Windows 10

  Hi Guys A weird one here. I run a process task to run powershell.exe with the argument -File C:\Ace…

  steve.alston

  1 replies

  5 years ago

  By: Mr. Brian Gale

• How to use user Defined Function in SSIS?

  Hi Friends, I have written a function which i would like to use in ssis... I don't know how to call…

  Charmer

  3 replies

  5 years ago

  By: JMJ

• SIS gets stuck on data flow task loading screen upon opening project

  I'd like to start by mentioning that I have searched for this topic, although there are similar sol…

  uahmed90

  4 replies

  5 years ago

  By: uahmed90

• variable to hold the time the package started - to remain statisc

  I need a datetime stamp that once it's set won't change not matter how many times it's called by da…

  polkadot

  2 replies

  5 years ago

  By: polkadot

• Disable Package Expression

  Hi SSC, I've got 2 Project Variables which I use to control wether a package should run or not thro…

  DinoRS

  3 replies

  5 years ago

  By: Phil Parkin