SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Read dtsConfig as XML

  Hi, Sorry if this has been asked before, I have searched... My question is, using .NET in a Script …

  paul.r

  4 replies

  13 years, 9 months ago

  By: Elliott Whitlow

• Dynamic Connection String in File Connection Manager Throwing error

  The goal of my package is to create and FTP an extract file in three steps: 1)Execute some SQL to c…

  Vaughn LaForce

  3 replies

  13 years, 9 months ago

  By: kramaswamy

• SSIS-Executing SP which is having parameters.

  Hi, [font="Verdana"]I am New to this Forum and i hope i will get some valuable infirmations from my…

  yuvipoy

  1 replies

  13 years, 9 months ago

  By: kramaswamy

• Step through Data Flow

  I am new to SSIS package and have some trouble debbuging it.....Can we step over from Control Flow …

  sandyinfowave

  4 replies

  13 years, 9 months ago

  By: sandyinfowave

• Data viewer not working

  Hi, Lookup output data viewer is not working. I could see the number of rows at output flow but dat…

  radb4u

  3 replies

  13 years, 9 months ago

  By: radb4u

• Derived Columns in alphabetical order

  I've been working with SSIS for quite a while now. at the moment I have in various packages about 5…

  Henk de W

  2 replies

  13 years, 9 months ago

  By: Phil Parkin

• How to update Product description regularly ?

  Hi, We have an Excel sheet with product number and the new product description. A product tabl…

  SkyBVI

  1 replies

  13 years, 9 months ago

  By: Daniel Bowlin

• SSIS fails with ACCESS DENIED error when scheduled as job

  The following script task uploads files from a local UNC to an UNIX location through sftp. We are …

  Kaushik Majumder

  2 replies

  13 years, 9 months ago

  By: Kaushik Majumder

• SSIS SEND MAIL TASK EXCEL ATTACHMENT TIME OUT ERROR

  HI ! I need help to fix SSIS Send Mail Task Error. I have a Data Flow Read from Sql Data base and t…

  gukgukcommunity

  11 replies

  13 years, 9 months ago

  By: Srihari Kagita

• Need help with Script task vs ActiveX task

  I'm rewriting a DTS package in SSIS 2008 R2 64bit. The DTS package ran an ActiveX vbs script to qu…

  Randy Doub

  2 replies

  13 years, 9 months ago

  By: COZYROC

• Read multiple flat files with different formats and output to SQL Server

  Hi all, Got a question that I'm not sure if there's an actual solution for. I have a script which d…

  kramaswamy

  2 replies

  13 years, 9 months ago

  By: COZYROC

• System::MachineName on a cluster

  Hello I was wondering if someone can answer the question below A bit of a background: We are trying…

  admhorror

  1 replies

  13 years, 9 months ago

  By: COZYROC

• Executing multiple SSIS packages

  I am trying to execute around 3 SSIS packages using Execute package task by having all the 3 in one…

  Mh-397891

  4 replies

  13 years, 9 months ago

  By: Amar009

• How to send text email using sql server 2005

  Hello I am trying to send text email using sql server 2005. i have few stored procedures that need …

  ionu

  1 replies

  13 years, 9 months ago

  By: Lowell

• Not seeing Data Flow Sources/Destinations in Toolbox

  I'm in the process of creating a new SSIS package on a test server I've never used before. In my T…

  Libby

  1 replies

  13 years, 9 months ago

  By: Libby