could any one tell me how could i load data from EXCEl file to XML
if some one could provide with appropriate link then it will b a great help
i have taken Excel source part is completed ..but what to do after that..
View Complete Post
I am looking for best solution to perform incremental data load from MySQL database to SQL Server 2008. I tried to follow instructions from articles on incremental data load in SSIS using MD5 hashes but I failed to make connection in Lookup transformation
editor between MySQL Id (4 byte unsigned integer) and Id in SQl Server 2008 table which is bigint. i tried to add data conversion and convert MySQl Id to string. It works fine when you map this field directly to OLEDB destination but in Lookup
component it failed.
Any input greatly appriciated.
1.how to fastload data to an Oracle destination.
2.what if i need to add an identity column to the destination table.
Is a sequence needed? how can ssis2008 handle that?
thanks in advance.
Hello Every One,
I have a scenario in which i am executing a Stored Procedure which returned a result set.
I want to create a Excel file [name_date_time] dynamically, and fill result set data into Excel file. And then finally sent Excel file to Specific user[Email ID].
Point is that the excel file should have unique name so i want to give name as name_date_time.
So every time when package run new file is created with unique name.
Can any one suggest me who to create Excel file and fill result set data into Excel file.
And then finally send that Excel file ?
I have got an Excel spreadsheet with a Data Connection that I want to import into SSIS. The problem is that the Data Connection does not seem to run at the time the file is imported, so it only calls "old" data.
How can I set SSIS up to run the Data Connection first, or is there something I need to change in my Excel spreadsheet setup?
When a person opens the Excel file normally, they first need to "Enable" the Data Connection in the Security Settings. Once that is done the data will update immediately. I wonder if that is something I somehow need to change to make it work in SSIS?
Hi guys, I am trying to use SSIS for the first time. What I am hoping to do is set up a scheduled job that will get SSIS to read an Excel spreadsheet on a regular basis and import the data out of it into an SQL Server database. Now my Excel spreadsheet uses
a Data Connection to a different source and I want the data to be refreshed before SSIS imports it. Is that possible?
The problem I am facing right now is that the Data Connection does not seem to run before SSIS import the data. It keeps importing the old data that was sitting in the Excel spread sheet at the time it was saved last.
Is there any way I can tell SSIS to run the data connection first? Or is there something I need to do in my Excel file to ensure the connection is run?
By the way: the Excel file is set up to run the Data Connection immediately when it is opened normally in Excel, but the general user always first has to go into the Security Settings and enable Data Connections.
Thanks for the help!
I have an excel file (xlsx) containing a table :
Once I launched my ssis task (successfully) to insert data in it, it is actually append after the table :
So I am looking for a way to insert into the table and expand it with the data. I hope someone could help me.
Thank you !
I would like to identifying the source & destination tables of the data flow or the transformation task.
I need to create a custom component which i can put into existing packages which can do some validation.
Please suggest ways i can accomplish this.
I am getting the following error In the data flow task , its failed at ole db destination. Please help me as soon as possible. Thanks in advance
Error: 0xC0202009 at Dataflow task, OLE DB Destination: An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Error: 0xC0209029 at Dataflow task, OLE DB Destination : The "input "OLE DB Destination Input" (9491)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (9491)" specifies failure on error.
An error occurred on the specified object of the specified component.
Error: 0xC0047022 at Dataflow task, DTS.Pipeline: The ProcessInput method on component "OLE DB Destination" (9478) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component,
but the error is fatal and will cause the Data Flow task to stop running.
Error: 0xC0047021 at Dataflow task, DTS.Pipelin
Hi, I have an issue where I am trying to reduce the time it takes to load SSAS cube data to SQL table using SSIS.
Within a Data flow task I have an OEDB source where in I select "command from variable" where the variable holds the dynamic MDX. I then have a data conv, lookup, derived transform and OLEDB destination respectively.
However the load takes some 2.5 hours for inserting 1 million rows. Any pointers as to how I may reduce it?
I have around 110 columns returned from the source MDX and it has 1 million rows as I said.
the lookup is to get a key not present in cube. since the lookup table is huge, i am using partial cache and the derived column transform just adds a string (hard coded) value of "ETL" and a time using getdate(). Data conversion is for the obvious conv for
ntext data (returned from MDX to corresponding datatypes in SQL table...I have the fast load option in the OLEDB destination.
I can't use openquery though. Let me know what may I do to reduce the load time.
I am importing data from excel files.
When the import get to the last row in the spreadsheet it crashes.
Is there are reason for this?