Integration Services

• Topics

  Started by

  Posts

  Last post

• SSIS Lookup-Is this the best option?

  I am trying to make a change to my ssis data flow. The reality is that I'm stuck. My data flow prob…

  mbrady5

  6 replies

  13 years ago

  By: mbrady5

• SSIS Wizard vs Manual

  I am new to SSIS , new to the forum too 😀 . I have been reading books and reading online for the pa…

  SqlServerNinja

  1 replies

  13 years ago

  By: Phil Parkin

• Convert Currency in SSIS

  Hello, has anyone used SSIS to convert currency based on a date from a table? For example; If I hav…

  mbrady5

  1 replies

  13 years ago

  By: jm99

• Flat File connection Manager - File Name, The Folder in File Name changes every time the package is reopoened and needs resetting

  Very strange issue. I have SQL Tables and Im using a For Loop to split the table up via a variable …

  Debbie Edwards

  12 replies

  13 years ago

  By: Debbie Edwards

• Can I use transactions for non database related control flow tasks

  Guys, I have a package that has two tasks. The first is an SQL task which updates two tables (batc…

  aaron.reese

  1 replies

  13 years ago

  By: mthurber

• SSIS ERROR LOGGING

  Hi can some body guide me best way to ERROR LOGGING in SSIS? Thanks in Advance

  iamsql1

  1 replies

  13 years ago

  By: Daniel Bowlin

• Export multiple files to Excel using SSIS

  Hi all Can someone please help me with a link that has an example on how to export data to multiple…

  SceloM

  9 replies

  13 years ago

  By: Debbie Edwards

• script task

  Hi All, i have been using ssis for few years now i have used most of the components/task but never …

  varmadba

  5 replies

  13 years ago

  By: mister.magoo

• Restricting Data before using OLE DB Destination

  I just used the unpivot tool. So now I have more columns than I need. I know how to map the column…

  Jacob Pressures

  5 replies

  13 years ago

  By: Jacob Pressures

• Looking for a way to move files from a dynamic source location to another dynamic archive location

  I got the following situation: A database with a settings table and archive tables. (In the setting…

  Resender

  7 replies

  13 years ago

  By: Jeff Moden

• Prevent flat file from being written (SSIS 2008r2)

  SO In the project I'm working I'm importing csv files from a dynamic map to a database. As an extra…

  Resender

  3 replies

  13 years ago

  By: Phil Parkin

• check contents of a text file

  Guys, I am using the Konesans file watcher to watch for a file (status.txt) to change. The file con…

  aaron.reese

  5 replies

  13 years ago

  By: aaron.reese

• configure list of email addresses in XML file

  Guys, When deploying my package using XML configuration, I have a variable called [User::strEmailLi…

  aaron.reese

  2 replies

  13 years ago

  By: aaron.reese

• Reading Data From XML through Script component

  Goal : Need to pull data from XML file (800MB). Note: I tried to do with XML task and XSLT but cou…

  quillis131

  6 replies

  13 years ago

  By: Orlando Colamatteo

• SSIS Config Wizard failing on SQL Server config

  We have a SSIS package that has been developed in VS2008. Our company standard is to have package …

  Angela Henry

  4 replies

  13 years ago

  By: Paul Hernández