Integration Services

• Topics

  Started by

  Posts

  Last post

• 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, 3 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, 3 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, 3 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, 3 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 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, 5 months ago

  By: Phil Parkin

• C# Script for sending email

  Can anyone help me with some script to send email with C#. I tried the "Send Mail Task" and it fail…

  DaveBriCam

  2 replies

  1 year, 5 months ago

  By: malcomjarr

• Iterate Through Tables, Using a Control Table w/ a List of Tables to Process?

  I'm trying to create an SSIS package that will query a master control table [TableList], which cont…

  Rich Mechaber

  9 replies

  1 year, 5 months ago

  By: TangoVictor

• You have an error in your SQL syntax; check the manual that corresponds

  I am having great trouble creating a data pipeline using MariaDB connector 3 with SSIS/Mysql connec…

  yrstruly

  8 replies

  1 year, 5 months ago

  By: frederico_fonseca

• Visual Studio 2019 Pro won't load my projects

  HI all, For some reason I've been having issues with VS pro opening up my projects that are in my S…

  craig.bobchin

  3 replies

  1 year, 6 months ago

  By: craig.bobchin