Integration Services

• Topics

  Started by

  Posts

  Last post

• Parameter passing from SQL Server agent

  Hi, Below is the scenario, •I'm calling the SSIS packages through SQL agent job. The packages have…

  Jim1234

  1 replies

  10 years, 7 months ago

  By: Martin Schoombee

• joining two select queries results in one row

  Hi, I want to get output of below query in single row. Select 'Name' Select 'Surname' Expected outp…

  vipin_jha123

  8 replies

  10 years, 7 months ago

  By: Martin Schoombee

• Convert ssis datetime variable value

  Hi, I have created one variable name migration_start datetime which give me default format of 6/11…

  vipin_jha123

  2 replies

  10 years, 7 months ago

  By: vipin_jha123

• Data Conversion Task - Capture which column failed

  I'm importing text data and using the Data Conversion task to convert some of the olumns. I have th…

  terry_stjean

  1 replies

  10 years, 7 months ago

  By: Phil Parkin

• want to see the value of variable in single massage

  Hi , I want to see the value of variable in single massage. I am using C#2012 code I am able to get…

  vipin_jha123

  1 replies

  10 years, 7 months ago

  By: Phil Parkin

• SSIS package to split address into 3 fields

  I have a table that I am using in a package to create an extract from. In that table is an address …

  W4Designs

  36 replies

  10 years, 7 months ago

  By: W4Designs

• Different query result between SSIS and Oracle Sql Developer

  Has anybody encountered this problem? I'm connecting to an Oracle database via both SQL Developer …

  kferrara

  1 replies

  10 years, 7 months ago

  By: Alvin Ramard

• SSIS Recommendation for Data Transfer

  Hello, I have been asked to create a routine that will send data created by a SQL Query to a Shared…

  mbrady5

  5 replies

  10 years, 7 months ago

  By: mbrady5

• SQL server 2014 and VS 2013 - Date Column Error and Error handling for Derived column

  Hello Everyone, At present, I'm facing two problems in current SSIS package. 1. Date Column Error. …

  ankithimmatlalshah

  2 replies

  10 years, 7 months ago

  By: ankithimmatlalshah

• WinSCP and SSH

  I am working on automation project where I will download files from vendor server. I am planning to…

  hemani2000

  3 replies

  10 years, 7 months ago

  By: SQL.AP

• xlsx 32bit not 64bit

  I've got my SSIS PROJECT configured as 32 bit. When I go to the sql server job agent there is no w…

  rwilliams_fl

  1 replies

  10 years, 7 months ago

  By: Martin Schoombee

• How to parse Flat File with varied Delimiters

  I have a text file that is comprised of a set of tags which represent a record. TagA is varchar wit…

  Sid Childers

  3 replies

  10 years, 7 months ago

  By: vipin_jha123

• Unable to insert data into float columns

  I am creating a package that performs a simple insert into a couple of float columns. The reason fo…

  cstg85

  10 replies

  10 years, 7 months ago

  By: Jacob Wilkins

• SSIS dataflow - passing nulls (blanks) from query (source) to csv (destination)

  Good morning - I have a SSIS dataflow that I am simply pulling data from a query (ODBC Source), and…

  Brian Seib

  2 replies

  10 years, 7 months ago

  By: Alvin Ramard

• Running SSIS task in SSMS Invocation error

  Hi, I'm trying to run an SSIS task in the SSMS query window. The SSIS task itself requires a p…

  Thom A

  6 replies

  10 years, 7 months ago

  By: Thom A