SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Proxy can't see a file on network but appears to have permissions

  I have a package that reads a file from a Network share, when I run it (the package through a SQL A…

  GRE (Gethyn Ellis)

  2 replies

  15 years, 3 months ago

  By: GRE (Gethyn Ellis)

• Application popup error when invoking .exe from ETL package

  I have a Job with only one step. That step invoke an ETL package (in the same SQL server). The ETL …

  rdevitta

  5 replies

  15 years, 3 months ago

  By: rdevitta

• How to Pass a List of DatabaseNames to the "Backup Database" Task

  Hi, I try to Backup Specific Databases with the DatabaseBackup Task. I thought i pass a List of Dat…

  ghostsgrafix

  8 replies

  15 years, 3 months ago

  By: Alvin Ramard

• Limitations of Lookup Transformation

  Hi All, I was asked by an interviewer about the lookup. 1. How many max number of rows the lookup …

  tinku.reddy

  1 replies

  15 years, 3 months ago

  By: Koen Verbeeck

• SSIS config file with multiple connections

  Hi, I need to store multiple connection string in one configuration file, and from a single package…

  JDBA-eqms

  1 replies

  15 years, 3 months ago

  By: Ed Zann

• Truncation on input

  Truncation may occur due to retrieving data from database column "XXXXX" with a length of 50 to dat…

  TangoVictor

  3 replies

  15 years, 3 months ago

  By: TangoVictor

• Blank row (row no2) in preformatted excel destination

  Hi, When i use a preformated excel sheet as destination in data flow task, When a export is done a …

  h_zulfi

  2 replies

  15 years, 3 months ago

  By: marcoscavaleiro

• Import data from multiple excel worksheets through SSIS

  Hi, I want to import data from multiple excel worksheets through SSIS to a SQL Server table. Any h…

  PSB

  12 replies

  15 years, 3 months ago

  By: PSB

• Memory leak in SSIS package

  This post was originally started in the SQL 2005 Administration forum under high CPU usage. http://…

  TangoVictor

  6 replies

  15 years, 3 months ago

  By: Michelle-138172

• Script task fails, makes Job fail

  Hi I have a package in witch I use a script task. Inside the script task I fail or succeed the Dts.…

  Rowan-283474

  2 replies

  15 years, 3 months ago

  By: Rowan-283474

• For Each FTP Connection string

  I am trying to loop through FTP sites and extract files, the problem I have is that the connection …

  Naughtycell

  3 replies

  15 years, 3 months ago

  By: Naughtycell

• SSIS/DTS Data loss due to implicit casting(?)

  Since the days of SQL 7 DTS, there has been a problem with certain kinds of data imports where it s…

  notarian@gmail.com

  11 replies

  15 years, 4 months ago

  By: Koen Verbeeck

• Best way to design this package

  We have a mirroring product (third party) that keeps a database up to date, and logs in a table whe…

  Shark Energy

  5 replies

  15 years, 4 months ago

  By: Shark Energy

• Running SSIS through SQL Server Agent

  Hi, When I run a package in BIDS, one of the task (Execute Process task) will ask for user name and…

  SatishAyyar

  1 replies

  15 years, 4 months ago

  By: sql_learner29

• Executing SSIS package through Stored procedure

  I am trying to execute a package through a stored proc passing a parameter...I have a variable in t…

  SqlSavvy

  3 replies

  15 years, 4 months ago

  By: SqlSavvy