SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• SSIS Interview Questions -COMPLEX 1ne

  Hi Experts, I have been going through several interviews these days, and have came accross certain …

  sql_learner29

  47 replies

  13 years, 10 months ago

  By: deepak.a

• Need to dynamically generate schema in OLDEB source sqlcommand - script to big for an expression or stored proc

  We have 2 identical core systems containing different information. We have an ODS database where w…

  mandy-570563

  1 replies

  13 years, 10 months ago

  By: Koen Verbeeck

• Export to Excel - How do you ignore Column Headers?

  I'm Exporting SQL Server Data into a Monster Excel Document that contains Several Excel Sheets. Mos…

  Welsh Corgi

  3 replies

  13 years, 10 months ago

  By: Welsh Corgi

• SSIS variable display

  I have been trying to write a script to display the value of a variable through a message box. I ha…

  nabajyoti.b

  2 replies

  13 years, 10 months ago

  By: fabulous617

• OLEDB COMMAND Usage

  Hello, I am not sure , If I can use this OLEDB transformation for this req A column from a table is…

  quillis131

  11 replies

  13 years, 10 months ago

  By: kramaswamy

• SQL Server Agent decreasing package performance

  Hi, Does anyone have an idea why running SSIS packages through the SQL Server Agent dramatically in…

  Hesten Erwin

  2 replies

  13 years, 10 months ago

  By: Martin Schoombee

• Set up connection to remote server on another domain

  This may be either really easy or impossible! I'm trying to loop over a set of directories in a sha…

  christina-518819

  9 replies

  13 years, 10 months ago

  By: christina-518819

• Using a Stored Procedure as A Data Source

  I want to use a Stored Procedure as a Data Source. I understand that there are some issues with res…

  Welsh Corgi

  22 replies

  13 years, 10 months ago

  By: Welsh Corgi

• for each loop problem

  Hi How can I loop through a column using for each loop container...or in SSIS I have a column Level…

  sql_learner29

  1 replies

  13 years, 10 months ago

  By: christina-518819

• package variabel as lookup table

  Please let me know, how can I use package variable (populates GUID table), for lookup. I need to ch…

  radb4u

  2 replies

  13 years, 10 months ago

  By: COZYROC

• Trying to use output of Temp Table ISS SSIS PAckage

  SELECT Comp.CompanyName, LEFT(Comp.CompanyNumber, 6) AS [Account Number], Quote.QuoteID, M…

  Welsh Corgi

  13 replies

  13 years, 10 months ago

  By: Welsh Corgi

• Aggregation Problem

  I have a table of customer updates that I first need to pivot in order to give me one row per custo…

  Jason Coleman

  3 replies

  13 years, 10 months ago

  By: Jason Coleman

• Package

  I made some changes to existing package file which was developed by other user is not getting saved…

  Mvs2k11

  1 replies

  13 years, 10 months ago

  By: Koen Verbeeck

• Excel Destination - Want to preserve the Excel Workbook after loading and Save to a LOcation for User Access

  I have an SSIS Package with a SQL DataSource and An OLEDB Excel Data Destination Object. After I lo…

  Welsh Corgi

  3 replies

  13 years, 10 months ago

  By: Welsh Corgi

• Send Mail Task using Expressions

  I have build two user defined variables that get the TO and FROM email ids from a SQL Server Table …

  notes4we

  5 replies

  13 years, 10 months ago

  By: samuel858