SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Dynamic file names

  Hello All, Iam trying to retrieve the previous day file placed in FTP location. Iam using the expre…

  kk.86manu

  1 replies

  13 years, 3 months ago

  By: kl25

• one Config File for Multiple dtsx files

  Hi, My SSIS project is having 12 dtsx files and all variables(ConnectionString, LandindDir…

  M@n!

  10 replies

  13 years, 3 months ago

  By: Elliott Whitlow

• Need help replicating an algorithm in TSQL Table?

  Hi - Below is an algorithm used in excel for converting an alpha numeric code into a number. Need h…

  subahan_syed

  7 replies

  13 years, 3 months ago

  By: subahan_syed

• Modify the argument sent to a process task

  hi guys, I am writing to a text log file using Process Task which calls an msdos .bat file. The .…

  aaron.reese

  10 replies

  13 years, 3 months ago

  By: drew.allen

• Scheduling JOB for SSIS Package

  Hi I have an SSIS Package which is running fine. I need to schedule this package in MS SQL Server 2…

  RV-813525

  11 replies

  13 years, 3 months ago

  By: JohnG69

• How do you write to Teradata in SSIS?

  I read from Teradata for many SSIS projects. Now I have the need to write to it. I'm reading from D…

  mbmalm

  9 replies

  13 years, 3 months ago

  By: Koen Verbeeck

• Educational question

  Hi all, I have been learning SSIS recently and getting some hands-on practice, I have a scenario be…

  Jake Shelton

  6 replies

  13 years, 3 months ago

  By: Koen Verbeeck

• Issue importing xlsx or xls; sheets greater than 255 columns in size.

  Hi All, I have encountered an issue when using the OPENROWSET to import xlsx files using the follow…

  guyb 35072

  8 replies

  13 years, 3 months ago

  By: guyb 35072

• .xlsx connection error: External table is not in the expected format

  When I create my connection manager to connect to a .xlsx file, I get the error message that says: …

  amy.walsh

  6 replies

  13 years, 3 months ago

  By: COZYROC

• SSIS Job only runs on one node

  We have an active/passive cluster at a client site. SSIS installed on both nodes, packages are par…

  timscronin

  10 replies

  13 years, 3 months ago

  By: Elliott Whitlow

• Maintenance plan is failed with the error:

  Job NameMaintenancePlan_Monthly.Subplan_1 Step NameSubplan_1 Duration00:00:00 Sql Severity0…

  jyoti.patel

  1 replies

  13 years, 3 months ago

  By: Koen Verbeeck

• recorset and loop foreach SSIS

  Hy i am trying to use SSIS recordset in a for each loop with some variables. i am using a recordset…

  finaly_sav

  6 replies

  13 years, 3 months ago

  By: finaly_sav

• SQL server Architecture

  HI, I am new to sql server i need to get good knowledge in sql server.pls someone guide me.

  tejdeep5107

  2 replies

  13 years, 3 months ago

  By: sengeet86

• Error on conditional operator in derived column task

  I am creating a dervied column with expression as len(diag)>3?stuff(diag,4,0,'.'):diag diag=col…

  reach.tharan

  1 replies

  13 years, 3 months ago

  By: Daniel Bowlin

• Redirect Rows on Lookup Failure - But Still Fail

  I'm working on some expense report automation. In the process of handling expense reports, I need …

  jvanderberg

  3 replies

  13 years, 3 months ago

  By: Matt Miller (4)