Integration Services

• Topics

  Started by

  Posts

  Last post

• 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

  12 years, 10 months 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

  12 years, 10 months 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

  12 years, 10 months 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

  12 years, 10 months 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

  12 years, 10 months 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

  12 years, 10 months 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

  12 years, 10 months 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

  12 years, 10 months 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

  12 years, 10 months 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

  12 years, 10 months ago

  By: Phil Parkin

• How to automate validation process

  Hi, We have the following scenario: We receive CSV files every month for which SSIS packages were …

  sql_er

  4 replies

  12 years, 10 months ago

  By: Orlando Colamatteo

• Twice number of reows loading from sql table to Excel.

  Hi, I am having sqltbl which contains empid,Lname,Fname,Sal records. I am simply fetch all records …

  abhas

  1 replies

  12 years, 10 months ago

  By: Phil Parkin

• few clarifications in coverting date to string literals

  I need to work on SSIS in converting date format to string literals. 1)Input:2013-03-01 Output:03-M…

  manibad

  2 replies

  12 years, 10 months ago

  By: manibad

• SSIS 2012: Split project Parameter string value and loop through split values

  I am currently working on an SSIS solution which employs a parent child design pattern. There is a …

  eseosaoregie

  1 replies

  12 years, 10 months ago

  By: eseosaoregie

• Run Script on multiple SQL Server Instances

  I need to create an SSIS package that will run a script on multiple SQL Server Instances. I need to…

  Fred Woolverton-442598

  4 replies

  12 years, 10 months ago

  By: rx77