SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Re-name a file using File Sysytem Task

  Requirement My Control Flow has: Data Flow task FTP Task FTP Server: \\server\directory\ ----------…

  fenicon

  1 replies

  16 years, 10 months ago

  By: Phil Parkin

• Tranformingand Tranfering a big file

  I need to transfer a big files 100 GB ++ between two locations. SOURCES located in the network seg…

  Ed7

  1 replies

  16 years, 10 months ago

  By: COZYROC

• Windows Logon

  I want to store windows logon in a variable in SSIS? Any ideas?

  Kenneth Augustine

  3 replies

  16 years, 10 months ago

  By: Paul_J

• Executing SSIS Package from VB.NET

  Hi, My current VB.NET (2003) code is till now executing DTS packages. As all my DTS packages are mi…

  Suresh Arumugam

  1 replies

  16 years, 10 months ago

  By: Paul_J

• foreach task (SSIS) for iterating throughfiles & storing them into SQL table

  Hi there, I have bunch of xml files and I want to store data from them in SQL Table. I started by i…

  MuditGupta

  3 replies

  16 years, 10 months ago

  By: Chris Golla

• Parsing data from 1 SQL table to 1 or more xxx_GLEntries_yyyymmdd.csv files

  1. I need to populate a work file dbo.wk_RReef_GLEntries with one or more possible companies, this …

  jpalmer-755805

  5 replies

  16 years, 10 months ago

  By: GSquared

• SSIS On-line tutorial practice question

  Hi All, i am new to SSIS, i just started learning SSIS.In a tutorial example 1,when i am trying t…

  naveen.bethi

  1 replies

  16 years, 10 months ago

  By: blurpyblurp

• Package stuck on on Pre-Execute

  Hi, Can anyone point me in the right direction? We have a group of tables in live (containing large…

  Grahaeme Ross

  1 replies

  16 years, 10 months ago

  By: arussell_10

• SSIS scheduled package works one day, fails another. Nothing changed.

  I have 3 scheduled packages which are identical except for the connection manager names, as they co…

  kl4576

  7 replies

  16 years, 10 months ago

  By: michael_cann

• Creating a new text/csv file everytime exporting a data in SQL server 2005

  Hi, Does anybody have idea how I can export data from SQL Sever to text file. I want to make new te…

  vishal.hatvalne

  1 replies

  16 years, 10 months ago

  By: Ramesh Saive

• Violation of UNIQUE KEY - Which Row?

  Hello folks, I'm new to Visual Studio 2005 and SQL Server Integration Services 2005. I am attempti…

  dakman

  2 replies

  16 years, 10 months ago

  By: dakman

• How do I pass a variable value to a query?

  I'm trying to copy data from one server to another. The volume has got so large that I now need to …

  StarNamer

  5 replies

  16 years, 10 months ago

  By: COZYROC

• problem in bids

  Hi all, when i am opening old package in bids or creating new project(is,as,rs).it shows the messag…

  ramu4ind

  4 replies

  16 years, 10 months ago

  By: COZYROC

• Merging two seperate sources

  Hi again Onto my next problem which I originally thought I had sorted, but turns out it's not worki…

  Garth Michel

  1 replies

  16 years, 10 months ago

  By: Ronald H

• File system task - for each file

  Like many others, i do have an issue with a file system task. I'm using SSIS 2k5 SP3. I simply want…

  Megistal

  3 replies

  16 years, 10 months ago

  By: Megistal