SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Can SSIS File System Task handle multiple files with "Move file" Operation?

  I have a File System Task which uses a SourceVariable to set source files. My SourceVariable was pa…

  ktlady

  4 replies

  16 years, 12 months ago

  By: ktlady

• SSIS HELP...please

  I have a SSIS package that needs to run on my production server...A little background...Two files a…

  asm1212

  3 replies

  17 years ago

  By: Elliott Whitlow

• Little Help in SSIS

  Hi to all, Suppose i have a table A with the fields (RaID INT, TiID INT, Path VARCHAR(50), and i wa…

  carlos.tapadinhas

  5 replies

  17 years ago

  By: Elliott Whitlow

• Copy flat file source settings to new SSIS package?

  Hello, Is it possible to copy a flat file source definition - including the field-by-field mappings…

  webrunner

  7 replies

  17 years ago

  By: webrunner

• Merge join and concatenate into a single table...

  Hello I have this scenario, I am using the northwind database as a sample and within that database …

  b_boy

  2 replies

  17 years ago

  By: b_boy

• Pass Database Variable Names in SQL Command

  Hi, I got a lot of sql scripts that joins tables from multiple databases and I need to be able to c…

  pheradrales

  4 replies

  17 years ago

  By: COZYROC

• Using the same XML configuration file for configuring connection string of multiple packages in SSIS

  Hi, Is it possible to configure connection string of multiple packages of same solution file in SSI…

  srinso

  1 replies

  17 years ago

  By: COZYROC

• How to set up oracle 11g as linked server in sqlserver 2005

  Hi I have an Oracle11g DB on a LINUX(Oracle Enterprise Linux) platform and I need to create a linke…

  haribabu_rk

  1 replies

  17 years ago

  By: COZYROC

• WSDL file and Web service task

  i am trying to use webservice task, is there anyway i need not download wsdl file and just use it f…

  keywestfl9

  1 replies

  17 years ago

  By: COZYROC

• column names in first row...with...(do not) overwrite data in the file

  In my Connection Manager for a flat file, I checked "Column names in first row". In my Flat File De…

  dglane

  1 replies

  17 years ago

  By: COZYROC

• Raw File Destination/Source builds raw file on the fly, validation errors

  Hi, I'm trying to 1) create a Raw file on the fly in the directory C:\SSIS, 2) write data to a Raw …

  Devo_SQL

  2 replies

  17 years ago

  By: lianaent

• Schedule SSIS Package as a Job

  I've create a SSIS Package and deployed it to my production sql server and am having trouble gettin…

  JeffJ

  4 replies

  17 years ago

  By: atul.kinekar

• Read Filename into a variable

  Hi all. In SSIS I have a FOR EACH LOOP container that reads the file paths of all csv files contain…

  Ray Waldron

  5 replies

  17 years ago

  By: Ray Waldron

• How to use SSIS Config file with multiple connectionstring and how to pick the connectiong string depeding upon input value

  Hi, I have requirement in SSIS packages. I need to store multiple connection string in one confi…

  surya.narayana

  12 replies

  17 years ago

  By: Balaji L

• Oracle 10g to MSSQL 2008 - Linked server works - SSIS won't.

  Background: We are trying to set up an ETL/Dataload job from an Oracle 10g database to a SQL Server…

  thepotplants

  4 replies

  17 years ago

  By: thepotplants