Integration Services

• Topics

  Started by

  Posts

  Last post

• Daily CSV import to SQL - How ?

  Hi I am receiving 1 csv file daily. The schema is static and the same for each file. I have created…

  Pigger

  11 replies

  11 years, 4 months ago

  By: Jeff Moden

• Emailing rowcount from SSIS

  Hi All, I need help in automating the following process. Currently I import data from Oracle to SQL…

  smthembu

  2 replies

  11 years, 4 months ago

  By: smthembu

• Date time data conversion failure

  I am working on a project to pull data into SQL Server from flat text files. The issue I am having …

  cstg85

  2 replies

  11 years, 4 months ago

  By: cstg85

• Run SSIS package when file is placed in a folder.

  Currently, we have configured a SQL Agent task that run every 10 minute to run ssis package and che…

  azhar.iqbal499

  2 replies

  11 years, 4 months ago

  By: azhar.iqbal499

• Informatica-Style Graphical Data Lineage Tools?

  With Informatica, you graphically trace a particular column from source, through various transforma…

  imani_technology

  3 replies

  11 years, 4 months ago

  By: bbrewer 62909

• Apex SQL Doc vs. Pragmatic Works BI Documenter

  I have used Apex SQL Doc but I have not used Pragmatic Works BI Documenter. How do the two product…

  imani_technology

  5 replies

  11 years, 4 months ago

  By: bbrewer 62909

• SSIS iSeries Source Duplicates Records

  I am creating a package to read data from our production iSeries (AS/400) and copying it into our n…

  Jason Whitney

  3 replies

  11 years, 4 months ago

  By: Eirikur Eiriksson

• Polling to check for an existance of a record

  I need to check every 15 minutes for the existence of a record in a table for the current date. So …

  Welsh Corgi

  2 replies

  11 years, 4 months ago

  By: Welsh Corgi

• load multiple excel files(with different number of rows in every file) into a single table

  Hi, I have to load multiple excel files into a single table (which has 50 columns (ntext)), but an …

  bmr270

  6 replies

  11 years, 4 months ago

  By: COZYROC

• Excel Data Source Fails

  Does anyone know how to fix this problem? SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Exce…

  dwilliscp

  3 replies

  11 years, 4 months ago

  By: dwilliscp

• Problem in using Fuzzy Lookup with ms access tables.

  Hi All, Has anyone used Fuzzy Lookup with ms access tables here? I am tring to connect two Access t…

  Mr.Sahand

  5 replies

  11 years, 4 months ago

  By: Eirikur Eiriksson

• How to combine multiple tables from different databases into one and move to a new database

  I am new to SSIS 2008 Packages. I have 3 different databases on same sql server which contains ma…

  miskeens

  4 replies

  11 years, 4 months ago

  By: miskeens

• Custom Event Handler

  I'm using a script task in inside the OnVariableValueChanged event handler to catch and log variabl…

  sqlpadawan_1

  2 replies

  11 years, 4 months ago

  By: sqlpadawan_1

• SSIS capturing multiple variables

  Hello, I would be grateful if anyone could help me. I have to modify an SSIS package that someone e…

  john.brees

  20 replies

  11 years, 4 months ago

  By: john.brees

• SSIS Package fail is there a way we can set up that we get phone call instead of Email

  SSIS packages run at night and getting email is not a good option. is there a way i can set up ssis…

  mandavli

  1 replies

  11 years, 4 months ago

  By: Phil Parkin