SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Using connection manager with in script task to get the file name

  Hi, I need to get the file name of a connection manager with in a script component. I added the con…

  peterk1961

  4 replies

  17 years ago

  By: peterk1961

• CheckSum Transformation Vs SCD Transformation vs Kimball Method SCD

  I'm starting a new topic from another thread since it veered off the original subject. I've tried …

  jreece

  1 replies

  17 years ago

  By: jreece

• Import data from Excel and select statement and insert to another table

  I am having a table "Categories" with the structure as below CatId INT IDENTITY, Descr VARCHAR(50),…

  a2zwd

  5 replies

  17 years ago

  By: a2zwd

• SSIS Transaction to roll back file creation

  Hello, I have an integration services package which updates a number of records (using execute SQL …

  Rachel Byford

  2 replies

  17 years ago

  By: Rachel Byford

• SSIS Package Iterative Connection question

  I'm creating a little schema structure that gathers information from databases on multiple servers …

  bbrickey-876561

  1 replies

  17 years ago

  By: COZYROC

• Data Conversions Problem

  Hi, My datasource is a flatfile (.TXT) 1)Column - US1_UNITS - datatype- nvarchar 2) Column - US1…

  Raj-1120270

  3 replies

  17 years ago

  By: SSISSSRSSSAS

• Large Imports Fall over AKA Cannot fetch a row from OLE DB provider "BULK" for linked server

  Hi there, I am importing a fairly large text file - abour 0.5GB and a few million rows. After about…

  Chris Hewitt-261101

  9 replies

  17 years ago

  By: extra11

• Send a Mail with Attachment with Script Task

  hey is it possible to send a mail with multiple attachments with the script task? thanks for any he…

  nero.ch

  2 replies

  17 years ago

  By: COZYROC

• Initiate package from MS Access

  I have a process (SSIS) that I would like a user to be able to initiate on demand, primarily from M…

  Howard C. BAchtel-438731

  1 replies

  17 years ago

  By: COZYROC

• Equivalent function for IIF and date time

  Hi, How should I use the below code in derived column in SSIS. IIF(TO_CHAR(CREATEDTS)='01/01/0001 0…

  Balaji L

  9 replies

  17 years ago

  By: Phil Parkin

• Sending result set to variables for use in subsequent step

  HI guys/gals I have been spinning my wheels here for a bit.. Here is my issue: I have one step tha…

  Rich Hansell

  6 replies

  17 years ago

  By: bkirk

• Case Sensitive

  I understand sql server queries are not case senstive but recently when i was doing some trasformat…

  Tara-1044200

  3 replies

  17 years ago

  By: felix.gustavo.hernandez

• SSIS Oracle Parameter Mapping Problem

  Hi Friends, I have a small problem in parameter mapping for Execute SQL Task. I am using a delete s…

  Oracle_91

  4 replies

  17 years ago

  By: tiger-1109307

• CAN I COPY A FILE FROM ONE SERVER TO ANOTHER SERVER GIVING UNC PATH AND USING FILE SYSTEM TASK

  I am trying to copy a file from one server to another server using file System Task. The file is on…

  SSISSSRSSSAS

  1 replies

  17 years ago

  By: WayneS

• Capture a text file row count and update a SQL header table

  Hi all, I'm brand new to SSIS and am assigned the task of taking a text file (ragged right) and cre…

  lianaent

  1 replies

  17 years ago

  By: lianaent