Integration Services

• Topics

  Started by

  Posts

  Last post

• SSIS ForEach Loop Container for XML Files with mixed content

  Hello, (can't upload images into body, neither .png or .jpg, size is less then 1024KB) My goal is t…

  lukaszpiech

  2 replies

  5 years ago

  By: AVB

• save mutiple ssrs reports from a ForEach loop into a single file

  Hello, I have a client who has a letter run that is produced monthly using a combination of SSIS an…

  david_h_edmonds

  2 replies

  5 years ago

  By: Martin Schoombee

• Flat File Connection Manager issue

  All, Firstly apologises as I think I've missed the obvious. I've been looking at this for a while a…

  as_1234

  10 replies

  5 years ago

  By: as_1234

• OLE DB Source Dynamic Source Name

  Hi All, Using VS 2017 I have a for each loop using a variable @currentfile to pass the file name of…

  ringovski

  1 replies

  5 years ago

  By: ringovski

• Package execution using SQL Agent job

  Hi, I have an SSIS package which uploads data to Azure blog, it runs fine on local machine but when…

  sindhupavani123

  1 replies

  5 years ago

  By: sindhupavani123

• 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

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

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

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

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

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

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

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

  5 years, 2 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, 2 months 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, 2 months ago

  By: Phil Parkin