SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Data Validation in SSIS

  I have a CSV file,i need to transfer this to a database table in SSIS and then check for data i.e o…

  Lalitha Reddy

  6 replies

  15 years ago

  By: nakkeeran.kannan

• AdjustTokenPrivileges () failed (00000514)

  Hi there, I am trying to run an SSIS package. I get an error screen, SQLDUMPER.EXE 'AdjustTokenPriv…

  sanjay.sql

  1 replies

  15 years ago

  By: Samuel Vella

• Using SSIS for FTP and Email

  Hello all, My companies ERP has been modified to import XML files we receive from a customer. The …

  kwoznica

  11 replies

  15 years ago

  By: SQLRNNR

• Dynamic OPENQUERY, using EXEC with SSIS data flow task

  Basic situation: We need to get data from DB2 into SQL Server. We do this via OPENQUERY and an SSI…

  Pam Brisjar

  5 replies

  15 years ago

  By: Phil Parkin

• SSIS access permissions

  I am confused between the two ways of allowing access to users on SSIS. How are the following two a…

  Minnesota - Viking

  2 replies

  15 years ago

  By: Phil Parkin

• dynamic lookup

  Hi all, I have a requirement to update rows and lookup on updated rows, can this be done using SSIS…

  sql_learner29

  11 replies

  15 years ago

  By: Elliott Whitlow

• JUST FED UP with SSIS. Simple copy of 800 tables to another database...

  I'm new to SSIS but not SQL. Still, this has been a mess of monumental proportions. Between wrestli…

  bimplebean

  28 replies

  15 years ago

  By: panoslondon1

• Process Multiple File per Customer

  I have a Customer XYZ , it has two sources one is FTP and other is excel, FTP file has some referen…

  Citiinvestor

  4 replies

  15 years ago

  By: Phil Parkin

• Invalid character value for cast specification Code: 0xC020901C

  We load our data warehouse nightly and everything was working for the last year. Recently the job …

  Tim-153783

  13 replies

  15 years ago

  By: vishant77

• Copied a DFT that uses Event Handler

  I inherited an *interesting* SSIS package. It contains several DFTs that each execute a different …

  hallhome

  4 replies

  15 years ago

  By: Koen Verbeeck

• Ouput flat file in ssis

  I have a flat file output with several string datatype columns in it . I want the string datatype c…

  Sachin4all

  2 replies

  15 years ago

  By: ZZartin

• PGP Encryption in SSIS

  I have a package which generates a Flatfile(CSV). Then i need to upload it to the FTP server with t…

  Sachin4all

  22 replies

  15 years ago

  By: Elliott Whitlow

• SSIS derived column replace with

  I am using the Transformation editor in BIDS 2005 to change a column Division buyer when column div…

  ringovski

  2 replies

  15 years ago

  By: Phil Parkin

• weird issues with dtsexec.exe (32bit) on 64bit server after Windows 2008 R2 SP1 install

  Hi there, I am having this issue on my 64-bit SQL Server after installing Windows 2008 R2 SP1 and o…

  Angie Field

  2 replies

  15 years ago

  By: Angie Field

• How to mimic a transaction when MSDTC isn't available

  I need to load data from an SQL 2000 server with MSDTC disabled into a set of staging tables in an …

  LightningFingers

  6 replies

  15 years ago

  By: repicurus