Integration Services

• Topics

  Started by

  Posts

  Last post

• Help with reading files in subfolders

  Hi,I am having mutiple subfolders in a folder .Each subfolder contains multiple files.I have to rea…

  sunil88_pal88

  7 replies

  9 years ago

  By: Phil Parkin

• Simple SSIS failed with The value could not be converted because of a potential loss of data.

  I have a very simple SSIS:1. Source: 5 columns, all in string(50)2. Key two columns: Period, Val3. …

  halifaxdal

  11 replies

  9 years ago

  By: MMartin1

• Is there a way to extract SharePoint lists using one generic SSIS package?

  I need to import multiple SharePoint lists data to SQL (one for each table). Rather than use SSIS a…

  sqlbaby2

  1 replies

  9 years ago

  By: Sue_H

• How to create a Package XML Configuration file?

  Hello, I want to export data from SQL to Excel, but when I in Data Flow add OLE DB command for my l…

  jirakst

  3 replies

  9 years ago

  By: John Mitchell-245523

• Strange Issue with SSIS package - Flat file source does not show the FIRST ROW in preview mode

  Dear all, I have currently facing a strange issue with one of the SSIS packages I am working with. …

  joydeep.sen157

  5 replies

  9 years ago

  By: joydeep.sen157

• VS15 Community Won't Display Content of a Package

  Hello,I'm using Visual Studio 2015 Community, with SSDT 4, and Attunity 4 for Teradata drivers. I i…

  quinn.jay

  1 replies

  9 years ago

  By: quinn.jay

• Switch 32bit to 64Bit MSTERA ODBC Driver -- MS for Teradata by Attunity

  FYI - I posted this to Connecting as well, but thought it was also a SSIS type question as well....…

  quinn.jay

  1 replies

  9 years ago

  By: quinn.jay

• How To Calculate The Execution Duration of an SSIS Package

  Good Afternoon Guys, I am currently having an issue calculating the execution time of a package ins…

  Stylez

  2 replies

  9 years ago

  By: Luis Cazares

• SSIS 2012 How to change/Alter Project's/packages/ environment Variable? (Automation process)

  Hi, I want to change/alter the file path variables, i.e. Incoming,download and archive for a given/…

  krishnaprasad14

  1 replies

  9 years ago

  By: tim.ffitch 25252

• SSIS Agent Job Passing Parameters

  I'm trying to set up a SQL Agent job to run a SSIS package. I want to pass a parameter to the packa…

  Glynne Smith

  18 replies

  9 years ago

  By: John Mitchell-245523

• SSIS Flat File Output - Is it possible to password protect / encrypt a file?

  Hi all, I have an SSIS package that outputs a .csv file to a folder on an internal file share …

  lindsayscott23

  1 replies

  9 years ago

  By: Phil Parkin

• How to script out SSIS catalog permissions?

  My goal is to synchronize permissions between two environments. So, I have staple scripts to genera…

  Eric M Russell

  3 replies

  9 years ago

  By: Eric M Russell

• Date conversion Error in SSIS package

  I have Data flow task where from source I have a date column called datatype date IN the destinatio…

  mcfarlandparkway

  1 replies

  9 years ago

  By: contact_arc

• Sample ETL mapping Design document

  Hi, I am developing ETL's using SSIS (Microsoft SQL Server Integration Services Designer Version 11…

  sqlquery29

  2 replies

  9 years ago

  By: Sue_H

• SSIS 2016 Project Slow to Open and Design

  I am having an issue with my SSIS 2016 Package in VSTS 2105. I have four packages in a solution and…

  michael.french 172

  2 replies

  9 years ago

  By: michael.french 172