Integration Services

• Topics

  Started by

  Posts

  Last post

• ssis package from one sytsem to another

  hi i created on e simple ssis package i used xml configuration and deployed it now i moved the depl…

  super48

  11 replies

  11 years, 10 months ago

  By: super48

• Get SqlDataReader instead of RecordSet in Execute SQL task

  I can store my SQL result set into a ADODB record set or ADO.NET recordset. In .NET I can use a .NE…

  blasto_max

  1 replies

  11 years, 10 months ago

  By: EricEyster

• Preprocessing Flat Files

  Question for you guys - what have you found as the best way to preprocess flat txt files to prepare…

  Gabriel P

  2 replies

  11 years, 10 months ago

  By: Gosta Munktell

• SSIS Package to insert records only if they dont exist in the table and send the list of new records in an email

  Hi everyone if possible , can I create a package to send an email that will only show the new recor…

  compufreak

  8 replies

  11 years, 10 months ago

  By: Sushil Dwivedi

• SSIS PACKAGE SHOWING CONNECTION ERROR BUT THE TASK IS SUCESSFULLY GETTING COMPLETED

  Hi Actually I am Moving data from One server1 To Another Server2 I create a package and it is runni…

  super48

  3 replies

  11 years, 10 months ago

  By: Koen Verbeeck

• Run the Package if file aviliable

  Hi, I need help on below scenario. My source is flat file. I am pulling all data from this file int…

  abhas

  10 replies

  11 years, 10 months ago

  By: Luis Cazares

• Pulling data from Progress 10.2B into SQL2012

  Hey guys, I have a 'situation' which I am hoping someone can help me with. I need to get data from …

  aaron.reese

  5 replies

  11 years, 11 months ago

  By: aaron.reese

• SSIS 2012 / mixed SQL Server 2008R2 and 2012 / stored procs which use #temp tables

  Apologies in advance for the longish post… We have the following environment: 1)SSIS 2012 2)Mixed…

  Phil Parkin

  10 replies

  11 years, 11 months ago

  By: spencer.young

• Map solution configuration to specific dtsConfig file

  Hello Can anyone advice me how to use different config xml files for different solution configurati…

  ab.itconsult

  1 replies

  11 years, 11 months ago

  By: Vikash Kumar Singh

• SSIS Dynamic Conditional Split

  Hi all, I've been looking for the last couple of days, but have been unable to find a solution. Sit…

  Dave R (UK)

  9 replies

  11 years, 11 months ago

  By: Phil Parkin

• SSIS Newbie Here With Question

  Hello - i am tasked to build a ssis package that: 1. Grabs Data 2. Export it to Flat file 3. Ftp My…

  Keejli69

  10 replies

  11 years, 11 months ago

  By: Keejli69

• Why does SSIS take so long to "build" before running?

  I have a ETL project that has about 15 packages in it, each package loads data into a SQL Server vi…

  MyDoggieJessie

  9 replies

  11 years, 11 months ago

  By: Paul Hernández

• SSIS-Track Execution Time of a Data Flow Task

  Hi Everyone, I have this requirement,can any one give me an idea on how to implement this I have a …

  avinash.818

  8 replies

  11 years, 11 months ago

  By: larskandersen

• Splitting single comma separated line

  Hi All, My source file is coma separated file having 6 columns. But some times two lines are mergin…

  abhas

  7 replies

  11 years, 11 months ago

  By: Vikash Kumar Singh

• ssis working with existing package

  I have an SSIS package that I would like to open and see what it contains. I have never used an SSI…

  wendy elizabeth

  3 replies

  11 years, 11 months ago

  By: Evil Kraig F