SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Using OLEDB provider in Execute SQL task

  Hello, I want to use OLEDB provide in execute sql task. (Reason why not ADO.NET is that I am not ab…

  vishal.shinde

  2 replies

  15 years, 10 months ago

  By: divyanth

• Sometimes I could kill SSIS (that red colour really gets me mad!)

  Any ideas on this one people? I'm running an Execute SQL Task. It should be getting a variable pass…

  Shark Energy

  5 replies

  15 years, 10 months ago

  By: Elliott Whitlow

• Send email if Foreach loop container, does not find files

  Hi All, I have a foreach loop container that copies *.csv files (using a file system task) from one…

  chrismgarvey

  1 replies

  15 years, 10 months ago

  By: chrismgarvey

• Need help with some creative Dtexec syntax

  Hello, I've searched the internet far and wide, tried infinite escape combinations, but can't get D…

  digitalox

  7 replies

  15 years, 10 months ago

  By: Elliott Whitlow

• SQL Server 2005 Database mail configuration error!!

  Hi All, I am trying to configure a database mail on SS2005 using gmail account. I have specified …

  daypharm

  2 replies

  15 years, 10 months ago

  By: Jack Corbett

• Replace Blanks in the Derived Column Transform

  Hi, I'm having some problems with the following. I have a flat file that has a column of data in t…

  SJB42

  3 replies

  15 years, 10 months ago

  By: Phil Parkin

• Connection issues

  Hello all, I am trying to put together a package that reads data from two different servers and wri…

  DKlein

  7 replies

  15 years, 10 months ago

  By: DKlein

• running 2008 ssis pkg on sql server 2005 env

  Install 2008 client where it has 2008 ssis - the 2008 version of dtsexec? Thanks.

  carol.boersema

  5 replies

  15 years, 10 months ago

  By: Shawn Liddick

• Need Help Learning SSIS - FAST!

  I've written a few DTS packages in SQL2000. Now I've been tasked to write similiar processes (impor…

  rew-370421

  20 replies

  15 years, 10 months ago

  By: Alan. T.

• Close smtp session script task

  Greetings Is there any way to close an SMTP connection via a script task? The reason I need to do t…

  yosiasz

  4 replies

  15 years, 10 months ago

  By: yosiasz

• Variable/Expressions in an SSIS Package

  I'm hoping someone can lead me in the right direction. I need to pull 6 weeks of data starting wit…

  Regina Beauregard

  4 replies

  15 years, 10 months ago

  By: Regina Beauregard

• Operator notify task

  Hi again I have a question about the operator Notify task. in my Dev environment this is set to a …

  Kwisatz78

  3 replies

  15 years, 10 months ago

  By: Elliott Whitlow

• Cannot connect to SSIS in 2005 Management Studio

  Hi all, When i try to connect the SSIS in Management Studio, the Server name just blank, I entry th…

  Patrick-304111

  16 replies

  15 years, 10 months ago

  By: divyanth

• FTP script task doesn't fail

  Hi all - I have a script task that connects to an FTP share and checks it there are files there to …

  Kwisatz78

  3 replies

  15 years, 10 months ago

  By: Elliott Whitlow

• Exporting Documents into file system

  Hey all, Wanted to take a database and export all the documents from it using either t-sql or ssis…

  Niall Duggan-433856

  4 replies

  15 years, 10 months ago

  By: Elliott Whitlow