Integration Services

• Topics

  Started by

  Posts

  Last post

• SSIS MongoDB datasource with nested documents

  I recently started using MongoDB as a source in SSIS (using C# driver). I am very new with MongoDB …

  ichv

  4 replies

  9 years, 10 months ago

  By: ichv

• Script component - Oracle Connection

  Hello, i'm trying to connect to a oracle DB through a script component. My script looks like: #re…

  totto

  6 replies

  9 years, 10 months ago

  By: totto

• Schedule SSIS Package that place file to outside of Network Domain

  Hello I have one task where i need to source data from database server which is on XXX network doma…

  yogi123

  4 replies

  9 years, 10 months ago

  By: yogi123

• Updating ServerName in ADO.NET connection

  I inherited a SSIS package using SQL 2008 R2, that has several ADO.NET connections defined. The ori…

  Filipe

  2 replies

  9 years, 10 months ago

  By: Filipe

• Reading Excel column headers and their data into SQL

  I'm a relative novice with SSIS, but I'm trying to get my head around the best way to do this. I h…

  Maddave

  5 replies

  9 years, 10 months ago

  By: Phil Parkin

• Loading XML table that outputs multiple table

  I have an XML file that generates about 10 output tables when loaded into an XML source component. …

  TheComedian

  2 replies

  9 years, 10 months ago

  By: TheComedian

• Data conversion in SSIS

  I've to find difference between 2 excel columns in SSIS, The data type is DT_WSTR, so I tried conve…

  uzn2010

  6 replies

  9 years, 10 months ago

  By: uzn2010

• SQL Express 2012 - SSIS package

  Hello everyone, I've Windows 2012 R2 server with SQL Express 2012. I would like to setup a package …

  ankithimmatlalshah

  2 replies

  9 years, 10 months ago

  By: Shawn Melton

• SSIS service not starting

  Hi, SSIS service is starting as Local System but not starting using domain service account. SSIS is…

  sql_ques

  1 replies

  9 years, 10 months ago

  By: happycat59

• Executing SSIS package through SQL job

  Hi, I have a SSIS package with FTP task. When I run I got error Login is not allowed. So I changed …

  ramana3327

  5 replies

  9 years, 10 months ago

  By: Phil Parkin

• SSIS package does not progress when called from agent job

  I'm having issues with a package that contains a script step. This calls the Microsoft.Office.Inte…

  Jeff Shurak

  9 replies

  9 years, 10 months ago

  By: pnr8uk

• package opens up as xml file

  Hi I am quite new to SSIS and I am having the following problem. I want to open the ssis package lo…

  PearlJammer1

  7 replies

  9 years, 10 months ago

  By: YOUKHANIS.JAMES

• Conditional Split, add logic to a simple date split

  I have the conditional split shown below. It works well for now, but when the fiscal year changes i…

  alicesql

  4 replies

  9 years, 10 months ago

  By: alicesql

• SSIS - How to interpret the 0xC0047011 error message

  I have a data flow that has failed on a merge (left outer join) with : 15 0xC0047048 error codes 2 …

  adamfewtrell

  5 replies

  9 years, 10 months ago

  By: PB_BI

• SSIS Package executes successfully in dev/test environment but fails in production

  Hi, I have an ssis package that runs perfectly fine in test/dev environment but when deployed to pr…

  quasar_phoenicis

  6 replies

  9 years, 10 months ago

  By: celia.moreno