Integration Services

• Topics

  Started by

  Posts

  Last post

• Cannot extract DATE from SSIS 2008 OLEDB Source

  I am trying to simply extract data from sql server which supports DATE and dump it (without changes…

  blasto_max

  2 replies

  12 years ago

  By: blasto_max

• For Each File Logic

  A little new to SSIS, but i'm definitely a deep dive programmer. my question is more of a setup or …

  Lowell

  5 replies

  12 years ago

  By: Lowell

• Schedule SSIS Package

  I have an SSIS package which uses the Microsoft Connector (SAPBI Source) connected to BW. When I t…

  shannon.proctor

  7 replies

  12 years ago

  By: SQLBuddy123

• RetainSameConnection performance ?

  I am inserting millions of rows into a table with a package called ETL1. Takes about 30-50 minutes …

  blasto_max

  1 replies

  12 years ago

  By: Sushil Dwivedi

• Check Source for Data Prior to Truncation

  Is there a way to check the source to ensure data is available before truncating the data in the de…

  shannon.proctor

  6 replies

  12 years ago

  By: Lempster

• 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

  12 years 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

  12 years 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

  12 years 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

  12 years 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

  12 years 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

  12 years 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

  12 years 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

  12 years 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

  12 years 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

  12 years ago

  By: Phil Parkin