Integration Services

• Topics

  Started by

  Posts

  Last post

• looking for tables or columns etc. within a SSIS package

  Hi I have a SSIS project that has around 30 packagesIs there an easy way to search though all the p…

  DamianC

  4 replies

  8 years, 11 months ago

  By: Mohit Dhiman

• SSIS package column errors cannot convert between unicode and non unicode data types

  I have a source column where - col1 varchar and in OLEDB source we are doing select ltrim(rtrim(co…

  mcfarlandparkway

  1 replies

  8 years, 11 months ago

  By: Thom A

• SSIS - Cannot Open the data file.

  Query 1:I have tried to execute a SSIS package and the following is the result:DataFlow Task 1:Erro…

  EwanAC

  11 replies

  8 years, 12 months ago

  By: Phil Parkin

• Unit Testing In SSIS For Visual Studio 2015

  Good Afternoon Guys, I am fairly new on creating SSIS and was able to create a very basic and simpl…

  Stylez

  1 replies

  8 years, 12 months ago

  By: Phil Parkin

• Change Tracking: SSIS vs stored procedures - discussion

  We have a nightly process that drops and re-creates reporting tables. I'm looking to SQL Server (2…

  sfpdev555

  4 replies

  8 years, 12 months ago

  By: Tim Mitchell

• SSIS- File reading and processing

  I am having 5 different folder which are placed in my one of the drive. Each folders will receive t…

  yuvipoy

  6 replies

  8 years, 12 months ago

  By: Thom A

• Using Checkpoint

  Folks, Hav a good day. i need a clarification regarding usage of checkpoint in SSIS. i set a checkp…

  Kannan Vignesh

  6 replies

  8 years, 12 months ago

  By: Phil Parkin

• Fetch the last run time

  Hi, I am pulling data from webservice and putting it into oracle table. Now my requirement is , I h…

  abhas

  3 replies

  8 years, 12 months ago

  By: Thom A

• Long running data flow task

  Hoping somebody can help. We have a data flow task in an SSIS package that is called from a SQL jo…

  karen.ferrara

  7 replies

  8 years, 12 months ago

  By: MMartin1

• Visual Studio 2015 and SQL Server 2014

  I've been doing some limited testing and it seems that packages developed in VS2015 can be successf…

  Phil Parkin

  8 replies

  9 years ago

  By: brianpsmith81

• script task being completely ignored

  I have a server with SQL Server 2016 on it, using SSDT 2015, and I have tried using project deploym…

  kyagi.jo

  15 replies

  9 years ago

  By: LemonLime

• Create delimited file from SQL XML column type

  I need to create a delimited file from an XML column in SQL. i had initially tried doing this by cr…

  jimsefton

  3 replies

  9 years ago

  By: jimsefton

• SSIS Package - sql task using stored procedure not populating all columns

  Hi, I am having trouble with SSIS package which should insert rows from my Object named EmployeeLis…

  rtp

  2 replies

  9 years ago

  By: Jamie Ingram-729524

• Need help in SSIS(SSIS to MySQL ) error while updating date column to MYSQL

  hi all, Hope all are fine. I am trying to create a SSIS package which will take excel source col…

  JoNTSQLSrv

  2 replies

  9 years ago

  By: JoNTSQLSrv

• [Flat File Source [15]] Error: Data conversion failed. The data conversion for column returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

  Hello all, I am using a text file as a source file and destination is a sqlserver database 2012 tab…

  Pyman

  2 replies

  9 years ago

  By: Phil Parkin