Integration Services

• Topics

  Started by

  Posts

  Last post

• Help! it's a string, not an int! When passing date start/end string variables to oledb sql query, get "Conversion failed when converting the nvarchar value '2014-07-30' to data type int.".

  Please help me find out how to get past this error. [OLE DB Source 1 [98]] Error: SSIS Error Code…

  KoldCoffee

  6 replies

  11 years, 5 months ago

  By: Lynn Pettis

• Execute Package Task failing even though dtsx package it calls had a failure that was corrected

  I have an ssis package called 'master scheduler' which has an Execute Package Task that kicks off a…

  polkadot

  2 replies

  11 years, 5 months ago

  By: KoldCoffee

• Common encountered errors in SSIS

  Hi, I am currently writing my Bachelor Thesis about error handling in SSIS and generally increasing…

  Velym

  3 replies

  11 years, 5 months ago

  By: Koen Verbeeck

• SSIS on SQL Server 2008R2 "The value is too large to fit in the column data area of the buffer."

  Hi -- stuck on this problem. I have a package which takes in records like: Type Data H ....…

  gbritton1

  13 replies

  11 years, 5 months ago

  By: Koen Verbeeck

• SSIS checking datatype Int

  Hi all I have been trying to check a row of data that is coming from an SQL DB. It should only hold…

  mark.j.clark84

  4 replies

  11 years, 5 months ago

  By: mark.j.clark84

• SSIS Analysis Services Processing Task.

  Hi SSIS - 2008R2 SSAS - 2012 I have got a very weird problem. I am trying to build a package on SS…

  brian118

  7 replies

  11 years, 5 months ago

  By: brian118

• expression yyyymm with mm-1

  In My derived column I want expression for getting yyyymm ( where mm is mm-1) Expression in Derived…

  Shanmuga Raj

  1 replies

  11 years, 5 months ago

  By: Lynn Pettis

• SSIS package for INSERT/UPDATE from Oracle to SQL server Table

  Hi , I need some info. about the Insert and updating the Records from Oracle Table to SQL server…

  Guitar_player

  4 replies

  11 years, 5 months ago

  By: Guitar_player

• Migration Wizard - missing conversion of Datapump tasks

  Hi, I'm working on the conversion of a group of DTS to SSIS and the function of a part of them is t…

  alezar

  1 replies

  11 years, 5 months ago

  By: Phil Parkin

• Bug in foreach loop with ado.net enumerator

  Hi Greetings to everyone, Today I am going to report a bug in SSIS 2012. In one of the packages I w…

  er.lokeshsharma08

  2 replies

  11 years, 5 months ago

  By: er.lokeshsharma08

• Help me: How to capture the execution results (execution time) ??

  Hi Friends, I am just entering into the world of SSIS, I have to capture each of the execution time…

  prabhu.st

  2 replies

  11 years, 5 months ago

  By: Shawn Melton

• ssis error in excel connection manager

  Hi, i have a ssis package where i import excel to sql table destination. . i created a excel connec…

  susmitha117

  4 replies

  11 years, 5 months ago

  By: prabhu.st

• Replace a carriage return in SSIS

  Hi All, I have a flat file with data as below: row delimiter: {CR}{LF} column delimiter: |…

  Data9

  4 replies

  11 years, 6 months ago

  By: Luis Cazares

• SSIS variables

  Greetings 🙂 I've a one-off task to input a bunch of CSV files and feel ... this is a job for ssis. …

  richardbriansmith-814479

  3 replies

  11 years, 6 months ago

  By: rhythmk

• ssis data conversion

  Hi, I have excel source and oledb destination. I am facing few errors ' ID cannot convert between u…

  susmitha117

  2 replies

  11 years, 6 months ago

  By: SQLRNNR