SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Data output to a network drive

  Hi, I have an SSIS package which takes data from a SQL 2005 database and outputs an Excel file onto…

  Steve Lund

  1 replies

  19 years ago

  By: Steve Lund

• Data Conversion task and data types

  I posted this the other day in a different forum but I think it was the wrong forum. Anyways, &nbs…

  CountCet

  1 replies

  19 years ago

  By: Gigi Sullivan

• how to dynamically copy whole sql 2005 database to an Access database (mdb)

  Hey, I am new to SQL server and SSIS. I am trying to build a SSIS package that exports a whole SQL …

  Amar Bajwa

  3 replies

  19 years ago

  By: bledu

• Destination Script Component - multiple oledb.datareaders?

  Is it possible to have more than one oledb.datareader inside a single script component?  Here'…

  John-79567

  2 replies

  19 years ago

  By: John-79567

• SQL Server 2005 64-bit - fetch data from Oracle

  Hi! We have a server with Windows 2003 Standard 64-bit & SQL Server 2005 Enterprise 64-bit and …

  Olof Wennerfors

  4 replies

  19 years ago

  By: Olof Wennerfors

• How to call Web Service From Script Task

  Hi All, Is there any way that I can call a web service inside a Script task in SSIS package? I'm no…

  Kian-302706

  3 replies

  19 years ago

  By: bledu

• Porting Data

  Hi All, I have an OLEDB Data Source that has 3 columns. I want to map these 3 columns to another ta…

  william crawley

  3 replies

  19 years ago

  By: bledu

• SSIS- I can not save big packages

  Hello, When I try to save modifies in packages with many components the system show me a informati…

  david-391039

  1 replies

  19 years ago

  By: bledu

• mail to lotus notes

  is it possible to use lotus notes mail server instead of using SMTP for send mail task? I dont thin…

  sqlstar2011

  1 replies

  19 years ago

  By: David Wall-401510

• Suppressing Events Windows Event Log

  Sorry if this is an obvious one, but I'm having a hard time figuring this out. I have a package tha…

  Treehouse

  3 replies

  19 years ago

  By: FP-401493

• Step needed to check for duplications

  I have created an SSIS package that runs through several Exec SQL Task steps. They mainly import d…

  Scottye McClain

  1 replies

  19 years ago

  By: Anders Pedersen

• extracting and loading data into Oracle using SSIS

  is it possible to extract from Oracle, transform (preferably in the buffer) and load data into…

  sqlstar2011

  1 replies

  19 years ago

  By: FP-401493

• drop table on SSIS not working

  i've found this problem before where if a table didn't exist at the destination SSIS would error ou…

  alen teplitsky

  2 replies

  19 years ago

  By: FP-401493

• Can''t import multiple MDB files in SSIS where structure is the same, but different file names.

  I am unable to import data from multiple mdb files that have the same file structure, data type but…

  Lee Davis-285380

  1 replies

  19 years ago

  By: Michael Earl-395764

• SSIS Broke after 4 days of run !!!!!!!!!!!!!!!!!!!!

  Hi   I have two big tables [Contain about 5 million rows] which are almost symmetric in schem…

  CDBA

  2 replies

  19 years ago

  By: CDBA