Integration Services

• Topics

  Started by

  Posts

  Last post

• import to multiple excel files

  Hi I have a query with the fields: unitname, pointname, point description as: worthington,ande…

  jman76

  3 replies

  11 years, 6 months ago

  By: jman76

• SSIS erros 0X80004005

  Hi, I have an ssis package which imports multiple excel files to sql table. I used For loop task a…

  susmitha117

  2 replies

  11 years, 6 months ago

  By: susmitha117

• extract from excel filename

  I have excelfilename starts like abc - usa sales- 1-1-2014. have to extract usa from the filename a…

  susmitha117

  2 replies

  11 years, 6 months ago

  By: susmitha117

• Remove any special characters from CSV file import

  Hi, I'm trying to import a CSV file however it contains the OBJ character  http://www.fileformat.i…

  berki

  1 replies

  11 years, 6 months ago

  By: Phil Parkin

• Create SQL table from an Excel spreadsheet

  Is there a way using SSIS to create a SQL table based on the headers of an Excel workbook/sheet? Th…

  pnr8uk

  6 replies

  11 years, 6 months ago

  By: pnr8uk

• SSIS Excel Source Versus Unicode FlatFile Source

  when we point a unicode flatfile(DT_WSTR),external columns remain DT_WSTR, but output columns autom…

  avinash.818

  1 replies

  11 years, 6 months ago

  By: MMartin1

• ERROR when Executing a Job within SQL Server Agent from an SSIS package. SQL Server 2012, Visual Studio 2010

  Hello, I created an SSIS package within Visual Studio 2010 that takes data from cURL, exports to a …

  calebf

  7 replies

  11 years, 6 months ago

  By: calebf

• Multiple excel files data to single table

  I have two excel files with common columns but all the columns does not map to sql table. I am havi…

  susmitha117

  5 replies

  11 years, 6 months ago

  By: SQLRNNR

• ADO.Net Source in ssis 2005

  I dont see ado.net under Data flow sources in ssis 2005. How do i bring this source? Help

  scuby.me

  2 replies

  11 years, 6 months ago

  By: Koen Verbeeck

• How to reflect changes in Oracle db tables into SQL Server db?

  Hi, Is there a way to just import changes to tables in a live (Oracle 11g) database into SQL Server…

  lindsayscott23

  6 replies

  11 years, 6 months ago

  By: lindsayscott23

• Control Flow: differentiating between source files already processed/not processed

  I have to import zip files every day from a vendors ftp site who leaves the last 7 days on the ftp …

  KoldCoffee

  10 replies

  11 years, 6 months ago

  By: Maninder Kumar

• Datatype conversion issue

  i have a ssis package imports msaccess data to sql. i am getting an error as below. I checked the y…

  scuby.me

  3 replies

  11 years, 6 months ago

  By: Jack Corbett

• Excel import - force column to be string (SSIS 2005)

  I know this topic has been covered in a few places - but it reoccurs regularly and I have NOT got a…

  dwill

  23 replies

  11 years, 6 months ago

  By: Zahid Naseer

• Force SSIS package to return success status to Agent Job

  Hi All, I have a master SSIS package which calls multiple other SSIS packages. One of these sub-pa…

  David.Lester

  2 replies

  11 years, 6 months ago

  By: David.Lester

• In control flow: how to create date time stamp to use in downstream tasks.

  I have a control flow which unzips 14 unique files, drops them into a process folder, and then afte…

  KoldCoffee

  4 replies

  11 years, 6 months ago

  By: KoldCoffee