SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Pick up the file

  Hi, I have to import Excel file data to a table. My excel file name is like this: filename_2006_06_…

  Data9

  5 replies

  17 years ago

  By: Phil Parkin

• source files with different col names, order... one mapping for all? fuzzy mapping?

  I've got a smattering of files, each containing the "same" data (ie. values are like). They're all …

  Greg J

  6 replies

  17 years ago

  By: Greg J

• How to configure Sendmail Task using Exchange Server

  Dear All I want to configure sendmail task with onsite exchange server . Which information should I…

  NIRANJANA1977

  1 replies

  17 years ago

  By: Elliott Whitlow

• SSRS - ENABLE/DISABLE PROMPTS/PARAMETERS

  SSRS - ENABLE/DISABLE PROMPTS/PARAMETERS hI ALL... I have a question in SSRS report, that I am desi…

  sql_learner29

  3 replies

  17 years ago

  By: Phil Parkin

• Connect to SSIS Service on machine "miloqadb" failed: Access

  I have a SQL-server Enterprise Edition 9.00.2047.00 (SQL 2005 - SP1) with SSIS on Windows…

  Ludwig Guevara

  4 replies

  17 years ago

  By: BudaCli

• 64 bit runtime issue

  hi there, i am having issues while running the package from 64 bit environment Actually it fails to…

  nabajyoti.b

  18 replies

  17 years ago

  By: nabajyoti.b

• Parameters in a foreach Cycle

  Greetings, I am experimenting a bit with the "new" DTS and testing I found the following questions…

  xavendano

  5 replies

  17 years ago

  By: NaffMonk

• Configuring the lookup in SSIS package

  Hi I have a Excel file and i have loaded the excel file data into table1 which for the validation p…

  MSKR

  5 replies

  17 years ago

  By: SSISSSRSSSAS

• Update the column in a flat file using Script task

  Hi friends, I want to update the Flat file column b4 using it into the data flow task. For ex : I…

  aravindkumar.porwal

  2 replies

  17 years ago

  By: aravindkumar.porwal

• Need .net script to dynamically set package variables at runtime

  Can someone supply me the .net script to dynamically set the value of 2 package variables at runtim…

  Express12

  9 replies

  17 years ago

  By: Express12

• How to update the lookup rows into the table

  Hi I have a lookup which can be updated or insert into my table.suppose i have 10 records i can ins…

  MSKR

  3 replies

  17 years ago

  By: steveb.

• Scripting of Maintenance plan

  whether we can do scripting of Maintenanceplan created in sql server 2005 ?

  SSRfromChennai

  1 replies

  17 years ago

  By: Ken Simmons

• How to check destination data before loading new data

  Whats the best way to achive this kind of functionality with SSIS? I have a version value stored as…

  Tupe

  1 replies

  17 years ago

  By: Phil Parkin

• SSIS Package Efficiency Question

  I am wondering if there is a better way to perform a task in my package. I have a series of 25 tabl…

  dataczar

  3 replies

  17 years ago

  By: NaffMonk

• Problem With Ole DB Source

  Hello everyone, I am trying to create an OLE DB Source which will get its SQL from a variable I hav…

  Erik Harrelson

  5 replies

  17 years ago

  By: Erik Harrelson