SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Identifying what conditions "failed" in Conditional Split

  I'm using a conditional split to send valid rows to one output file and invalid rows to a separate …

  MattieMich7

  2 replies

  16 years, 1 months ago

  By: Erik Kutzler

• SSIS variables from dataflow to control flow

  Hellow, How to pass the values of variables from dala flow to control flow. I have a variable delca…

  kutti_subs

  3 replies

  16 years, 1 months ago

  By: Phil Parkin

• Variables and Script component as a source

  Hello all, I have an integer variable in my package called DaysToRun. I need to use this variable…

  stricknyn

  5 replies

  16 years, 1 months ago

  By: COZYROC

• how to make server configurable with ip address

  I have a xml configurable ssis package withn a destination is configured. now i need to configure d…

  abhisek karki

  1 replies

  16 years, 1 months ago

  By: Phil Parkin

• truncate headers in a csv

  Hi All, I have a text in the following format Row1: ABC Company Row2: Address Row3 (Column Names): …

  UnionAll

  1 replies

  16 years, 1 months ago

  By: stricknyn

• string to NULL

  Hi all, I have a question I want to check for string value and replace it with NULL is it possible …

  sql_learner29

  1 replies

  16 years, 1 months ago

  By: Erik Kutzler

• Load Typed XML into sql server 2005

  Hi, I have a xml whose structure is as below: <ns:abcd-XMLInterchange xmlns:dc="http://axc.net/d…

  sugaz007

  1 replies

  16 years, 1 months ago

  By: LutzM

• SSIS Checking for Values in SQL Task

  I have an SSIS package where I am calling a CL job on the AS400. The CL Program runs about 8 jobs …

  timothy_kramer

  3 replies

  16 years, 1 months ago

  By: timothy_kramer

• SSIS File Exists implementation - no scripting

  I am using the existence of a file to control flow in a package I am designing. To make sure this …

  gary.wood

  2 replies

  16 years, 1 months ago

  By: Phil Parkin

• Can you put Recordset Destination in the table?

  Can you put Recordset Destination in the table?

  CooLDBA

  8 replies

  16 years, 1 months ago

  By: GSquared

• Using "Sql server" option for Configuration type

  HI i want to use sql server option of configuration type. i have created the table "[SSIS Configu…

  Bhuvnesh

  1 replies

  16 years, 1 months ago

  By: Bhuvnesh

• Derived Column from nvarhar to varchar

  can someone tell me what should I put on the expression for converting nvarchar to varchar? Where c…

  CooLDBA

  1 replies

  16 years, 1 months ago

  By: SQLRNNR

• Can't convert between unicode and non-unicode string data types

  Creating a SSIS package with a Flat File connection to a SQL table as its destination, getting a va…

  jsheldon

  14 replies

  16 years, 1 months ago

  By: keyun

• Jobs extecutes older version of .dtsx file

  I have a file system SSIS package (SourceFolder\GLload.dtsx). Jobs executes this package as SQL Ser…

  VRR

  11 replies

  16 years, 1 months ago

  By: john.arnott

• Importing Mixed Data from Excel Worksheet.

  [font="Arial"][font="Comic Sans MS"]Hi all, I am importing the data from the Excel Sheet(97-2005) i…

  SQLFanatic

  7 replies

  16 years, 1 months ago

  By: Phil Parkin