Integration Services

• Topics

  Started by

  Posts

  Last post

• Problems loading large (wide?) XLS/CSV files into Sql 2008

  Hi, (Sql 2008, SSIS 2008) customer has at least quite wide XLS's that should be loaded into db. I H…

  WilburSmith

  5 replies

  12 years, 1 months ago

  By: WilburSmith

• Understanding the "Full Result Set" of SSIS

  I have two questions about the result set generated by an execute SQL task - 1) What is the class …

  blasto_max

  3 replies

  12 years, 1 months ago

  By: blasto_max

• MySQL to MSSQL

  What is the best approach for extracting data from a MySQL Database and importing it into MSSQL? …

  dan-572483

  5 replies

  12 years, 1 months ago

  By: Gazareth

• Date change format in SSIS

  Hi I have a file i want to import into a database with the date format as: 20131113 When the date h…

  jman76

  1 replies

  12 years, 1 months ago

  By: jman76

• Import Issues - Excel

  I am sure this is somewhere on this forum, but I haven't been able to find the right combination of…

  swoozie

  1 replies

  12 years, 1 months ago

  By: Koen Verbeeck

• How to pick only those records from Oracle which are not present in SQL Server

  I am using SSIS to fetch records from Oracle into SQL Server 2012. This is the first time I am usin…

  frank_martinboy

  2 replies

  12 years, 1 months ago

  By: frank_martinboy

• Loading String Data from DB2 to SQL Server - dropping special characters

  Hi all, I'm loading data from a DB2 database into a table in SQL Server using SSIS. I'm using SQL …

  pmoseley

  1 replies

  12 years, 1 months ago

  By: Phil Parkin

• Handling strings methodology

  It appears to me that I have basically 3 different methods in handling strings that are of wrong le…

  Banana-823045

  3 replies

  12 years, 2 months ago

  By: Nevyn

• How to configure the directory and file mask for 'Foreach File Enumerator' in 'Package configurations...'?

  Hi, (Sql Server 2008 / VStudio 2008) it is easy to configure DB-connections - ServerName and Initia…

  WilburSmith

  4 replies

  12 years, 2 months ago

  By: WilburSmith

• Execute SQL Task: Executing the query ""CREATE TABLE " + @[User::FileName]

  Hi Experts I am trying to create table dynamically in destination as same as Source file name wit…

  selvakumar.sms

  1 replies

  12 years, 2 months ago

  By: Phil Parkin

• Import data from Excel to DB table

  Hi, I'm learning SSIS and as a part of my project here is one scenario: I've a folder location wher…

  sqlnaive

  7 replies

  12 years, 2 months ago

  By: sqlnaive

• expression for sql command in data flow task

  I have a data flow task with two OleDB connections, one for the source and one for the destination.…

  mz1derful

  2 replies

  12 years, 2 months ago

  By: mz1derful

• SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D

  I get the error below when I execute my SSIS (2008) package in BIDS 2008 - [Execute SQL Task] Error…

  blasto_max

  1 replies

  12 years, 2 months ago

  By: Honny

• SSIS - cannot connect to database after putting tasks in sequence container

  I had a package that worked perfectly until i decided to put some of its tasks inside a sequence co…

  blasto_max

  1 replies

  12 years, 2 months ago

  By: Honny

• Cannot read first column from Excel File

  Hi, I've been using SSIS for quite some tome reading Excel Files, and I just encountered an error I…

  raimse

  3 replies

  12 years, 2 months ago

  By: Honny