Integration Services

• Topics

  Started by

  Posts

  Last post

• Using SSISDB to manage multiple environments

  I am fairly new to SSIS and don't know a whole lot about it. I have been trying to follow an artic…

  Ron Kunce

  8 replies

  11 years ago

  By: Nevyn

• Archieve all the files in a folder using SSIS

  Hi All, I need to archive around 100 csv files in a folder to a zip file. The zip file will be name…

  joinshadab

  1 replies

  11 years ago

  By: karthik.bj

• Task to add new row and values to Table?

  Hi, I am new to SSIS, I have a table that I would like to capture daily currency conversion rates. …

  Marcus Farrugia

  3 replies

  11 years ago

  By: jphillips 46546

• practical advice arounding indexing and ETL?

  Must do a first time import millions of rows into a table followed by a daily import of much less (…

  KoldCoffee

  17 replies

  11 years ago

  By: MMartin1

• Redirect Rows is sending all rows after error

  I have an SSIS job that is trying to insert rows into a database table. I have the Error Output for…

  liamdemasi

  6 replies

  11 years ago

  By: liamdemasi

• SSIS Package Overkill For Exporting Recs from SQL Server to Individual Excel Spreadsheets?

  I've done some extensive work over the past year with SSIS for a client, developing a comprehensive…

  brad.mccollum

  3 replies

  11 years ago

  By: brad.mccollum

• How to deal with the unpredictability of how SSIS will interpret the flat file's column datatypes at run time?

  I've got an ssis package that will retrieve a bunch (45) of zipped text files from an ftp server, u…

  KoldCoffee

  3 replies

  11 years ago

  By: KoldCoffee

• SSIS Data Transfer Help Required

  Hi All, Can anyone help me on the issue below. I have xml_logs_table which contains 6,35,34,823 row…

  sunil9372

  6 replies

  11 years ago

  By: Koen Verbeeck

• Exporting Data as FlatFile to client's remote desktop

  Dear all: I need to write a Stored Procedure or SSIS package to export only new records with a time…

  MaggieW

  1 replies

  11 years ago

  By: Martin Schoombee

• Not able to write in a specific cell of excel using SSIS

  Hi, I am trying to write to a specific cell of a excel file using OpenRowset from Variable. Reading…

  reach_saugata

  13 replies

  11 years ago

  By: SQL.AP

• Place Files in Shared Path using SSIS

  I have created a OLE DB Connection and Created a Flat File in a Shared Folder Location. When i exec…

  CrazySam

  1 replies

  11 years ago

  By: SQL.AP

• FTP a Flat File using SSIS

  I have a OLE DB Source with query and convert to Flat FIle. I want to FTP this Flat File. Can we FT…

  CrazySam

  1 replies

  11 years ago

  By: SQL.AP

• Exporting Data to FlatFile

  Hey Guys, I needed assistance with exporting Data to Flatfile. I have placed following controls in…

  mannychohan

  4 replies

  11 years ago

  By: Martin Schoombee

• Joining multiple table

  Hello All, i have been battling with this for 2 weeks now, here is a situation i have 3 tables Id…

  lanreok99

  1 replies

  11 years ago

  By: Phil Parkin

• compare local folder with archive folder and Move the unmatched files to Different folder

  Hi, I have an sftp task to download the files from sftp server to local server, once i download all…

  Dhruva_51

  1 replies

  11 years ago

  By: SQL.AP