SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Flat File source - inconsistent data

  Hi, I have a flat file which I need to process via SSIS(Data Flow Task->Flat File source), but h…

  Paul Monaghan

  1 replies

  16 years ago

  By: Elliott Whitlow

• File was deleted without loading-FTP Task

  Hello I have a simple ssis package with the following 3 components 1. FTP Task1 ----> receives f…

  Ganesh Lohani

  1 replies

  16 years ago

  By: Jake Shelton

• Import e-mailed attachment into SQL Server

  Has anyone had any experience setting up an SSIS package (or other ETL mechanism) to automagically …

  Tim Mitchell

  5 replies

  16 years ago

  By: Tim Mitchell

• Export to access extremely slow

  Hi all, I'd appreciate very much if someone could answer my question bellow. I created an SSIS pack…

  afilipao20

  1 replies

  16 years ago

  By: COZYROC

• Execute T-SQL statement task with Execute Package Utility

  Hi, When I open my .dtsx file to run it fails. My only error message is "Task Execute T-SQL Stateme…

  MR_Nille

  3 replies

  16 years ago

  By: Elliott Whitlow

• Altering time values in text file

  Hi all, Firstly, this is a home project, so no rush on this, more of an interesting way for me to l…

  Jake Shelton

  5 replies

  16 years ago

  By: Koen Verbeeck

• SSIS : IF ELSE Task Handler

  Like if variable = 'AB' run Data flow task 1... I use Scirpt Task to set variable "NeedImport" valu…

  83873308

  3 replies

  16 years ago

  By: Elliott Whitlow

• Import Excel file with line feed characters

  I have an Excel source file that has some rows with a line feed carriage return in the Address1 col…

  Celita

  11 replies

  16 years ago

  By: lakshmi2np

• EXcel importing from Excel to database by using SSSI

  Last 1 week im facing issue in importing excel to database. Some recorsd shows as NULL in database…

  anu.varghese1

  1 replies

  16 years ago

  By: Koen Verbeeck

• SSIS Hanging indefinitely

  There is a SQL job which calls SSIS package. The job hangs indefinitely randomly on somedays. The S…

  chandana.joshi-1139158

  3 replies

  16 years ago

  By: lakshmi2np

• Ignoring Connection Errors in a Package with Multiple OLE DB Source

  I've got an SSIS package which have multiple OLE DB Sources in a Data Flow Task. When one of the so…

  j_torres

  2 replies

  16 years ago

  By: Marco

• Use of Variables with Execute SQL Task

  Hi All, I created a variable with name Scenario and datatype int. Now I mapped this variable in the…

  SatishAyyar

  6 replies

  16 years ago

  By: nick.mcdermaid

• Script Task to update table using Connection Manager connection

  All, I'm sure this is something pretty simple, but I've ran into a mental block (plus I'm pretty ne…

  AtTheLake

  3 replies

  16 years ago

  By: COZYROC

• Sort CSV with uneven columns

  I have an unusual requirement and am hoping somebody here can suggest something to take the pain ou…

  ohack

  7 replies

  16 years ago

  By: Ross McMicken

• Use temp table in package

  Hi all, Just curious, can I use a Execute SQL task to create a session temp table (#MyTable) and us…

  stricknyn

  2 replies

  16 years ago

  By: sabyasm