Integration Services

• Topics

  Started by

  Posts

  Last post

• Teradata destination ODBC connections failing in SSIS job

  Windows Server 2012 R2 SQL Server Integration Services 2012 Teradata 13.10.00.14, Driver 14.10.00.0…

  gopeep

  2 replies

  10 years, 12 months ago

  By: gopeep

• Generate package-wide GUID variable

  Hi All, I'm a bit of an SSIS noob and I'm hoping to get some help. I'm using BIDS 2005. I need to g…

  Xedni

  2 replies

  10 years, 12 months ago

  By: Xedni

• Keep window open from Execute Process Task?

  Question: I am using the Execute Process Task in SSIS to run PuTTY's PSFTP tool. Then in the argum…

  Sector7G

  1 replies

  11 years ago

  By: Martin Schoombee

• Unicode string[DT_WSTR] to numeric[DT_NUMERIC] results in 0

  Hi, I have a Derived Column that transfers a 'number' in a unicode string[DT_WSTR] data type to a D…

  Marcus Farrugia

  3 replies

  11 years ago

  By: Marcus Farrugia

• Connecction manager error while executing package from SQL Server agent Job

  I have created a package using Odata source as connection manager.I ran well in SSDT.I am trying to…

  Priya004

  2 replies

  11 years ago

  By: SQL.AP

• Help in script task

  Hi, I have an SSIS package with file system task. That package has script task. It will check in th…

  ramana3327

  2 replies

  11 years ago

  By: Jeff Moden

• Export Fixed Width

  Hello I am exporting a fixed width text file and it works fine until the end users try importing it…

  Keejli69

  3 replies

  11 years ago

  By: Jeff Moden

• File System Task Problems

  Can anybody recommend a decent article about Dynamic File System tasks in SSIS. I've followed the …

  Neil Burton

  2 replies

  11 years ago

  By: Neil Burton

• Need suggestion to process more than 100,000 number of XML Files in SSIS

  Hi, I need suggestion to process more than 100,000 number of XML Files in SSIS. Each XML file conta…

  Raj_11

  8 replies

  11 years ago

  By: Raj_11

• SSIS connecting to oracle on another machine

  Hi, For last two days I’m trying to build a package to transfer data from Oracle DB to SQL Server a…

  Emil B

  8 replies

  11 years ago

  By: Emil B

• downgrade package

  Is there a way of opening a project created VS2014 in VS2013? Thanks

  d.carpenter

  6 replies

  11 years ago

  By: d.carpenter

• Dynamic Data Flow vs Dynamic Select * into to move fact tables.

  Hi, I am looking at a way to move data using dynamic data flow. We are moving table between databa…

  Rem70Rem

  1 replies

  11 years ago

  By: Koen Verbeeck

• while reading from xls data is truncated/errors off

  Hi, When mapping the xls with data source (keeping in mind that the xls picks top 8 rows to decide …

  namrata.dhanawade-1143388

  1 replies

  11 years ago

  By: Ronnie Rahman

• How to Fill-In A Single Cell in an Excel Spreadsheet Via SSIS?

  I have an SSIS pkg. that copies an existing Excel spreadsheet template to numerous new folders and …

  brad.mccollum

  2 replies

  11 years ago

  By: Jeff Moden

• OLE DB Excel Destination: How To Skip First 2 Rows in Spreadsheet for Imported Data

  I have a SSIS pkg. that runs a query against records in a SQL Server database, many times over in a…

  brad.mccollum

  2 replies

  11 years ago

  By: brad.mccollum