Integration Services

• Topics

  Started by

  Posts

  Last post

• Execute SQL Task error

  I'm creating a simple package where i created a Temp table in Execute SQL task and in DFT i'm copyi…

  uzn2010

  2 replies

  9 years, 5 months ago

  By: Phil Parkin

• prevent auto validation of data connection when opening an SSIS package

  Does anyone know of a global way in SSIS to prevent the validation/authentication of data connectio…

  brad.pears

  7 replies

  9 years, 5 months ago

  By: Eric M Russell

• Need to load date from datepart from a table to a file

  I have a table with datetime column something like this : 08-09-2016 00:00:00 I would like to get…

  komal145

  5 replies

  9 years, 5 months ago

  By: Luis Cazares

• Comparing multiple source and destination files in SSIS

  I have to compare the source excel file with destination SharePoint list to remove duplicates. How …

  uzn2010

  1 replies

  9 years, 5 months ago

  By: RMason - eLIMBS, LLC

• SSIS Performace Issue

  [font="Verdana"] I'm loading the couple of text files to SQL Server Database and each file contains…

  koti.raavi

  11 replies

  9 years, 5 months ago

  By: Phil Parkin

• NOOB Error 30311: Value of type 'String' cannot be converted to 'Microsoft.SqlServer.Dts.Pipeline.BlobColumn'

  I am trying to store a large formated string in an TEXT (text stream [DT_TEXT]) column. The error …

  weepecky

  7 replies

  9 years, 5 months ago

  By: sanmati.halingali

• When i run SSIS project its show error SSIS Error Code DTS_E_OLEDBERROR

  Any can help how can we solve the following error Error2Validation error. LCMS Resultat fil Conne…

  seubaid

  1 replies

  9 years, 5 months ago

  By: SoHelpMeCodd

• SSIS PROJECT ERROR ON BUILD

  I have SSIS project for the purpose to fetch data from excel sheet and first insert data into datab…

  seubaid

  1 replies

  9 years, 5 months ago

  By: Phil Parkin

• Connection Manager Password Problems

  Hi. I have been using SSIS since 2005, I have used it extensively in 2008 and 2012. I now find that…

  tim.ffitch 25252

  5 replies

  9 years, 5 months ago

  By: Eric M Russell

• Data validation

  I have two tables. table 1(source) and table 2(destination),They tie out in most months but not fo…

  Aaryan

  1 replies

  9 years, 5 months ago

  By: Phil Parkin

• Reading data from Google Spreadsheets

  Hi everyone, I'm looking into reading data from Google Spreadsheets, and found a couple of articles…

  Jonathan Mallia

  2 replies

  9 years, 5 months ago

  By: Phil Parkin

• Funny asterix character in SSIS

  Hi guys I have a csv file and column A has numeric values (1,2,3,etc), but when I create a File Con…

  frdrckmitchell7

  6 replies

  9 years, 5 months ago

  By: Phil Parkin

• date format YYYMMDD HH:MM:SS ssis expression

  hi I need date format somethimng like this YYYMMDD HH:MM:SS i wrote expression like below but issue…

  komal145

  4 replies

  9 years, 5 months ago

  By: tim.ffitch 25252

• SSIS package fail

  Hello, I am trying to run an SSIS package on SQL agent for sQL server 2008 r2, i get this message b…

  Siten0308

  5 replies

  9 years, 5 months ago

  By: JustMarie

• Importing Excel sheet with vertical and horizontal data

  Does anyone know how I can get the values in the first column of the spreadsheet to pertain to the …

  pnr8uk

  3 replies

  9 years, 5 months ago

  By: Phil Parkin