Integration Services

• Topics

  Started by

  Posts

  Last post

• [ODBC Destination [2]] Error: Open Database Connectivity (ODBC) error occurred.

  I have been moving data succesffuly from SQLServer to Maria DB. Using this string  "DRIVER={MySQL O…

  yrstruly

  1 replies

  5 years, 1 months ago

  By: Mr. Brian Gale

• The table name could not be retrieved from the script provided

  I am having trouble moving data with ssis fromSQL Sever to Maria DB. When i run the following scrip…

  yrstruly

  3 replies

  5 years, 1 months ago

  By: Phil Parkin

• Deploy SSIS Package Error: "The selected folder does not contain package..."

  Hi All It seems TFS is not behaving itself! When I deploy a package I am getting the error above. I…

  MattieG72

  5 replies

  5 years, 1 months ago

  By: Gert_S

• SQL Server is changing the date format

  Hi All, I am using VS 2017 to import data from excel to a SQL table, very basic no problems with lo…

  ringovski

  3 replies

  5 years, 1 months ago

  By: Ant-Green

• TSQL To Maria DB

  I am trying to load dat from TSQL Into Mysql/Maria DB. I get an aoutamic warning when trying to cre…

  yrstruly

  3 replies

  5 years, 1 months ago

  By: Phil Parkin

• SSIS Package to load contents of CSVs to SQL Table

  I have 14 .csv files from which I need to extract 1) a date found only in the file name itself e.g.…

  DaveBriCam

  55 replies

  5 years, 1 months ago

  By: Thom A

• Whether to leave a clustered index on a staging table

  Hi Using dataflows to load data from one SQL table to another (seperate databases; not an exact cop…

  DamianC

  6 replies

  5 years, 1 months ago

  By: Grant Fritchey

• Last day of the previous month - Format MM/DD/YYYY

  I use the below to get Last day of Previous Month, but I want the date format to be MM/DD/YYYY.  We…

  SQL Server

  4 replies

  5 years, 1 months ago

  By: Alan Burstein

• Cannot Convert between unicode and non-unicode string data types

  Dear Group: I have an SSIS package that is failing with the following message:  Data Flow Task 1:  …

  AMCity

  1 replies

  5 years, 1 months ago

  By: Jeffrey Williams

• VS 2015 deploy to SQL 2019

  Hi We just had a SQL upgrade (SQL 2019) in our dev server and our SSIS solutions no longer work. We…

  spin

  1 replies

  5 years, 2 months ago

  By: TangoVictor

• Execute PowerShell script, via Execute Process Task, results into a Table...

  I'd like to Execute PowerShell script, via Execute Process Task and store the results into a SQL Ta…

  d_george

  2 replies

  5 years, 2 months ago

  By: d_george

• [ADO NET Source [2]] Error: The ADO NET Source was unable to process the data. F

  I am trying to get data from myslq into mssql with ssis. I am getting these errors: [SSIS.Pipeline]…

  yrstruly

  1 replies

  5 years, 3 months ago

  By: palandri

• Missing connections not causing a job failure

  Hello I have a package that logs using Configure SSIS Logs: Logging It logs to a database (log) I'v…

  DamianC

  1 replies

  5 years, 3 months ago

  By: DamianC

• SSIS executing SP with result sets bring none

  Dear friends, Please some advice. In my computer with SSMS, visual studio, I have a solution that i…

  Lou

  13 replies

  5 years, 3 months ago

  By: Phil Parkin

• SSIS Installation for Visual Studio

  Dear Group: I have two versions of Visual Studio installed:  VS 2015 and VS 2017 on two different m…

  AMCity

  3 replies

  5 years, 3 months ago

  By: Michael L John