SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• SSIS and dynamic Excel files

  Environment - VS 2012, 32 bit, SQL 2008/2012, UNC paths OK. I've done this kind of thing before an…

  JustMarie

  2 replies

  9 years, 5 months ago

  By: JustMarie

• Problems with dynamic connection string.

  I've done this before and it worked. Not sure why not now. This is for loopping through a directo…

  nonghead-webspam

  13 replies

  9 years, 5 months ago

  By: Lempster

• Konesans File Watcher and Trash Destination2008

  I have Microsoft Visual Studio 2008, .Net Framework 3.5 SP1, and Microsoft SQL Server Management St…

  ss1121963

  1 replies

  9 years, 5 months ago

  By: Orlando Colamatteo

• read file *.db, *.px paradox from ssis

  Friends , I need to read files * .db and * .px ( paradox ) through a process of SSIS ( dtsx ) , so …

  dramon14

  14 replies

  9 years, 5 months ago

  By: Phil Parkin

• HTTP Connection in SSIS 'Unable to connect to the remote server'

  HTTP Connection in SSIS 'Unable to connect to the remote server' I have a HTTP connection in my pac…

  Ells

  3 replies

  9 years, 5 months ago

  By: glenn brown

• ActiveX Script Error: Function not found

  This is my first attempt to create SSIS package. I added ActiveX Script Task just to test '********…

  Vikka

  15 replies

  9 years, 5 months ago

  By: erswig

• Excel Data Source Missing Column Failure

  We have a process where our vendor can send us either an html or excel data sheet 1x/week. We chose…

  Vertigo44

  1 replies

  9 years, 5 months ago

  By: Alvin Ramard

• MSDTSServer

    I have some question concerning a problem we had.  Sorry for the size of this post, but…

  Brian Brown-204626

  3 replies

  9 years, 5 months ago

  By: Jamie-2229

• Import Data from Multiple Excel Sheets using SSIS

  Hi friends, Can anyone help me out how to extract data from multiple excel sheets (same excel doc h…

  purushoth.Chennai

  14 replies

  9 years, 6 months ago

  By: Mahesh Bote

• select * into works but insert into select gives conversion error

  I am inserting some data from a self join CTE into a table. When i do select * into to load data in…

  s.kandepi3

  3 replies

  9 years, 6 months ago

  By: Ed Wagner

• Looping over files with the Foreach Loop and loading to diffrent ...

  Hi Everybody, i am facing scenario some thing like this. i have 10 csv in a folder. so i need to lo…

  Praxy

  2 replies

  9 years, 6 months ago

  By: chukliz

• Call SSRS report from ssis

  I need to call a ssrs report from SSIS using a script task that has a File_ID as a parameter from t…

  PSB

  6 replies

  9 years, 6 months ago

  By: SQL Daddy

• Exporting tables in an MS Access database to SQL SERVER using SSIS

  Hi All, I want to export all the tables in an MS Access database to SQL Server tables using …

  sql server developer

  4 replies

  9 years, 6 months ago

  By: Erwin V

• Importing HTTP file using SSIS?

  Hi,   I am just wondering whether anyone has any experience of how I would import a .csv file …

  David Finnegan-403714

  4 replies

  9 years, 7 months ago

  By: ravi@sql

• Data Import... where does it save SSIS pkg to?

  When I right-click on a database, select Tasks and then Data Import... it takes me through the dat…

  JTB-552277

  12 replies

  9 years, 7 months ago

  By: mcdonnell