SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Does an SSIS package have to be a SQL job to run?

  I have copied over a SSIS package from visual studio to SQL Studio Manager and shows up in SSIS ser…

  jsheldon

  9 replies

  17 years, 4 months ago

  By: jsheldon

• SSIS connection strings for non domain machines

  We have an SSIS package that im creating which connects to a sql server that isnt on the domain (19…

  Animal Magic

  7 replies

  17 years, 4 months ago

  By: Tommy Bollhofer

• Change Table name in Acess DB using SSIS

  hi, So here's the problem. I need a table from a access DB that our clients send us every month. …

  //Ravi

  3 replies

  17 years, 4 months ago

  By: Matt Miller (4)

• Configuring for multiple environments

  I'm a new user on a very small system, and all environments will run against the same database on t…

  born2bongo

  2 replies

  17 years, 4 months ago

  By: born2bongo

• DTEXEC with /SET on 64bit fails

  Hi, When I try to execute a SSIS Script package without any paramater in dtexec utility, it looks …

  deuba

  1 replies

  17 years, 4 months ago

  By: Frank Bazan

• Error code: 0x80040E4D. An OLE DB record is available....HELP NEEDED PLS

  Hello guys, i'm getting a weird error - I've 2 packages, the first one calls the other, both are pa…

  chjamesbuckner

  1 replies

  17 years, 4 months ago

  By: Jack Corbett

• 32 Bit SQL Server DTS Package To 64 Bit SQL Server 2005 SSIS Package

  Hi Techies I have the requirement to convert DTS packages(32 bit server) to SSIS packages(64 bit Se…

  nary

  3 replies

  17 years, 4 months ago

  By: Jay1234

• Passing variable value from Script Component(data flow) to script task(control flow)

  I am trying to pass a value from a script component to a script task. Basicall, how can I referenc…

  teekay-101299

  1 replies

  17 years, 4 months ago

  By: teekay-101299

• Update Query Using Different Connection Managers

  What was easy with DTS has me stumpped here. I need to run a simple Update query. The data comes …

  Eric Brockway

  2 replies

  17 years, 4 months ago

  By: Eric Brockway

• SSIS running on cluster w/2 SQL instances

  I’ve come across a couple of cases where the SSIS packages created by the developers could not been…

  chubbsm

  6 replies

  17 years, 4 months ago

  By: chubbsm

• Error in exporting text type data from SQL 2005 into Excel using Integration Services

  I'm trying to create a package tha exports from a SQL 2005 table to an Excel file. Everything is wo…

  shenimr

  3 replies

  17 years, 4 months ago

  By: p.van.kaam

• To find the latest file in a folder and use that file as the source for Data flow task

  Hi, The source of the Dataflow task should be the latest file from a folder. The folder would have …

  Alicia Rose

  3 replies

  17 years, 4 months ago

  By: Alicia Rose

• Looking for best practice to do an insert/update load from a flat file.

  I'm loading a group of tables each with up to 100 mil rows. I'm looking for the best layout for an…

  Kenneth.Fisher

  1 replies

  17 years, 4 months ago

  By: SQLdevotee

• Export to a textfile is revers the columns

  Hello. I have a problem with some some SISS packages that I have converted from DTS. Acually its on…

  Joel_sjoo

  2 replies

  17 years, 4 months ago

  By: Lookup_BI

• Looking for and renaming a file

  Posted - 02/27/2008 : 09:09:29 -------------------------------------------------------------------…

  iain-656842

  4 replies

  17 years, 4 months ago

  By: Lynn Pettis