Integration Services

• Topics

  Started by

  Posts

  Last post

• ETL SSIS project for AdventureWorks datawarehouse

  HI all, I'm re-searching data warehouse and using AdventureWorksDW2008R2 as data warehouse sample. …

  Dung Dinh

  2 replies

  13 years, 1 months ago

  By: Dung Dinh

• Add a column with a value from another source

  Hello there, i'm using SSIS 2012 . i have 2 sources ( xml files) in 1 data flow and from each sourc…

  avishain

  4 replies

  13 years, 1 months ago

  By: sqlbi.vvamsi

• Using Variables within a "SQL Command from variable"

  I have loaded a sql query into a variable and selected the "SQL Command from variable" option withi…

  kelley.rice

  2 replies

  13 years, 1 months ago

  By: sqlbi.vvamsi

• How to consume WCF service in SSIS with SQL Server 2005 SP2

  hello All, Can someone explain me how can u consume a WCF service in SSIS using sql server 2005, th…

  sqlpanther

  1 replies

  13 years, 1 months ago

  By: Orlando Colamatteo

• Max size in DataType Properties - Advanced Editor

  Hello there, ssis 2012. is there a way to make this column more than 4'000? the thing is, this fiel…

  avishain

  1 replies

  13 years, 1 months ago

  By: Orlando Colamatteo

• A small SSIS Package executing with errors.

  I am facing trouble while executing an SSIS(2008) Package which loading (90000 records) data from S…

  Rocky's

  1 replies

  13 years, 1 months ago

  By: Phil Parkin

• Combining BSIDS Visual Studio and C#...?

  Is there are way to include the C# development environment into BSIDS (Visual Studio)...?

  brickpack

  2 replies

  13 years, 1 months ago

  By: Koen Verbeeck

• Import and Export Wizard: Invalid Internet Address when importing Excel from a web page

  I'm running SQL Server 2008 R2 on a Windows 2008 R2 server. http:\\www.eia.gov\forecasts\steo\xls…

  Karen Grube

  6 replies

  13 years, 1 months ago

  By: Karen Grube

• Getting DTS_E_INDUCEDTRANSFORMFAILUREONERROR

  Hi, I am using SSIS 2008 and i have to push data from SQL Server 2008 to Excel 2003. In my package …

  Rocky's

  2 replies

  13 years, 1 months ago

  By: Rocky's

• what to do when package suspends when run as a job

  Hello, I'm working on a package that does these things: 1. moves a file on a network to a server on…

  cafescott

  11 replies

  13 years, 1 months ago

  By: Evil Kraig F

• ssis data type conversion of input column(454) is not supported

  I am using SSIS pkg to export data from one server to another but i get the error "ssis data type c…

  Tara-1044200

  1 replies

  13 years, 1 months ago

  By: Phil Parkin

• SSIS Mappings Files

  can SSIS XML mapping files be Coustomized? Has any one out there tried it.

  quillis131

  2 replies

  13 years, 1 months ago

  By: quillis131

• SSIS Newbie - importing excel data to SQL Server 2008 R2

  Hi all, wondering if someone could please assist? I need to import data from an Excel (.xls) spread…

  WWDMark

  6 replies

  13 years, 1 months ago

  By: WWDMark

• SSRS Report Server destination

  Is it possible to use the Reporting Services Report server as a SSIS destination? In the SSRS Repor…

  ss_nl

  4 replies

  13 years, 1 months ago

  By: ss_nl

• Speed up simple SSIS load

  Hi I just published a new post on SQL Server Central SSIS 6 Million rows in 60 seconds using stand…

  KatieAndEmil

  1 replies

  13 years, 1 months ago

  By: KatieAndEmil