Integration Services

• Topics

  Started by

  Posts

  Last post

• SSIS not reading in data for February

  Please test. Im not getting any data for February, but it is available. Attachments:You must be log…

  yrstruly

  2 replies

  1 years, 11 months ago

  By: Phil Parkin

• Run Time Error - at System.RuntimeMethodHandle.InvokeMethod

  I am getting an error when running an SSIS ETL, converting aN Excel to CSV. Please assist. at Syst…

  yrstruly

  1 replies

  1 years, 11 months ago

  By: Phil Parkin

• Unpivot in SSIS

  I want to Unpivot some data. Please guide me in selecting the correct columns etc. My table is: My…

  yrstruly

  1 replies

  1 years, 11 months ago

  By: frederico_fonseca

• Eliminating CSV Conversion Step

  Please assist. I have inherited this ETL. I am trying to eliminate unnecessary steps like the Conve…

  yrstruly

  2 replies

  1 years, 11 months ago

  By: Mr. Brian Gale

• Converting Excel to CSV - SeverityCodeDescriptionProjectFileLineSuppressio

  I am trying to convert an Excel to CSV. I am getting an error, using the code below:   #region…

  yrstruly

  6 replies

  1 years, 11 months ago

  By: yrstruly

• DB Native versus Win Authentication with SSIS Packages and Deployment

  Hi there, I have done a migration of Informatica PowerCenter ETL project to MS SSIS project using V…

  WilburSmith

  24 replies

  1 years, 11 months ago

  By: WilburSmith

• SSIS package change and Project element is missing error

  Hi All, I am now venturing into the fun world of SSIS, only ever performed things in a tutorial sen…

  Kazmerelda

  3 replies

  1 years, 11 months ago

  By: KinjoXuLee

• Not picking up a specific period

  Please assist. I am trying to bring in Period 8 which i find myself in. Its available in the data. …

  yrstruly

  1 replies

  1 years, 11 months ago

  By: Ant-Green

• Transferring data from one secure server to another -SSIS/SQL Server Agent Jobs

  I have created an SSIS package which moves data from one external server (accessible using a differ…

  Susan Evans

  6 replies

  1 years, 11 months ago

  By: Susan Evans

• Excel Source [24]] Error: System.Exception: SqlTruncateException:

  Please assist. I am using SSIS to read data from an Excel sheet into Postgres. I have increased the…

  yrstruly

  5 replies

  1 years, 11 months ago

  By: Phil Parkin

• Is there a such thing as connections being made too fast in a package?

  Hi all, SSIS doing some quirky things and I wanted to run a scenario just too see if anyone else ha…

  stricknyn

  5 replies

  1 years, 11 months ago

  By: Phil Parkin

• Extracting data from Dynamics into data warehouse problem with expired details

  So Dynamics/D365 requires setting up of an app in Azure Portal along with a certificate / secret. a…

  Bhagat

  3 replies

  1 years, 11 months ago

  By: Phil Parkin

• Corrupt SSIS Package & Unsupported Error

  I am using the Community Edition of SSIS/Visual Studio. I find that my SSIS package can get corrupt…

  yrstruly

  3 replies

  1 years, 11 months ago

  By: Jeffrey Williams

• How to Connect to Azure Database for MySql

  Dear, I need to retrieve data from Azure Database for MySql using SSIS. I am able to connect to pre…

  a2zwd

  2 replies

  1 years, 12 months ago

  By: a2zwd

• SSIS Config File Query

  Hello everyone, I have created a SSIS package that runs daily and it downloads an XML file, reads i…

  Jobs90312

  2 replies

  2 years ago

  By: Jobs90312