Search Results: oledb

• 
  Create Access 2010 File

  Hi all. Today I want to hear your suggestions, thoughts and ideas. I have a need to dump/load information into a access file. I was trying to dynamic create file like FileName_20120126.accdb. I'm aware to some issues that I come across, while creating acc

  Author:  marcoadf     Date: 1/26/2012     Section: Forum

  tags : 2010, access, dump, file, information, load, oledb, script, task
• 
  Using a Lookup to load a Dim table

  Hi, I am trying to load dimension table that has all business keys and must use a Lookup rather than a slowly changing dimension task. So, I have an OLEDB destination and an OLEDB command coming out of the Lookup, and the first time I run the lookup I get

  Author:  user900993     Date: 8/19/2011     Section: Forum

  tags : load dimension, lookup
• 
  SSIS - "Microsoft.Jet.OLEDB.4.0" has not been registered." error in 64 bit machine

  Hi I'm using SSIS to load data from Access to SQL Server table which is 64-bit machine "Select * From OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'D:\Projects\DailyData\Jan2011.mdb';'admin';'', STG_DailyData) " Getting the below error while running the package

  Author:  meganathank     Date: 2/25/2011     Section: Forum

  tags : 64 Bit OLEDB, SSIS
• 
  connecting to oracle datasource

  Install the driver as mentioned and use data flows, I would not use linked servers as they are not predictable and can cause serious contention on your source systems and snapshot/dw databases, you can still use the OLEDB source with and OraOleDB connecti

  Author:  m3crast     Date: 3/1/2011     Section: Forum

  tags : OLEDB, Oracle, SSIS
• 
  Help with Oracle Connection

  I have a set of SSIS Packages which connects to Oracle source using MSDAORA (Microsoft OLEDB Provider for Oracle).I have added a new package to the project by copying and renaming an existing object. When I run this new package I get the following error &

  Author:  Yuvaraj     Date: 6/13/2011     Section: Forum

  tags : 64 Bit, Connection Manager, Oracle
• 
  oracle data source input in SSIS

  Thanks for your reply. I tried to debug and find what actually is causing this problem. I think "Number" datatype represents and float number. So, the corresponding column in the destination sql table is of type "Float". -The problem I found is due the ty

  Author:  am35     Date: 3/8/2011     Section: Forum
• 
  Join data from different data source

  You wouldn't need to stage the data in the OLEDB environment first. You could use a Merge Join or a Merge transformation in the data flow to combine the two sets of data and push that to the OLEDB destination. You will have to order the two source queries

  Author:  kylewalker     Date: 8/4/2011     Section: Forum

  tags : Merge, Merge Join, ssis
• 
  SSIS HELP

  You just need to pay attention if your varchar column has dot "." or comma ",". Here is an example converting varchar to float whereas the varchar column has dot instead of comma: Table I've created with varchar column (notice the dot): Now, in the packag

  Author:  marcoadf     Date: 12/4/2010     Section: Forum

  tags : data conversion, derived column, float, varchar, varchar to float
• 
  Oledb Destination Component not committing some records

  I have a SSIS package that insert the records in Staging 5 tables , and from staging tables to Main Data base Data flow task with ADO.net source and OLEDB destination is used with lookups. I am running a this package around 300 times with 50K records. Int

  Author:  xpuneet     Date: 11/21/2012     Section: Forum

  tags : Data Fow Task, OLEDB Destination
• 
  Master package running multiple instances of a single generic child package

  If all you're doing is moving data from one database to another (same table structures) may I suggest using the Data Import/Export Wizard in SSMS? Right-click a database, Tasks, Export Data. This will walk you through a wizard asking where your source is

  Author:  sqlchicken     Date: 6/14/2012     Section: Forum

  tags : Export Data
• 
  Extracting data from specific cell in Excel using Script task

  The first thought that comes to mind without digging too deeply into the code is when you're running the package - are you running it in 32-bit mode? The OLEDB Jet 4.0 drivers for Excel are 32-bit only. If you run them in 64-bit mode - I do not believe th

  Author:  KeithHyer     Date: 3/19/2013     Section: Forum

  tags : 64-bit, bids
• 
  Report Manger- The provider is not registered on the local machine.

  What's the deal with this situation, "t he 'ASEOLEDB.1' provider is not registered on the local machine"? When I try to get a data source to work on the report server/manager after deploying from out of SSRS, I get that message when trying to get a positi

  Author:  5280_SQLServer     Date: 3/14/2013     Section: Forum

  tags : Report Server Web Service, SSRS 2008 R2
• 
  oracle data source input in SSIS

  Thanks a lot. I think i can upgrade the client on my system but will have to go through a long procedure to get it done. This package was originally written in DTS and uses a "microsoft oledb provider for oracle" to connect to the oracle data source. I ha

  Author:  am35     Date: 3/9/2011     Section: Forum
• 
  Incremental Load into DataMart using SSIS or Stored Procedure across Link Server

  I would defintly use SSIS for this. It will be faster and easier to maintain. You will need a data flow with an OLEDB source and a lookup to find the matching records. Any non matching records will go to an OLEDB command transfrom that will run the delete

  Author:  MikeDavis     Date: 12/8/2010     Section: Forum

  tags : Incremental load, ssis
• 
  Incremental Update

  Hi, my Package is for Incremental Update.i developed a package for this first i just created a staging table with name Update in my database first step of my package is a sql task which is for truncate table named Update . Next i just attached this task t

  Author:  veni     Date: 7/22/2010     Section: Forum
• 
  Access OLEDB Connection Manager from ScriptTask to Execute SQL Commands

  Sometimes you may need to access OLEDB Connection Manager to execute Queries in Script Task. This article will explain you how you can do that using a very simple script.

  Author:  NayanPatel     Date: 11/24/2009     Section: Article

  tags : SSIS OLEDB Connection Manager Script Task
• 
  The ‘Microsoft.Ace.OLEDB.12.0′ Provider Is Not Registered on the Local Machine

  If you have used SSIS to move data from something like Access or more commonly Excel, it is a good possibility you have seen this error at some point: Error: The ‘Microsoft.Ace.OLEDB.12.0 ‘ provider is not registered on the local machine. The

  Author:  BradSchacht     Date: 12/14/2011     Section: Blog
• 
  SSIS OLE DB Source Using Table Variables Returns No Rows

  Let's say your building an SSIS package with a data flow to move data from one database to another. You decide to use an OLE DB Source. For your Data Access Mode you select SQL Command and copy and paste your SQL statement that you've spent all day workin

  Author:  DustinRyan     Date: 7/12/2010     Section: Blog

  tags : Dataflow returns no results, SET NOCOUNT ON
• 
  Getting Previous Row in SSIS Data Flow

  There is no native Transform built in to SSIS to get the previous row in the data flow. But with a little work you can do this and make it perform much better than a SQL cursor and you don’t have to use the dreadfully slow OLEDB Command transform. In this

  Author:  MikeDavis     Date: 8/20/2010     Section: Blog

  tags : Cursor, Data Flow, Previous Row, SSIS
• 
  Im new on SSIS, Can anyone helpme with a simple project?

  To clarify on your original problem, here's basic solution in SSIS: 1. Create new data flow 2. Create new OLEDB Source connection manager for SQL2008. For Data access mode select 'SQL command' and for SQL command text use SELECT @@SERVERNAME as ServerName

  Author:  sqlchicken     Date: 7/15/2011     Section: Forum
• 
  Dynamic SQL Command Variable Data Access with ADO.NET Source

  If you need to use an ADO.NET source you will discover that the Data access mode only gives you a choice of Table or view or a SQL command but no choice of SQL command from variable like there is in an OLEDB connection. There is a way to make the SQL comm

  Author:  timmurphy     Date: 10/3/2010     Section: Blog

  tags : ADO.NET, Variable SQL Command, SSIS
• 
  Connect to AS400 Using a Data Reader

  I recently converted a package from DTS to SSIS that had an OLEDB connection to an AS400. There wasn’t an OLEDB driver available in the environment so I ended up having to use a Data Reader with an ADO.net connection. Here are the steps if you ever need t

  Author:  timmurphy     Date: 7/11/2010     Section: Blog
• 
  DTS TO SSIS Migration

  Yes writing expressions for Perameterized Queries has Pros and Cons Pros: 1) Provider independent approach (e.g. OLEDB uses ? ADO.NEt uses @ ...and ParameterNames are different for each type of provider... its nightmare to remember all that). 2) When your

  Author:  NayanPatel     Date: 12/21/2009     Section: Forum

  tags : Execute SQL Task, Expression
• 
  SSIS 2008 Using Excel in a Lookup Tansform

  Learn how to use Excel in a lookup transform in a data flow in a data flow.

  Author:  MikeDavis     Date: 12/6/2010     Section: Article

  tags : Excel, Lookup, SSIS
• 
  SSIS Package Configurations

  This article will show you, how to configure the SSIS package.

  Author:  smartkhilit     Date: 7/12/2011     Section: Article

  tags : Configurations, SSIS, MSBI