Integration Services

• Topics

  Started by

  Posts

  Last post

• 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

  10 years, 10 months 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

  10 years, 10 months 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

  10 years, 10 months 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

  10 years, 10 months 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

  10 years, 10 months 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

  10 years, 10 months 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

  10 years, 10 months 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

  10 years, 10 months 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

  10 years, 10 months 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

  10 years, 11 months ago

  By: SQL.AP

• SSIS Secure it after scheduling in SQL Agent

  Hi, Lately I'm working on SSIS package that may be used by our customer on their site to connect to…

  Emil B

  2 replies

  10 years, 11 months ago

  By: Emil B

• Data move from server to Shared path

  Hi, I would like to know the ways of move data from one server to another server. Two cases are the…

  yuvipoy

  1 replies

  10 years, 11 months ago

  By: SQL.AP

• Call parametized SP using Execute SQL Task

  Hi , I have created a store procedure like below ALTER Procedure [dbo].[Call_All_Incremental] @File…

  vipin_jha123

  2 replies

  10 years, 11 months ago

  By: SQL.AP

• SPLIT A FILE DYNAMICALLY

  Hi Team, Is there any possibilities to split a flat file by given condition dynamically..? currentl…

  Kannan Vignesh

  1 replies

  10 years, 11 months ago

  By: Lowell

• Conditional Split - Condition Explanation

  Hi, Can someone explained how the conditional split is doing as not sure what it is doing? ISNULL(…

  SQL_Kills

  4 replies

  10 years, 11 months ago

  By: SQL_Kills