Integration Services

• Topics

  Started by

  Posts

  Last post

• Update Data in Prod table. Lookup ? Merge?

  Hi, I am in need of a solution. I am supposed to load the data of a table from PROD server to UAT. …

  connect.akshay

  6 replies

  13 years ago

  By: Paul Hernández

• Problem to create a CONNECTION MANAGER inside a SSIS

  Hi to all. I currently use SSIS of SQL SERVER 2008 R2 to create data flow to import data from seve…

  maretix

  7 replies

  13 years ago

  By: maretix

• Merge,Look Up,SCD which one is good for millions of records

  Hi, I am new to SSIS. I have to load 50 millions of records(full load) into a SQL Server table. Aft…

  Rocky's

  2 replies

  13 years ago

  By: Paul Hernández

• Datatype Issue ..SSIS

  HI, I have a task in ssis which loads data into DB from Source Files on my Drive, Issue is : …

  iamsql1

  3 replies

  13 years ago

  By: iamsql1

• ETL Standards

  Hi Guys, I've been tasked with creating an ETL framework document that contains a set of standards …

  Chris-475469

  4 replies

  13 years ago

  By: Chris-475469

• IS 2008 Triggering an Excel Macro via Script Task - The Binary Code for the script is not found

  I have a Macro which works in Excel. It basically just formats headers and creates a validation lis…

  Debbie Edwards

  17 replies

  13 years ago

  By: Debbie Edwards

• Discover the column types of a DB2 DB without Data Dictionary and Documentation

  Hi all, I just want to discuss a method with you to discover the column data types of a table in a …

  Paul Hernández

  2 replies

  13 years ago

  By: Paul Hernández

• Problems with Excel source extraction

  I have an excel file with sheet containing 210000 records..I am trying to extract this file into a …

  rockstar283

  4 replies

  13 years ago

  By: rockstar283

• Integration services Configuration

  Just wanted to find some information on SSIS configuration. Consider this scenario: I have a dataso…

  eseosaoregie

  3 replies

  13 years ago

  By: aaron.reese

• Slowly Changing Dimensions: Change Source via config

  Hi Guys I have a dataflow task that connects to a Progress database and extracts a delta of records…

  aaron.reese

  1 replies

  13 years ago

  By: aaron.reese

• Weird Behavior in Data Flow

  I'll start off with an apology for rather vague subject line but I can't think of any other way to …

  dlander525

  1 replies

  13 years ago

  By: Evil Kraig F

• The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".

  I have a csv file (FIXED Width) with one cloumn and I read that column as string data type and then…

  quillis131

  7 replies

  13 years ago

  By: Orlando Colamatteo

• Recurring errors in Loop ( SSIS )

  I have an SSIS package where I am processing some files in a ForEach loop. In the loop I have a dat…

  connect.akshay

  4 replies

  13 years ago

  By: connect.akshay

• SQL Task only passing first character of string to procedure

  I've created an ADO.Net connection to a SQL 2005 instance and am using a Execute SQL Task to pass t…

  Erin Ramsay

  5 replies

  13 years ago

  By: Jeff Moden

• SSIS Default Package Settings

  Does anyone know how to change the default package setting "ProtectionLevel" so that I do not have …

  dwilliscp

  1 replies

  13 years ago

  By: Phil Parkin