SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Microsoft.Office.Interop.Excel on server

  Good day, I got the srcipt working on my Local PC. But when importing on to server, i get the erro…

  ismail casper

  15 replies

  15 years, 10 months ago

  By: Somanna

• Flat File Connection Manager Prob

  Hi im trying to import a couple of text files from different sources but with the same error...the …

  a_r_baines

  3 replies

  15 years, 10 months ago

  By: Phil Parkin

• Creating a dynamic directory

  Hi, I want to create a directory everyday,name should be current date like '17022010'.Is it possibl…

  elchuru

  3 replies

  15 years, 10 months ago

  By: elchuru

• How do you eliminate quotes from being uploaded from a flat file to SQL Server with Integration Services?

  How do you eliminate quotes from being uploaded from a flat file to SQL Server with Integration Ser…

  Arjun SreeVastsva

  2 replies

  15 years, 10 months ago

  By: Phil Parkin

• how to setup a checkpoint file in SSIS?

  how to setup a checkpoint file in SSIS?

  Arjun SreeVastsva

  1 replies

  15 years, 10 months ago

  By: Paul White

• Restore Invalid Column Reference

  I have ONE Excel file that contains TWO worksheets. I have EXCEL datasources to each. I then put e…

  rew-370421

  1 replies

  15 years, 10 months ago

  By: rew-370421

• If-Then-Else

  I have a DERIVED COLUMN TRANSFORMATION as follows: Converted_My_VALUE > 0 ? "X" : "Y" Why doesn'…

  rew-370421

  4 replies

  15 years, 10 months ago

  By: Phil Parkin

• Using datepart as Precendence Constraint

  I would like to use a precendence constraint with a DATEPART expression to determine which stored p…

  lduvall

  3 replies

  15 years, 10 months ago

  By: lduvall

• Calliing Web Service in Script Component

  I am trying to calling a web service in using script component but getting Error 30002: Type 'Micro…

  Anoop Saxena

  6 replies

  15 years, 10 months ago

  By: Brian Daul

• Creating Fixed Width Flat file with Header and Detail records

  Hi Guys, I am working on financial project. I got a req for creating FIXED Width (1219 Bytes) file …

  Sang.Ind

  1 replies

  15 years, 10 months ago

  By: jbuttery

• Using Variable

  I have a job that Imports EXCEL data into a Database Table. I also need to update ONE more Database…

  rew-370421

  6 replies

  15 years, 10 months ago

  By: rew-370421

• Export Data to XML Format

  There are 5 steps to it: Step 1: Click on the External Data Ribbon, then choose Export More XML Fil…

  bijayanix24

  1 replies

  15 years, 10 months ago

  By: StarNamer

• Saving a DTS package always creates new version?

  How do I know which version of a DTS package is running on my server when it contains several versi…

  Ray Cacciatore

  3 replies

  15 years, 10 months ago

  By: Greg Charles

• Substring function

  Hi, How to read left 10 characters from a column (nvarchar(50)) in SSIS. This is not working Row.C…

  VG-619426

  5 replies

  15 years, 10 months ago

  By: Phil Parkin

• SISS Package hangs up in SQL Server Agent

  I built a VB Script to open an Access data base and import CSV files. The package Script task has …

  Steven.g.karpowicz

  5 replies

  15 years, 10 months ago

  By: steveb.