Integration Services

• Topics

  Started by

  Posts

  Last post

• Executing through XP_cmdshell

  Hi Friends , I am just trying to run the package using this T_SQL command line " exec xp_cmdsh…

  Charmer

  1 replies

  13 years, 10 months ago

  By: Elliott Whitlow

• Dynamic expression in Text file Connection works when executed alone, but not when executed with package

  I have a Foreach Loop Container that grabs today's system generated text file from a shared locatio…

  m2griffiths

  1 replies

  13 years, 10 months ago

  By: m2griffiths

• replace blank values with null

  I'm importing data from flat text file to sql db. There is some blank values in gender column in th…

  sqlfriend

  5 replies

  13 years, 10 months ago

  By: cbianchi

• OLE DB command error;the OLE DB adapter cannot convert between types "DB_CY and "DT_TIMESTAMP".

  i get this error when using the OLE DB Command it says it says "the OLE DB adapter cannot convert b…

  klineandking

  1 replies

  13 years, 10 months ago

  By: rgtft

• How to filter a extremely large table using a result set as filter?

  Hi. Please help.... Scenario: SSIS gets a table filtered by date from Server A. The result is writt…

  MrAkki

  10 replies

  13 years, 10 months ago

  By: sam.dahl

• Reading File's Path from a Variable.

  Please assist me in the following issue. I have a package that I have deployed on a remote server. …

  falcon00

  7 replies

  13 years, 11 months ago

  By: Koen Verbeeck

• ssis import from flat file , need also a column from a sql table

  I have a ssis package, in it I first import data from a flat file source, then convert some columns…

  sqlfriend

  4 replies

  13 years, 11 months ago

  By: sqlfriend

• Export to SSIS and maintain Drop down

  Hello All, In this i have two task to be done. I have to export data from a excel 2007 to Table…

  praneshram

  2 replies

  13 years, 11 months ago

  By: praneshram

• Export to SSIS and maintain Drop down

  Hello All, In this i have two task to be done. I have to export data from a excel 2007 to Table…

  praneshram

  1 replies

  13 years, 11 months ago

  By: SQLRNNR

• How to split the Records?

  Hi Friends , i have column name CrossStreets in an excel sheet which will be having datas like "W M…

  Charmer

  6 replies

  13 years, 11 months ago

  By: Charmer

• Convert stored proc to ssis

  I have to convert a stored procedure into ssis package.Procedure calculates and do transformation f…

  gkmsbi

  1 replies

  13 years, 11 months ago

  By: Koen Verbeeck

• testing for (and counting) presence of a date

  Hi All Relative newbie to SSIS so forgive me if this is a simple one I am trying to test and count …

  esoxhntr

  3 replies

  13 years, 11 months ago

  By: esoxhntr

• CSV dynamically to SQl tables SSIS

  Hi, Please excuse me, but I don’t normally work with SSIS, I see my question has been asked before …

  Edward-445599

  1 replies

  13 years, 11 months ago

  By: Revenant

• char index in substring

  Hi while I am running this query select substring(cnsmr_accnt.cnsmr_accnt_crdtr_rfrnc_id_txt,1,char…

  MrReddy

  4 replies

  13 years, 11 months ago

  By: stevefromOZ

• Connection String Problem

  I have a problem populating a connection string properly. Let me start at the beginning. 1. I hav…

  imani_technology

  2 replies

  13 years, 11 months ago

  By: Elliott Whitlow