SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Failed to lock variable error

  Hi All, I created a SSIS package to check whether the file exists in my local path.File name change…

  kk.86manu

  2 replies

  13 years, 6 months ago

  By: Koen Verbeeck

• SSIS Lookup Clear Cache

  I have a Data Flow Task that caches dimension tables using the cache connection manager and the nex…

  jaiki987

  2 replies

  13 years, 6 months ago

  By: Koen Verbeeck

• Locking tables with SSIS AND/OR SQL Server

  Hey all, I have an SSIS script which looks at a series of tables, and checks to see if they are up …

  kramaswamy

  4 replies

  13 years, 6 months ago

  By: patrickmcginnis59

• large dataset, standard ingestion scheme (merge join, condisplit...), best practice?

  I've got a table with 40MM records. I've got an incoming data set (~_stage) with about the same # …

  Greg J

  6 replies

  13 years, 6 months ago

  By: Koen Verbeeck

• Call multiple ssis packages and execute them from master ssis package

  Hello I have few SSIS packages located in some folder. They should execute in certain oder one by…

  dallas13

  6 replies

  13 years, 6 months ago

  By: Elliott Whitlow

• Continue on Failure

  Hello all, I have a question, which hopefully won't require too much time from the person that know…

  Paul_Harvey

  6 replies

  13 years, 6 months ago

  By: Phil Parkin

• Email Query Results Using SSIS

  Using SSIS and the Send Mail Task, I would like send a text e-mail. The body of the e-mail needs t…

  Always Learning

  3 replies

  13 years, 6 months ago

  By: SQlLogic

• Convert XML to CSV, then load to DB or Load XML to DB

  Hi, Does anyone know how this can be accomplished by ssis? I need to load an XML file to DB. I can …

  ankita.patel01 81294

  3 replies

  13 years, 6 months ago

  By: Phil Parkin

• Use script task to dynamically get Excel file as source file connection

  I'm designing an SSIS package to load an Excel file in a folder each week to sql server. Every week…

  Jenny Zhou-459989

  53 replies

  13 years, 6 months ago

  By: Phil Parkin

• To read dynamically changing file names using FTP task

  Hi All, I used a FTP task to read a text file from a FTP destination and i was able to successfully…

  kk.86manu

  1 replies

  13 years, 6 months ago

  By: Koen Verbeeck

• SSIS Flat File Processing Help

  Please i need help in creating an ssis package to read multiple files in a Directory ex: 1. I need …

  darkman2020

  14 replies

  13 years, 6 months ago

  By: jampa.sb

• Using non typable ASCII characters as delimiters for a flat file connection

  Hello everyone, Can we use non typable ASCII characters as delimiters for a flat file connection ma…

  venus.pvr

  7 replies

  13 years, 6 months ago

  By: Phil Parkin

• Error: The task "script task" cannot run on this edition of Integration Services.

  We are running SQL 2005 Standard Edition 64bit in our lab and are getting this error: Error: The ta…

  Ryan-209402

  19 replies

  13 years, 6 months ago

  By: juanja01

• DataReader Error, NullReferenceException

  Hi All, Got a bit of an odd problem. I have a data flow task which is taking an ADO.NET datasource,…

  kramaswamy

  1 replies

  13 years, 6 months ago

  By: kramaswamy

• Dynamic Data Flow Task with different source/destination tables?

  I'm guessing the answer is no, but I figure I'd ask anyway: I have several tables for which the pro…

  kramaswamy

  6 replies

  13 years, 6 months ago

  By: COZYROC