SSIS Oledb Destination Not Writing Any Rows
Nov 20, 2007
I have a Dataflow task with oledb source that is using SqlCommand to retrieve data and oledb destination to write the source output to a table. I have access to both the source and destination databases.
The problem is the destination component is not writing any rows to the destination table eventhough the Source component is returning rows (I can see them in the Preview and the source database table as well).
I'm using "Table/View Name from Variable" for destination.
The Package executes without any errors but there is no output.
Any ideas?
Thanks.
View 7 Replies
ADVERTISEMENT
Apr 11, 2007
Hi
I have a made a simple mapping connecting source and destination on SQL server on local box. I am getting ~36K rows/min as the thru put. I only want to use ole db destination data access mode as SQL query (dnt want to use fast load).
I am doing this test in order to set a bench mark for a custom component which i have developed. With this result i can figure out how much time my custom component is taking.
Experts, please let me know your views on the thru put which i am getting is it good bad or ok with the scenario i am testing and also if there are some ways to improve it.
Thanks,
Vipul
View 12 Replies
View Related
Jan 1, 2007
hello
i am performing the ETL on the as400 db2 database using ms- dts,ssis.
i have built the connection b/w as400 and source to extract data from as400 to staging means in dataflow . when i have built the oledb connction for loading data to destination as oledb destination.then it will connct successfully to the db2 as destination but when execute the task then it not load data , and give provider error.
what can be good solution for this.
can u solve it.
rep plz.
View 2 Replies
View Related
Oct 8, 2015
I have requirement to update/insert the DPID based on the address which are passed as an input values.There are more than one address at the same time and I configured to get the address from the query which are correct and output of the address values will be stored as system object variable.I am then passing the system object variable to for each loop container and I have configured the collection and variable mappings as a variable for each input value.
when I pass the value manually to the web service task it works correctly.When I pass it as a variable to web service task it doesn't return any value.I have a data flow task which converts the ouput from web service task using the xml source converts it to oledb destination.I don't see any rows being written to the target table.
View 6 Replies
View Related
Feb 19, 2015
I have a SSIS pkg that gets data from SQL and do data conversion and Insert into OLE db AS400 destination, There is a flag column in SQL table , that has to be updated to true, once the records are inserted in AS400 how do i do that in SSIS
SQL oledb ---------> dataConversion ---------------> AS400 OLE db Destination
|
update SQL table Flag column<---------------------------------|
View 9 Replies
View Related
Oct 10, 2006
Hi all,
I got an error when i do an OLE db Source pointing to an sql 2000 database and executing a sql query inside the OLE Source. The ole source will point to an OLE DB destination which is an sql 2005 database.
But i got the below error:
Error at Data Flow Task [OLE DB Destination [245]]: the column firstname cannot be processed because more than one code page (936 and 1252) are specified for it.
Error at Data Flow Task [DTS.Pipeline]: "component "OLE DB destination" (245)" failed validation and returned validation status "VS_ISBROKEN".
Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation.
Error at Data Flow TaSK: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
View 5 Replies
View Related
Aug 1, 2006
I have a SSIS package that reads data from a dump table, runs a custom script that takes date data and converts it to the correct format or nulls and formats amt fields to currency, then inserts it to a new table. The new table redirects insert errors. This process worked fine until about 3 weeks ago. I am processing just under 6 million rows, with 460,000 or so insert errors that did give error column and code.
Now, I am getting 1.5 million errors. and nothing has changed, to my knowledge. I receive the following information.
Error Code -1071607685 Error Column 0 Error Desc No status is available.
The only thing I can find for the above error code is
DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE
To add to the confusion, I can not see any errors in the data written to the error table. It appears that after a certain point is reached in the processing, everything, or most records, error out.
Any help is appreciated.
Thanks
Derrick
View 21 Replies
View Related
Apr 16, 2014
I have an source file and i have to load it into the data base by changing datatype of the columns in ssis
View 1 Replies
View Related
Jul 21, 2007
I am copying a simple table from a Sql Server 2005 database to an *.sdf mobile database.
I am brand new to SSIS and I am probably doing something wrong. But after executing the SSIS package all the rows and all the fields are NULL in the destination database. I put a datagrid viewer between the OLE DB Source and the Sql Server compact edition destination and I can see the real data which is obviously not ALL NULL.
Does anyone have a clue as to why it would be doing this?
Any help would be much appreciated.
Thanks...
View 1 Replies
View Related
Jul 5, 2006
I am using OLE DB Destination to write data to a SQL server database. However, nothing is written to the database though there is no error reported. See the following output:
SSIS package "Tbl_Dim_Dates.dtsx" starting.
Information: 0x4004300A at Tbl_Dim_Dates, DTS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Tbl_Dim_Dates, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Tbl_Dim_Dates, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Tbl_Dim_Dates, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Tbl_Dim_Dates, DTS.Pipeline: Execute phase is beginning.
Information: 0x402090DF at Tbl_Dim_Dates, OLE DB Destination [2396]: The final commit for the data insertion has started.
Information: 0x402090E0 at Tbl_Dim_Dates, OLE DB Destination [2396]: The final commit for the data insertion has ended.
Information: 0x40043008 at Tbl_Dim_Dates, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x40043009 at Tbl_Dim_Dates, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Tbl_Dim_Dates, DTS.Pipeline: "component "Date extract to file" (924)" wrote 3652 rows.
Information: 0x4004300B at Tbl_Dim_Dates, DTS.Pipeline: "component "Raw File Destination" (2518)" wrote 3652 rows.
Information: 0x4004300B at Tbl_Dim_Dates, DTS.Pipeline: "component "OLE DB Destination" (2396)" wrote 3652 rows.
SSIS package "Tbl_Dim_Dates.dtsx" finished: Success.
The program '[2708] Tbl_Dim_Dates.dtsx: DTS' has exited with code 0 (0x0).
View 4 Replies
View Related
Sep 21, 2006
Hi,
I have a data flow task that performs an "upsert" by directing successful rows from a Lookup to an OLE DB Command that updates rows and unsuccessful rows (Lookup error output) to an OLE DB Destination for insertion.
The problem is that execution hangs when both tasks update/insert into the same table (execution is still hung after 20 minutes). Modifying the OLE DB Destination to insert into a different table succeeds (execution completese within 2 minutes). Replacing the OLE DB Destination with a Row Count transformation also works.
Could this be due to a table-locking issue? Any suggestions?
Thanks
ray
View 6 Replies
View Related
Mar 15, 2007
Hi All,
We want to take advantage of the performance benefit provided by SQL server destination in our packages. We are using a configuration variable to specify whether the SQL Server is remote or local to the packages. We are using a conditional split to redirect the process to either SQL Server destination or OLEDB destination based on the value of the variable. Is there any performance benefit in doing such a thing as it seems that the connection is made in both the paths during the runtime instead of in one particular path alone.
Thanks in advance
Kumbs
View 1 Replies
View Related
Apr 10, 2008
Good day,
I'm working with SSIS on SQL Server 2005 and trying to update a table with a OLEDB Destination.
The table I'm updating does not accept Null values. I've tried to update the table in several ways.
Using a "Table or view - Fast Load " Data Access Mode. I get the can't load data due to "Null values are not accepted in field xyz"
Using SQL Command text. Used the isnull function on all null fields and the "Failure inserting into the Read Only Column xyz"
I've check the properties of the table I'm writing to. I've check my user credentials.
Can any of you shed some light on what I'm missing.
thanks
View 1 Replies
View Related
Feb 5, 2006
Hello,
I am a beginner for the SSIS and would like to know how to modify the OLDEB Destination connectionString property at run time like using "for each loop container".
My requirement is that I have a single source which would be Sql Server 2005 and my destination is in MS-Access database residing in 100 places. I do not want to manually design in the data flow to these 100 destinations.
I have all the destinations stored in a table and would like to pick these destinations from the table and loop through the same at run time by modifying destination connection string.
I have planned using dts but the for each loop container does not work through as it works with flat file connection manager , but does not go well with OLDEB connection.
Highly appreciate any help in this regard.
Regards
Sameer
View 10 Replies
View Related
Nov 15, 2006
Situation
I have a package with an execute SQL task that truncates the destination table as the first step in the control flow and a data flow task that reads data from a flat file and loads a sql server table.
Once in a while the package bombs because it cannot get access to the flat file. The end result is that the table is empty because the truncate runs first. Obviously, I need to address the file contention, but I was wondering how to address this issue in general since anything that causes the data flow to blow up would leave the table empty.
I would rather have the table with day old data than empty, since it is not mission critical and the users can at least look at yesterday's data as opposed to nothing.
Question
Is there a way to specify a "load replace" on the OLEDB destination? I haven't seen one and I guess it makes sense because the data flow task transformations run row by row.
The only solution that I have come up with is to have the following on the control flow:
1) data flow task which reads flat file and loads a temp table
2) execute sql task to truncate the "real" destination
3) data flow task to move data from temp table to real table.
Anyone else come up with a better way to handle this?
Thanks!!
View 3 Replies
View Related
Sep 18, 2006
I'm unable to figure out how to write a column header to my flat file destination. My source is a OLE DB SQL query and I need the column names as a header row in my text file destination. This seems easy but the closet I can find is hardcoding the column header row in the header property. Is this the only option?
Thanks
View 1 Replies
View Related
Dec 6, 2005
I have a dataflow task that reads a large amount of data from a textfile source. At the same time i load a mainbook which holds totals for each segment. In the end of that dataflow task i check for difference with a conditional split ([amountmainbook] - [amountsource]) > 1 which points to rowcount task that writes to a variable.
View 5 Replies
View Related
Feb 16, 2007
I am using a foreach loop, with the data from an ado recordset, which contains the table name that I wish to write data to an OLEDB data dest. The table names are retrieved from an execute sql task in the an object var. Within the foreach loop, for each table name, I then use a datareader to an ado.net source to pull data from that table, via an expression construct into a variable - i.e. "select * from " + @[User::table_name]. This works fine for the first table, in which mappings are setup using the SSIS design environment. The data is retrieved. I then use a variable and set the data access mode for the oledb destination to "Table name or view name variable". This also saves data fine for the first table in the loop in the oledb dest. When the next table name is retrieved from the ado provider in the foreach loop, the datareader fails, as it still thinks the metadata mappings are from the first table, which was used for the mapping in the design environment. I.E. FIN_CLASS is a column from the first table in the loop.
Error: 0xC0202005 at Data Flow Task, DataReader Source [7181]: Column "FIN_CLASS" cannot be found at the datasource.
I have set the following properties, that I thought (in my feeble mind), are supposed to avoid that behavior. For the datareader, I set ValidateExternalMetadata to false, and for the data flow task (container for the datareader), I set DelayValidation to true. These settings, according to the doc, are supposed to evaluate metadata for the datareader source at runtime (not design time), so that the column metadata is dynamic, and so that the subsequent oledb destination can use the "data access mode" for the oledb destination of "Table name or view name variable".
If I cannot get this to work, I have 2 options: Use OPENQUERY via dynamic t-sql statements, OR create 30 separate flows in SSIS - one for each table - not looking forward to that one.
View 5 Replies
View Related
Apr 11, 2007
Hi
How can commit interval for OLE DB destination be set when the data access mode is not "fast load".
What happens in oledb destination in case of a failure in package? How does the roll back happens. I mean how is the commit point set in oledb destination? I know about the transaction options which are at the package level.
Thanks,
Vipul
View 4 Replies
View Related
Nov 9, 2006
Hi,
why Table or View €“ fast load option in Data Access mode is not listed when we connect Oracle Database in the OLEDB Destination.
Thanks
Jegan
View 3 Replies
View Related
Oct 5, 2007
Hi,
I have a strange problem, which I never encountered earlier, I have a data flow which has one source and multiple destinations, I am also using multicast and derived column transformations too, however when I run the package (either from cmd line or designer) the data flow task hangs when it comes to inserting data into the target tables. and it keeps waiting forever. Initialy I thought it was my data set , however if with very few records the problem persists. I have also tried removing the table lock from the destination , increasing the rows per batch to 10000 and commit size to 10000 but to no change. I am using the fast load option within my destination. When I run sp_who2 on my Management Studio I see that the status of all the processes is sleeping and the command is "awaiting command" , any help appreciated.
Thanks
View 4 Replies
View Related
Jun 29, 2006
Overview of my scenario: i have an SQL table with 10 columns. I read data off a csv flat file source and insert / update them into the sql. No problems there.
Now, after the 10th column, the columns are variable from site to site. Ie, for any customer, the first 10 columns are the same but the following 'n' number of columns can be different.
I'm already able to detect what are the 'custom' columns from the source db and can programmatically add / modify the columns to the destination sql tables when SSIS runs.
My problem now is, i have the flat file source with 'fixed' and 'custom' columns together, and my sql table is ready to receive them, but i don't have the proper column mappings in my SSIS package. I only have mappings for the 'fixed' columns.
How can i programmatically 'add' these mappings to my data source and subsequently my oledb destination?
What strategy should i use? Open for anyone's suggestions or ideas.
Thanks.
View 4 Replies
View Related
Mar 13, 2008
Hi,
I have a simple loading to excel destination. It has 900,000 records. In 66,000+ records, i has an error
Error: 0xC0202009 at Data Flow Task, Excel Destination [3286]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
Error: 0xC0209029 at Data Flow Task, Excel Destination [3286]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Excel Destination Input" (3297)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Excel Destination Input" (3297)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Excel Destination" (3286) 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. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0209029. There may be error messages posted before this with more information on why the thread has exited.
Error: 0xC02020C4 at Data Flow Task, OLE DB Source [1]: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.
I assume that this is caused by the no. of records im loading since the .xls file can only contain 65,000 records.... i tried using the .xlsx file but i guess it only accepts .xls.
What's the alternative to load to excel 2005 with this numbers of records?
thanks.
cherriesh
View 1 Replies
View Related
May 2, 2008
I have a dataflow in my SSIS Package that is supposed to transfer over all the rows from a SQL server table. I am selecting columns from the SQL table and there is a total of 1603 rows. I am only getting 354 rows in the DB2 destination table. I have turned on SQL logging and specifically the BufferSizeTuning option for this dataflow. in the Sysdtslog90 table I see messages about the "Rows in buffer type 0 would cause a buffer size greater than the configured maximum. There will only be 1249 rows in buffers of this type" and "Rows in buffer type 3 would cause a buffer size greater than the configured maximum. There will only be 1251 rows in buffers of this type"
I have the following set in the Dataflow properties.
DefaultMaxBufferRows = 5000
DefaultBufferSize = 10485760
The server is windows server 2003 x64, SQL Server 2005 sp1 resides on this server where the SSIS packages are running also. 12gb of ram.
Any suggestions how i can get all the rows transferred, what is Buffer Type 0 and 3? this doesnt seem like a lot of rows (1603 total) to hit a DB2 destination with.
Any settings I would need to check in the Connection Manager? I am using Native OLE DBMicrosoft OLE DB Provider for DB2.
View 4 Replies
View Related
Nov 8, 2006
Hi,
I am trying to programmatically in C# create FlatFileSource and OleDB Destination?
I would like your help.... How about column mapping.
I would appreciate your reply.....
View 1 Replies
View Related
Mar 11, 2008
i am trying to load almost 15 csv files to my oledb destination can i use for each container to map the source columns dynamically to destination table during data flow task
FLAT FILE SOURCE ------------------------------------ > OLEDB DESTINATION
1.Product.csv Product Table (Different mappings between columns)
2.Depot.csv
...
....
No.of columns also differ in csv files...
P.S. : Dont ask to me to do individual data flow task for each csv files.
View 4 Replies
View Related
Aug 28, 2007
Hi ,
I have a Package Consisting of the following (tried to portray the flow below)
1) OLE DB Source (Which I set the sql command for in code)
|
/
2) Rowcount Transform (Counts the Source Records)
|
/
3) Derived Column (Adds An AuditJobID ,ExecutionStartDate)
|
/
4) Conditional Split (Splits New and Updated Record - My Implementation of SCD)
/
/ /
5) Rowcount Transform (Counts the New Records) Rowcount Transform (Counts Update Records)
/
/ /
6) OLEDB Destination OLEDB Update Command
I am trying to map the columns in the "OLEDB Destination" with c# ,with the following
IDTSInput90 input = oledbDestination.InputCollection[0];
IDTSVirtualInput90 vInput = input.GetVirtualInput();
As soon as I call the input.GetVirtualInput(); method I get a com exception ,Seem that I am missing a
VirtualInputColumnCollection on the component ,but can't seem to figure out why.
When I drop the all the other components and only keep the OLEDb Source and OLEDB Destination with a flow between them , the call to input.GetVirtualInput() doe not fail with a com exception and I can mapping normally
I really need some guidance on the above.
Regards
Cedric
View 4 Replies
View Related
Feb 28, 2006
Hello,
I've searched around and can't find any references to the problem I'm having. I'd appreciate any ideas or input.
I'm trying to use the OLEDB Destination for an insert at the end of a long data flow. I need to parameterize the input, and for some of the columns I need to use literal values instead of parameters. It seems like this should be the most common thing in the world, but I'm at a loss to get it to work.
I type in the SQL statement just like I would with an OLEDB Command transformation, with the ? character for the appropriate columns in the VALUES clause. However, when I try to use Parse Query I get this error:
"Parameter Information cannot be derived from SQL statements. Set parameter information before preparing command."
OK, so I start searching around for ways to set the parameter information. Nada. On the Mappings tab the parameter list is empty. I check MSDN and it says this:
"If you have entered a parameterized query by using ? as a parameter placeholder in the query text, use the Set Query Parameters dialog box to map query input parameters to package variables."
Set Query Parameters dialog box? I don't see this anywhere. What am I missing?
The options with the SQL Server Destination seem even more limited, as I don't see any way to use a SQL statement or stored procedure.
For the moment I'm going to stub this off with an OLEDB Command transformation with a downstream Trash desintation, but hopefully that's only going to be temporary.
Thanks,
Dan
View 6 Replies
View Related
Oct 30, 2006
I am trying to export data from a query in SQL Server 2005 SSIS to a flat file destination. Everything works fine except the rows returned from my query are written to the flat file in one long string (i.e., without line breaks). I have tried appending a new line character to the rows returned from the query but that only throws an error when the package is executed. My rows returned from the query are 133 characters wide (essentially only one column per row) so I have set the properties accordingly for a fixed width file format with 133 character wide rows.
Any suggestions or ideas on how to correct this would be greatly appreciated.
Thank you,
Michael
View 3 Replies
View Related
Nov 9, 2007
Hello all,
I was trying to run a test to write a ebcdic file out with a comp - 3 number (testing this for other people) and have run into a problem writing the string out to the flat file destination. I have the following script component:
Code Block
' Microsoft SQL Server Integration Services user script component
' This is your new script component in Microsoft Visual Basic .NET
' ScriptMain is the entrypoint class for script components
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Public Class ScriptMain
Inherits UserComponent
Public Overrides Sub CreateNewOutputRows()
'
' Add rows by calling AddRow method on member variable called "Buffer"
' E.g., MyOutputBuffer.AddRow() if your output was named "My Output"
'
Output0Buffer.AddRow()
Dim myByteArray() As Byte = {&H12, &H34, &H56, &H7F}
Output0Buffer.myByteStream = myByteArray
Output0Buffer.myString = "ABCD"
Output0Buffer.myString2 = "B123"
myByteArray = Nothing
End Sub
End Class
I have added myByteStream as a DT_BYTES length 4, myString as (DT_STR, 4, 37) and myString2 as (DT_STR, 4, 37) to the output 0 buffer.
I then add a flat file destination with code set 37 (ebcdic us / canda) with the corresponding columns using fixed width.
When i place a dataviewer on the line between the two the output looks as I expect ("0x12 0x34 0x56 0x7F", "ABCD", "B123"). However, when it gets to the flat file destination it errors out with the following:
Code Block
[Flat File Destination [54]] Error: Data conversion failed. The data conversion for column "myByteStream" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
If i increase the size of the byte stream (say, to 50) the error goes away but I am left with the string "1234567F" instead of the appropriate hex values. Any clues on how to go about this? I obviously don't care if it gets transferred to "readable" text as this is supposed to be a binary stream, thus the no match in target page seems superfulous but is probably what is causing the problems.
NOTE: this is relating to the following thread (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2300539&SiteID=1) in that I am trying to determine why these people are not seeing the "UseBinaryFormat" when importing an EBCDIC file (i see this fine when i use an ftp'd file, but it auto converts to ascii) with comp-3 values. I also see the "UseBinaryFormat" when I am importing a regular EBCDIC file which I create that has no import errors with zoned decimals.
View 5 Replies
View Related
Jun 8, 2007
Hello,
My OLE DB Source is getting data from the following column types:
ID varchar(50), Name varchar(100), Date datetime, Currency char(3), Cost numeric(30,10)
My OLE DB Source outputs my information in the following order when I click Preview:
ID Name Date Currency Cost
When I connect the OLE DB Sorce to a Flat File Destination, it comes out in the wrong order.When I examine the "line" between them (Data Flow Path Editor) I get:
Currency DT_STR Length: 3
ID DT_STR Lenght: 50
Name DT_STR Lenght: 100
Date DT_DBTIMESTAMP
Cost DT_NUMERIC
What is the easiest way for me to change this so the Flat File Destination will output my data in the same order as the OLE DB Source:
ID Name Date Currency Cost
Thank you very much!
View 6 Replies
View Related
Feb 11, 2007
I have an OLE-DB Command transformation that inserts a row. If the insert SQL command fails for some reason, I use the "Redirect Row" option to send the row to a script component. Inthere, I get the error description into a string variable in order to log the error into an error table.
For example, if a primary key violation arises, I would like the error description to be "The data value violates integrity constraints". I get it using the ComponentMetadata.GetErrorDescription. When I use the "table or view mode", I get the error description above without any problem. But If I use the "table or view fast load", the description is something like "No status available". But, If I use the error output to fail the component, in the OnError, I get the right error description. Is there a way to have both behaviour, I mean, to be able to redirect error rows to an output and have the cotrrect error description (like the one in OnError event handler) using fast load mode?
Thank you!
Ccote
View 5 Replies
View Related
Nov 9, 2006
Hi
Inside a data flow task, i have a oledb source and destination. In my situation, I need to pull data from a table in the source, but also hard code some columns myself, which means my source is a blend of data from table, hard coded data, which will then have to be mapped to columns in oledb destination. Does anyone which option to choose in the oledb source dropdown for the data access mode. Keep in mind, i do need to run a a select query, as well as get data from a table. Is it possible to use multiple oledb sources and connect to one destination, because that is really what intend to do here. I am not sure how it will work, or even if its possible. Basically my source access mode needs to be a blend of sql command and table columns, how would that be implemented? Any help or advice is appreciated.
MA
View 4 Replies
View Related
