SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Generate multiple text files using SSIS

  I'm new to SSIS. I have to generate seperate text file for each meeting. Is it possible in SSIS? Th…

  bhavnabakshi

  4 replies

  17 years ago

  By: bhavnabakshi

• What is Easiest way to import 150+ MySQL tables into SQL Server via SSIS

  I have to take a mySQL database (150+ tables) and place into a SQL Server database I know I can cre…

  sotn

  3 replies

  17 years ago

  By: sotn

• How to map dynamic properties of dts in ssis

  here goes the activex script in dts. I want to migrate this script to ssis. Should i use activex s…

  ruchi.arora

  5 replies

  17 years ago

  By: dheer

• how to check DTS packages require changes in order to work on SSIS

  Hi dear all, i have created SSIS for DTS packages migration. Now the my problem is that how i can c…

  MSQLDBA

  3 replies

  17 years ago

  By: Justin Lezon

• Excel Data load

  I am trying to load data from Excel. Certain columns can have numeric and alpha numeric data (EG: O…

  Sreejith Sreedharan

  1 replies

  17 years ago

  By: Phil Parkin

• task script cannot run on this edition of SSIS

  I designed an SSIS package it runs from Visual Studio 2005 will not run from SQL Job agent or from …

  mfink

  3 replies

  17 years ago

  By: Michael Earl-395764

• How to Import .dbf file from Micropay programm from Sage to SQl Server 2005

  Hi, I try to get import files with extension as DBF belong to programm name as Micropay (Sage) for…

  sergej jasenko

  2 replies

  17 years ago

  By: Jack Corbett

• "The publisher could not be verified" when executing a batch file

  Hi, In an SSIS script written in SQL 2005 I have an Execute Process task that's running an MS DOS b…

  samalex

  2 replies

  17 years ago

  By: samalex

• Exporting data in two Worksheets in the same Workbook

  Hi all, I have two SQL Queries and I want to run both SQL queries and wants the output in two diffe…

  arun4.g

  1 replies

  17 years ago

  By: shmuel_v

• help with error: 0xC0014062

  Hi, I'm trying to execute a dts package from command line using this code: DTExec /sq My_Package /s…

  AIRWALKER-375999

  1 replies

  17 years ago

  By: shmuel_v

• Send email notification when PackageTask fails

  Hello All, I have a parent package calling four child packages one after another inside a sequence …

  Amith Vemuganti

  5 replies

  17 years ago

  By: clou-951938

• SSIS package fails when runs under SQL server Agent

  Here is my problem, Please note that this is targeted only for advance SSIS developers. Description…

  Sriwantha

  1 replies

  17 years ago

  By: clou-951938

• SSIS Authentication Problem

  I've learnt SSIS only uses windows authentication. I can cope with this, and can connect to my inte…

  r5d4

  1 replies

  17 years ago

  By: Jack Corbett

• Dts Events FireInformation

  The story so far... I am trying to capture the values of variables at the beginning of a package's …

  hodgy

  3 replies

  17 years ago

  By: hodgy

• Getting Error Descriptions

  Hi folks, Playing around with a package that is bringing data in from a flat file (csv format) and …

  Shark Energy

  2 replies

  17 years ago

  By: Tim Mitchell