SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Demanding and difficult logic qns. Sorry but i need help.

  Hi pros out there, I am introduced to SSIS to do ETL for repporting in SSRS very recently. I am giv…

  10e5x

  31 replies

  12 years, 5 months ago

  By: 10e5x

• Using SSIS to automate PGP encryption of text file

  I am trying to automate in SSIS the PGP encryption of a text file.  Has anyone done this befor…

  Ryan-257272

  39 replies

  12 years, 5 months ago

  By: harikrishna796

• Windows Application Log indicates error with script, but script succeeded

  Hi all, Got a bizarre error. In my Windows Application Log, I see errors similar to the following: …

  kramaswamy

  1 replies

  12 years, 5 months ago

  By: Steve Jones - SSC Editor

• SSIS Newbie

  Hi All, I am new to SSIS,I have given task of implementing the following task create SSIS packages …

  ningaraju.n

  6 replies

  12 years, 6 months ago

  By: Koen Verbeeck

• Creating dynamic excel table through Execute Sql Task - data types problem

  Hi, I'm using an SSIS package to create an Excel table and export the data from a corresponding SQL…

  idogal

  2 replies

  12 years, 6 months ago

  By: idogal

• Confused about FlatFile Connection Manager Error

  I'm getting this error on my package "A valid file name must be selected". Here is why this confus…

  bobd125

  4 replies

  12 years, 6 months ago

  By: P Jones

• How to use Windows Authentication for remote server

  HI Experts, I am designing a SSIS package, my requirement is that I need to take data from remote s…

  xparmanand

  6 replies

  12 years, 6 months ago

  By: sqlfriend

• AS400 to SQL Server using SSIS

  I have data in the AS400 file which should be extracted. The file would be available on the AS400 o…

  reshma_cm

  8 replies

  12 years, 6 months ago

  By: benji.purewal

• Data conversion in SSIS

  Hi everyone, I am newbie to SSIS, just picked that up ytd. Currently i am given a sample view table…

  10e5x

  7 replies

  12 years, 6 months ago

  By: Ray M

• send mail task error after smtp server name changes

  Hello All, i have a ssis package, which is running fine so far, if it fails it notify to tech suppo…

  asita

  1 replies

  12 years, 6 months ago

  By: Elliott Whitlow

• Package Connection Bombs to different server, but works fine in a different connection... Stumped.

  Ok... this might get lengthy... so please bare with me. I have a DTSX package that has over 30 ste…

  CptCrusty1

  5 replies

  12 years, 6 months ago

  By: CptCrusty1

• move all data from first sql server 2005 database to second database sql server 2005 two are same

  I have two databases these two databases have same structures and objects but different only in dat…

  ahmed_elbarbary.2010

  1 replies

  12 years, 6 months ago

  By: Phil Parkin

• Help to compare two tables in SSIS

  I want to insert values in to “Table B” from “Table A”. Both the tables has only two columns and sa…

  DBA12345

  1 replies

  12 years, 6 months ago

  By: Phil Parkin

• SSIS Package step FTP

  I have a step that ftp out to a location to grab a file. each month the file name changes, is there…

  D-SQL

  5 replies

  12 years, 6 months ago

  By: Ray M

• Pass SQL Execute task output to target tbl(Data flow).

  Hi, we need to insert random values to target table. We are using the query in SQL Execute task wit…

  Saintmount.Sql

  4 replies

  12 years, 6 months ago

  By: Phil Parkin