SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• FTP Task

  Hey guys, Im trying to use a FTP task in SSIS, but when I try to set it up, it gives me an error...…

  asm1212

  1 replies

  13 years, 11 months ago

  By: Raunak Jhawar

• SSIS Package executes, but fails when run as a SQL Job

  I have created a simple SSIS package which will create a .csv file and then it gets pasted to a ftp…

  jyz

  4 replies

  13 years, 11 months ago

  By: jyz

• SSIS Package executes, but job fails [SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Option "/X86" is not valid. The command line parameters are invalid. The step failed]

  I have created a simple SSIS package which will create a .csv file and then it gets pasted to a ftp…

  jyz

  1 replies

  13 years, 12 months ago

  By: Koen Verbeeck

• Help required to import data from excel 2007 (xlsx)

  Hi all, I am using Visual Studio Premier Partner (SP1) - Visual Studio 2005. I am having problems i…

  DerbyNeal

  1 replies

  13 years, 12 months ago

  By: DerbyNeal

• Concatenating Text Field

  I have to import a bunch of spreadsheets (example below) that all have the same format into a SQL 2…

  alex_pixley

  2 replies

  13 years, 12 months ago

  By: kramaswamy

• SSIS Raw file Import

  Hi , I need to import Flat file having format "~" delimiter. I want to use SSIS. Please explain me …

  aks_pra

  5 replies

  13 years, 12 months ago

  By: kramaswamy

• UTF-8 Flat File

  Hi, I need to copy data from Db to UTF-8 Flat File in SSIS. Vishal

  vishal.kunwar

  10 replies

  13 years, 12 months ago

  By: kramaswamy

• SSIS - type cast to MM/DD/YYYY from YYYYMMDD

  Hi, I am trying to Import a flat file (delimited) into a SQL server table. the was created from a u…

  vaioks

  28 replies

  13 years, 12 months ago

  By: Phil Parkin

• How to install 32 bit dtexec in sql server 2005 machine

  Hi, I have a windows 2003 R2 server that has SQL Server 2005 Standard Edition installed. But my pre…

  RubySWorld

  8 replies

  13 years, 12 months ago

  By: RubySWorld

• when not to use SSIS and stored procedures

  Hi, When will you decide not to use SSIS when having to import data? Also, would you use stored pro…

  jadelola

  7 replies

  13 years, 12 months ago

  By: Koen Verbeeck

• does export/import wizard guarentees and referential integrity???

  Hi All, Just wanted to check if sQL server export/import wizard takes care of referential integrity…

  Oracle_91

  5 replies

  13 years, 12 months ago

  By: Oracle_91

• Need help to learn SSIS

  Hi I am a newbie to SSIS technolgy.....Really i am eager to learn it from basics to Advanced...Plea…

  marees.inspire

  8 replies

  13 years, 12 months ago

  By: kramaswamy

• Creating a database and then migrating a folder full of files that was created by a vb6 program into a table

  Hello, My name is Joe and I am truly a newbie at any type of programming. I mean really n…

  pc_doc2001

  14 replies

  13 years, 12 months ago

  By: kramaswamy

• convert string data to int

  i am trying to import an access table in sql server. One of the columns Age is defined as Integer i…

  ps.

  5 replies

  13 years, 12 months ago

  By: ps.

• File Connection Manager Security Context

  Hi Folks - I'm working on an SSIS package to back a directory up from one server to another using …

  BobW-496277

  2 replies

  13 years, 12 months ago

  By: BobW-496277