SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Package Validation Error - Type of variable @[User::variable] is not a string

  Hi All, Am getting the following error: Package Validation Error - Type of variable @[User::variabl…

  Janaa

  1 replies

  15 years, 1 months ago

  By: Koen Verbeeck

• SQL Agent not running on FTP

  Hi, I have a package that will take latest files from [FTP path] archive to the root folder. I…

  sqlusers

  9 replies

  15 years, 1 months ago

  By: Adiga

• Setup Send Mail task

  Could anyone give me tips how to setup Send Mail task at home using just an Internet provider? Than…

  sqlgreenhand

  8 replies

  15 years, 1 months ago

  By: sqlgreenhand

• Add a package variable to the data flow

  I'm loading a fixed-length text file with 10 columns into a SQL table. All the mappings are comple…

  billj-705548

  5 replies

  15 years, 1 months ago

  By: Phil Parkin

• Creating Db Tables with Foreach Loop

  Hello.. im a bit of a newbie with SSIS so please go easy! I've set up a foreach loop to go through …

  AJF

  17 replies

  15 years, 1 months ago

  By: AJF

• SSIS - Using a server variable within execute sql task code

  Hi guys, I have created a user defined variable at package level called DestinationServer, the valu…

  Linda Hale-470385

  10 replies

  15 years, 1 months ago

  By: Linda Hale-470385

• How to handle parallel objects sequence after conditional split for two different case

  Hello, In the data flow, in the conditional split object, i have added two conditions Case 1: IF NO…

  iBar

  10 replies

  15 years, 1 months ago

  By: Phil Parkin

• ssis package runs fine in business intelligence studio but fails in sql server agent

  Hi, i have a package that uses flat file connection to get the data from txt file, then dump into a…

  bladerunner148

  17 replies

  15 years, 1 months ago

  By: Koen Verbeeck

• Lookup with Oracle Database

  Hello, I want to use a Lookup between a Dataset and an Oracle Database. And I have a "Warning" on m…

  mklein2

  9 replies

  15 years, 1 months ago

  By: Phil Parkin

• Flat File Connection Manager Can see my text file on the mapped drive but can not on the UNC.

  I am creating a simple Flat File to Table package. No special activity. Just a Flat file connection…

  dugsmith

  8 replies

  15 years, 1 months ago

  By: Carol Davis-371113

• Moving .dtsx from development pc to server, how is this correct accomplished?

  I'm new to SSIS development, I'm sure this is completely a newbie question. I created a package to …

  Tim Hief

  11 replies

  15 years, 1 months ago

  By: Tim Hief

• STEPS TO CREATE SSIS PACKAGE TO RUN STORED PROC AND GET E-MAIL NOTIFICATIONS

  I am a new bie and want to know about how to create ssis package to run stored proc and get email n…

  wannalearn

  10 replies

  15 years, 1 months ago

  By: wannalearn

• How to transfer multiple tables from oracle to Sql server 2005 using SSIS

  Hi, I'm trying to copy a single table from Oracle server to Sql server 2005 using SSIS An…

  badam.manoj

  8 replies

  15 years, 1 months ago

  By: Koen Verbeeck

• xml task in SSIS

  I have a DTS package which imports xml data into a table; I have vb script in ActiveX script to acc…

  washawgolla

  7 replies

  15 years, 1 months ago

  By: jeevan.jeev1

• Executing status on SQL Server Agent Jobs

  Dear All i have problem with my Jobs on SQL Server 2005 Agent, when i run the jobs i see status of…

  nvsqlserver

  3 replies

  15 years, 1 months ago

  By: Adiga