Integration Services

• Topics

  Started by

  Posts

  Last post

• scheduling the SSIS jobs

  Hi I have Packages in Integration Service Catalog (SQL Server 2012) and I used project deployment a…

  VRT

  2 replies

  10 years, 12 months ago

  By: SQL.AP

• precendence constraint expression isn't evaluating to boolean True / False, but why?

  Here's the expression: @rowcount_24631 == @sqlRowcount_24631 Datatypes on both sides of the equal s…

  KoldCoffee

  4 replies

  10 years, 12 months ago

  By: SQL.AP

• Resync Input Clumns

  VS 2008 I am re-using a package from another database that puts data from a table into a Flat File.…

  uncle_boris

  5 replies

  10 years, 12 months ago

  By: SQL.AP

• Package failed

  Hi, I have a DFT in a package which loads around 2lakhs records in to destination but, it fails loa…

  Krishh

  4 replies

  11 years ago

  By: Phil Parkin

• Comparing Data from files

  We are using SQL 2008. We receive a files from different clients throughout the year. These files c…

  GF

  1 replies

  11 years ago

  By: SQL.AP

• Phantom SSIS crash/fail converting DT_NEXT to DT_TEXT

  Hi all, An SSIS 2012 package I am supporting has been failing for a few days now (prior to that it …

  Nevyn

  2 replies

  11 years ago

  By: Nevyn

• Execute SQL Task -SSIS

  Hi I am trying to insert in table using execute sql task. I want to pass value of Load_Frequency th…

  vipin_jha123

  3 replies

  11 years ago

  By: Phil Parkin

• Table does not exists Error

  Hi All, I have one stage table and one main table. I am loading data from a source server to the st…

  SQL.AP

  5 replies

  11 years ago

  By: SQL.AP

• NEED TO REMOVE DUPLICATES IN FLATFILE

  Hi Everyone, which one is the best way to remove duplicates in flatfile before loading into DataBas…

  Kannan Vignesh

  4 replies

  11 years ago

  By: Jeff Moden

• track table using ssis

  hi, can we track how many rows are update and delete per day using ssis please let me know how to d…

  super48

  1 replies

  11 years ago

  By: Jack Corbett

• looping through server list to ping without script tasks

  I am using execute SQL task to capture all server list from a column from a SQL table(serverslist,f…

  mtz676

  1 replies

  11 years ago

  By: michal.lisinski

• SSIS Fails with buffer errors when run from a Job - SQL 2008 R2

  I have developed an incremental load in SSIS. It utilizes a Lookup component. I designed it using …

  dmayley

  7 replies

  11 years ago

  By: Eirikur Eiriksson

• Check for New Or Updated Records using SSIS

  I apologize if this has been asked before (I'm sure it has), but I'm stuck on an issue with SSIS an…

  treyagrimes

  6 replies

  11 years ago

  By: treyagrimes

• flat file loads to stage 1 row short of expected

  The txt file I need to import has 965240 data rows. 965241 if you include header. Loaded to sql s…

  polkadot

  4 replies

  11 years ago

  By: KoldCoffee

• [Flat File Source [1]] Warning: There is a partial row at the end of the file. using 2008 R2

  Does anyone know the fix? Have read this article and tried suggestions: http://stackoverflow.com/q…

  polkadot

  8 replies

  11 years ago

  By: polkadot