SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Excel File with more than 256 columns

  Hi All, I have an excel file with more than 256 columns. And the current driver (Jet OLEDb) doesnt …

  sam 55243

  9 replies

  11 years, 9 months ago

  By: COZYROC

• BlobTempStoragePath and BufferTempStoragePath - Default Location Change

  Hi SQL Experts We have an issue at the moment where we are encountering the following error on our…

  amcalpine

  2 replies

  11 years, 9 months ago

  By: John Mihalko

• SSIS help

  I manually run reports now in the following manner: Run two different sql scripts that pull data fr…

  dchapman 44037

  2 replies

  11 years, 9 months ago

  By: dchapman 44037

• Find BIDS package via MSDB

  We save our SSIS packages to MSDB and all is good except ... one of the packages needs to be change…

  Shaira

  1 replies

  11 years, 10 months ago

  By: Shaira

• generate dynamic column names from a table using ssis

  I tried to create Execute SQL task for the following procedure by creating 1. variable as ColumnNam…

  efioj

  6 replies

  11 years, 10 months ago

  By: corey lawson

• error 0x80040E21 "Multiple-step OLE DB operation generated errors...."

  I've used the Import / Export wizard to dump a tables from a SQL 2005 db to a series of Excel sheet…

  Mike Caddy

  15 replies

  11 years, 10 months ago

  By: khemu8290

• Identify current executing user in SSIS 2005

  Hi, How do we find in SSIS script task, that which account is currenty executing our package. Syste…

  shashant.kumar

  1 replies

  11 years, 10 months ago

  By: Koen Verbeeck

• File existance in folder

  Hi, Now i got a chance to work on SSIS. I am very beginner to SSIS. Could you please help me in the…

  Pulivarthi Sasidhar

  3 replies

  11 years, 10 months ago

  By: mail.seobd

• Check Files existence in a folder

  Hi All, how to implement the below req in SSIS: how to find out whether any file is present in the …

  marees.inspire

  15 replies

  11 years, 10 months ago

  By: mail.seobd

• Installing Integration Services on existing Active\Active Cluster

  I want to install Inegration Services on an existing sql 2005 active/active cluster. SSIS is curre…

  timscronin

  1 replies

  11 years, 10 months ago

  By: captain.norton

• The 'OraOLEDB.Oracle.1' provider is not registered on the local machine

  I have a SSIS (2005) package which was developed on a 32 bit machine. The Package connects to the o…

  Arcturus

  9 replies

  11 years, 10 months ago

  By: Koen Verbeeck

• how to share a folder with SSIS on remote server

  I've created a package to import an excel file into a SQL table then run a SP. The idea is then to …

  deeby

  2 replies

  11 years, 10 months ago

  By: deeby

• By Pass the send mail task exception

  I have a package created in SSIS 2008. Here i have used ForEachLoopContainer and in side this loop …

  Karan_W

  2 replies

  11 years, 10 months ago

  By: Tim Mitchell

• I need to create excel file using dynamic query in SSIS

  Hi, Is it posible to generate excel file with data using dynamic query in SSIS Package. Source quer…

  bhupesh.siwas

  5 replies

  11 years, 10 months ago

  By: tam-928946

• Trouble with Excel Data Source

  I am working on a project that based on the date I need to find a specified Excel file and import i…

  ehlinger

  19 replies

  11 years, 10 months ago

  By: aaron.reese