Integration Services

• Topics

  Started by

  Posts

  Last post

• 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 months ago

  By: Honny

• Insert performance in SSIS

  Hi all, I was reading up on this article: http://www.sqlservercentral.com/articles/Integration+Serv…

  .Patrick

  1 replies

  12 years, 4 months ago

  By: Phil Parkin

• TFS 2010 - SSIS 2012 Catalog - How do you deploy/sync?

  Setup: VS2010 (Team Explorer Add-In) TFS 2010 SQL 2012 (using SSIS Catalog for package storage/depl…

  derekredmon

  1 replies

  12 years, 4 months ago

  By: Nevyn

• How to make a transaction in my case ?

  Let a person be defined by PersonID, a number. In my SSIS package, for each person, I first load s…

  blasto_max

  1 replies

  12 years, 4 months ago

  By: blasto_max

• SSIS - simple way to get number of rows in result set

  My execute sql task returns a "full result set" which I store in an Object objResults. I want a sim…

  blasto_max

  1 replies

  12 years, 4 months ago

  By: derekredmon

• SSIS Package with variables for Multiple Excel files

  I've a simple SSIS package with a ScriptTask and SendEmailTask. ScriptTask is used to simply OPEN a…

  sql1411

  1 replies

  12 years, 4 months ago

  By: derekredmon

• SSIS - Remove unused variables and such from SSIS ?

  How do you remove things like unused variables from SSIS ? I am using 2008.

  blasto_max

  3 replies

  12 years, 4 months ago

  By: derekredmon

• Connection string issue for sql authentication

  Can anyone pls help me with this issue I have the below connection string in my config file but wh…

  ushacheb

  3 replies

  12 years, 4 months ago

  By: Lowell

• How does SSIS store and access a SQL result set ?

  My code stores a huge result set. It processes this result set and then loads it to the target. Let…

  blasto_max

  2 replies

  12 years, 4 months ago

  By: sqlmunkee

• Import Excel to Sql table

  Can anyone help me on this. what is the easiest way to do this? I used a excel source and oledbdest…

  scuby.me

  4 replies

  12 years, 4 months ago

  By: Honny