SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• fuzzy lookup task

  I am working with fuzzy logic using SSIS. I created a base table and was using it as reference tabl…

  MuditGupta

  3 replies

  17 years ago

  By: MuditGupta

• if else in a expression

  Hey can you use and if else in a expression in a dervied column ?

  sql_Reporter

  1 replies

  17 years ago

  By: Michael Earl-395764

• SSIS Buffer Manager problem

  I'm developing and running a rather simple package in SSIS which imports data from a flat file, doe…

  Walter Tucholski

  9 replies

  17 years ago

  By: subhad

• data overflow error on flat file import to DB

  I am trying to import a text file into SQL Server DB I am getting the following error: [Flat File S…

  Mark F-428640

  4 replies

  17 years ago

  By: Carl Rimmer

• Foreach Loop threading

  I have a Foreach loop that is copying a set of large files to different destinations. I would rath…

  Chris Conner-455865

  7 replies

  17 years ago

  By: Tim Mitchell

• Changing SQL Task to Data Flow

  I haven't done much with the Data Flow. Let's say I inherit the following SQL task from DTS: select…

  Jason Crider

  4 replies

  17 years ago

  By: Jason Crider

• Truncation of data - but the file is ok?

  I have two similar SSIS jobs, one that runs on a daily basis, one on a monthly basis. Both are exa…

  niall.baird

  2 replies

  17 years ago

  By: niall.baird

• Derived Column Or Data Conversion ummm...

  Scenario: SQL 2005 SSIS package Flat file (CSV) FlatFile --> OLE DB Destination Problem: Within …

  A Little Help Please

  6 replies

  17 years ago

  By: Jay_Noob

• Foreach loop expression

  Hi i've about 10 files i get daily the file names are as follows xxx_20081202_A.txt xxx_20081202_B.…

  sql_Reporter

  2 replies

  17 years ago

  By: sql_Reporter

• Excel Source component seems to be dropping data

  I'm trying to read an Excel file using Excel Source component. In the file, I have certain columns …

  DoolinDalton

  2 replies

  17 years ago

  By: DoolinDalton

• Parellel Schedule Of SSIS package

  I have to load a data mart...for that I want to run my dimension table load parallel. So say for ex…

  agrawal_amit77

  2 replies

  17 years ago

  By: COZYROC

• redirecting (error) rows

  I am attempting to export records to a text file with three additional derived columns. I am getti…

  Mark F-428640

  6 replies

  17 years ago

  By: Mark F-428640

• SSIS package audit

  Hi All, I would like to know for some one the best way to do auditing in ssis package, I have given…

  sql_learner29

  2 replies

  17 years ago

  By: Michael Earl-395764

• How to avoid reading “.csv” files in use

  I have a SSIS package that reads all the “*.csv” files in a specific folder and dumps them to an ar…

  jude.pieries

  7 replies

  17 years ago

  By: Michael Earl-395764

• XML String Datatype default and max Length issue

  Afternoon, The XML Source Adapter in SSIS has made my life very easy when importing Data for a proj…

  Danb7183

  1 replies

  17 years ago

  By: Danb7183