SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Issues in Lookup Transformation

  I want to get column values depending on column data type and can use that values to insert in dest…

  bhushan.bagul

  13 replies

  10 years, 9 months ago

  By: prabhu.st

• Data Conversion error after redirect row on OLEDB Destination

  Using SQL Server 2008 Integration Services. In the oledb destination I have set data access mode as…

  rs80

  2 replies

  10 years, 9 months ago

  By: simon.David.alex

• SSIS Expression Help

  Hi All, Here is my question. I have Source as an E.G ID,Fname,Qty 1,Gim,2 2,Kimmy,42 I want to cr…

  rocky_498

  6 replies

  10 years, 9 months ago

  By: Koen Verbeeck

• SSIS - Truncation Warnings

  I have created a package to import data into a table that has been created per a data dictionary. I…

  Dobbs77

  22 replies

  10 years, 10 months ago

  By: amit_adarsh

• Ugh. SSIS Connection Manager Woes!

  I'm new to SSIS. I'm new to using Windows Authentication vs SQL Server Authentication. Sorry, thi…

  autoexcrement

  4 replies

  10 years, 10 months ago

  By: autoexcrement

• SSIS Job Is Not Picking Up The New Package Changes

  I've developed a comprehensive series of packages using SSIS 2012. It's basically one main package…

  brad.mccollum

  4 replies

  10 years, 10 months ago

  By: brad.mccollum

• System SPID 17 blocks after SSIS Load

  I'm trying to wrap a TRUNCATE TABLE and a load of 14.7M rows in a single SSIS component. (I've alr…

  @SixStringSQL

  2 replies

  10 years, 10 months ago

  By: SQLRNNR

• InvestmentType == "Forward Cash"

  hi i have a tbale and after the table i want to put in a derived column that then pick just the dat…

  ronan.healy

  15 replies

  10 years, 10 months ago

  By: SQLRNNR

• date issue

  hi Im using the following code to arrange dates the way I want it here is the code (MONTH(MaturityD…

  ronan.healy

  16 replies

  10 years, 10 months ago

  By: Phil Parkin

• putting a value in for null

  i have rows in a field that are causing me a problem and I think its because its set to numeric and…

  ronan.healy

  6 replies

  10 years, 10 months ago

  By: ronan.healy

• Removing certain text from a column

  Hi i have been asked to do the following b.If Asset Type = ‘IRS’ or ‘IFS’ i.Remove any leading te…

  ronan.healy

  13 replies

  10 years, 10 months ago

  By: J Livingston SQL

• populating 1 column from 2 different columns

  hi i need to do this I.Filter records where Asset Type = ‘Future-Bond’ AND/OR ‘Future-InterestRate…

  ronan.healy

  1 replies

  10 years, 10 months ago

  By: Luis Cazares

• removing a comma

  hi im using the following code to remove a comma REPLACE([Counter Party Ref],", "," ") the value in…

  ronan.healy

  16 replies

  10 years, 10 months ago

  By: ronan.healy

• Importing Poorly Formatted Text File

  I am trying to import a text file to a SQL server table using SISS. I use SSIS but this is my first…

  marg 14154

  31 replies

  10 years, 10 months ago

  By: Jeff Moden

• SSIS Package to create Excel Spreadsheet fails in SQL Agent

  I wrote a SSIS script task where I use VB code to read data from a database using ODBC and then dy…

  charles tisch

  11 replies

  10 years, 10 months ago

  By: Suresh.Utham