SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Data Types for Flat File import

  Hi, I am trying to create an SSIS package for importing our mobile phone bill from a CSV file. Mos…

  zuma01

  2 replies

  16 years, 2 months ago

  By: Jeff Moden

• Flatfile as a Lookup in SSIS

  is it possible to use flat file as a lookup file.?

  bpradeep

  3 replies

  16 years, 2 months ago

  By: COZYROC

• SSIS and ODBC account in IBM Universe

  Hi guys, I have an ODBC account setup in an IBM Universe database. I need to be able to pull data o…

  Geoffrey Doebler

  1 replies

  16 years, 2 months ago

  By: COZYROC

• DTS Package(Sql 2000) : Can I have source as SQL 2000 Datababse and Destionation as SQL 2005 Database

  Hi all, I've a DTS package which copies the data from QA to Production database. The production dat…

  srikanthr319

  2 replies

  16 years, 2 months ago

  By: SQLRNNR

• Error when I attempt to create new SSIS project and add new package to it

  While trying to create a new SSIS project in BIDS 2008 I get the following error: Failed to save p…

  Marios Philippopoulos

  3 replies

  16 years, 2 months ago

  By: Marios Philippopoulos

• How to read only particular fields from flat file into the database in ssis

  Hi, I have one flat file having number of columns(45) in that i have to filter the columns i.e, 10 …

  jagadeeshb

  1 replies

  16 years, 2 months ago

  By: Phil Parkin

• How to change default string length on import wizard

  Does anyone know how to change the default string length on the import data wizard please? The defa…

  Balance

  1 replies

  16 years, 2 months ago

  By: Balance

• Problem with Script task and FTP GetListing

  Hi I'm struggling with a Script Task to FTP receive files. I my script I want to determine if a spe…

  bu007

  2 replies

  16 years, 2 months ago

  By: bu007

• Need to import from sybase nto SQL Server, any driver I need to install?

  :hehe: :w00t: Hello to all wherever you might be!!! This is the case, I need to import some data fr…

  Fernando-235287

  1 replies

  16 years, 2 months ago

  By: SQLRNNR

• Create a field in the query that computes the difference between the maximum and current on hands, name this field “reorder_qty”

  I have a query on a single table and want to add a single column to the end with a calculation subt…

  grasspicker61

  2 replies

  16 years, 2 months ago

  By: SQLRNNR

• The Profiling Task gets stuck

  Hi: I'm trying to assess the data inside a SQL Server 2005 database. I'm using the profiling task o…

  Paul Hernández

  1 replies

  16 years, 2 months ago

  By: COZYROC

• Transfer Database task fails...but with no error description

  Error: The Execute method on the task returned error code 0x80131500 (Detach database failed for Se…

  Shark Energy

  1 replies

  16 years, 2 months ago

  By: Shark Energy

• Create file with all field names but export only certain fileds

  Hey all. In sql 2000 I had a dts package that output all the field names in a table to a file but i…

  d perry

  1 replies

  16 years, 2 months ago

  By: sabyasm

• Transfer SQL Server Objects Task

  Hi. I'm having trouble running the package. There is a table that is off the transfer list, but he …

  patricio.molina

  2 replies

  16 years, 2 months ago

  By: Bru Medishetty

• datecoloumn in ssis

  Hi All, i have a date coloumn in excel & format is dd/mm/yyyy but data in some rows as dd/m/y…

  syamala.p

  2 replies

  16 years, 2 months ago

  By: sabyasm