Integration Services

• Topics

  Started by

  Posts

  Last post

• Calculating Days/Time(Are Loops Neccessary?)

  I have a table that need to give me all data up until yesterday. This will be part of an SSIS packa…

  yrstruly

  1 replies

  1 year, 3 months ago

  By: Phil Parkin

• Script Editor not opening

  Please assist. My script editor dont open, it is giving me a time out or delay. I tried to retarget…

  yrstruly

  5 replies

  1 year, 3 months ago

  By: Phil Parkin

• BIML Visual Studio 2022

  Hello, We use bimlexpress a lot in Visual Studio to autogenerate packages with BIML Is there a repl…

  Jo Pattyn

  2 replies

  1 year, 3 months ago

  By: Jo Pattyn

• Qick way in creating a unique column(s) using SSIS

  Please assist. I have developed an ETL, using these codes to get data from the source and to the de…

  yrstruly

  1 replies

  1 year, 3 months ago

  By: Phil Parkin

• Connecting SSIS 2008 to Sharepoint 2010 authentication - connection issues

  Hello, I'm trying to connect SSIS 2008 (SQL Server 2008 R2) to SharePoint 2010 at the client I'm at…

  ngosz

  1 replies

  1 year, 4 months ago

  By: whomedss

• Merging Data Sets in similar way as VLookup

  I want to automate my manual Vlookup using Excel to SQL/SSIS. Table: is used with   The columns t…

  yrstruly

  1 replies

  1 year, 4 months ago

  By: yrstruly

• Job Step Properties - Configuration - Parameter Issue

  Hi, I am fairly certain that both myself and my colleagues could ALL change the configuration param…

  Sthornton

  4 replies

  1 year, 4 months ago

  By: Jeffrey Williams

• Acquired Connection method failed error code 0xC0014009

  Hi, We have a set of around 24 packages running on daily basis. Source - ODBC (hadoop db) destinati…

  kirti

  3 replies

  1 year, 5 months ago

  By: qaiser2001pk

• Script task to get oauth 2.0 token error

  I am trying to figure out a way to get oauth2.0 bearer token from the rest API. So from Postman I c…

  lazy_titan

  9 replies

  1 year, 5 months ago

  By: lazy_titan

• script error

  hi my target server is in 2016 ( 13.0.4206.0) to run sql server agent job . I am using visual stud…

  coool_sweet

  13 replies

  1 year, 5 months ago

  By: lazy_titan

• How to skip Deleted Servers

  I have a SQL table with some servers and a package which runs of those servers. 1.Execute task to l…

  mtz676

  2 replies

  1 year, 5 months ago

  By: rkgigliotti

• ANSWERED - Flat file problem - input column is 1252 and is required to be 65001

  I am only trying to copy a whole table into a flat file, with column names and all. I made a blank …

  etl.laptop

  4 replies

  1 year, 5 months ago

  By: abjames

• deploy ssis package to MSDB db in SSIS server using azure pipeline

  Has anyone tried deploying ssis to MSDB db in SSIS server using Azure pipeline?  I am used to do t…

  peacesells

  1 replies

  1 year, 5 months ago

  By: peacesells

• How to add CustomerID and LastName to the file name in SSIS?

  There are several text files that are saved in a local driver. The file names are: Each file has o…

  sxzhu

  5 replies

  1 year, 6 months ago

  By: Phil Parkin

• Upgrade to SQL2022 makes packages that connect to Oracle fail with data errors

  We have 3 environments, dev, uat and prod. We've started to test SQL2022 by doing an in-place upgra…

  stiej1977

  3 replies

  1 year, 6 months ago

  By: Phil Parkin