January 7, 2016 at 8:48 am
Friends , I need to read files * .db and * .px ( paradox ) through a process of SSIS ( dtsx ) , so far I could not figure out how to read them. This is urgent need to deliver the project.
I tried to install several free components and I have not worked properly
January 7, 2016 at 8:53 am
dramon14 (1/7/2016)
Friends , I need to read files * .db and * .px ( paradox ) through a process of SSIS ( dtsx ) , so far I could not figure out how to read them. This is urgent need to deliver the project.I tried to install several free components and I have not worked properly
Ignoring SSIS for the moment, can you create a working ODBC connection?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 7, 2016 at 10:00 am
get this error
---------------------------
Script Task
---------------------------
System.Data.Odbc.OdbcException: ERROR [42S02] [Microsoft][Controlador ODBC Paradox] El motor de base de datos Microsoft Jet no pudo encontrar el objeto 'CACCOUNTS'. Asegúrese de que el objeto existe, y que ha escrito el nombre y la ruta de acceso al objeto correctamente.
en System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
en System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
en System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
en System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
en System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior)
en System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
en System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
en System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
en System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
en ScriptTask_52ed9cadfdc9485891d35cc97aa4fde8.ScriptMain.Main() en dts://Scripts/ScriptTask_52ed9cadfdc9485891d35cc97aa4fde8/ScriptMain:línea 45
---------------------------
Aceptar
---------------------------
and this is the code
Public Class ScriptMain
Public Sub Main()
Dim conn As OdbcConnection
Dim connectionString As String
Dim sql As String
connectionString = "Dsn=datos1;"
conn = New OdbcConnection(connectionString)
Try
conn.Open()
MsgBox("Connection Open ! ")
sql = "SELECT * FROM CACCOUNTS"
Dim da As New Odbc.OdbcDataAdapter(sql, conn)
Dim ds As New DataSet()
da.Fill(ds, "CACCOUNTS")
Dim oleDA As New OleDbDataAdapter
Dim dt As New DataTable
Dim col As DataColumn
Dim row As DataRow
Dim sMsg As String
oleDA.Fill(dt, da)
For Each row In dt.Rows
For Each col In dt.Columns
sMsg = sMsg & col.ColumnName & ": " & _
row(col.Ordinal).ToString & vbCrLf
Next
MsgBox(sMsg)
sMsg = ""
Next
conn.Close()
conn.Dispose()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
Dts.TaskResult = Dts.Results.Success
End Sub
End Class
January 7, 2016 at 10:31 am
Perhaps you would be so good as to re-read my question & try again.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 7, 2016 at 11:56 am
create the ODBC as recommended you , and when I came out successful connection test . for that reason it implements code in the application to perform validation of the call to the tables or files and shows me the message of the previous post
January 7, 2016 at 12:36 pm
dramon14 (1/7/2016)
create the ODBC as recommended you , and when I came out successful connection test . for that reason it implements code in the application to perform validation of the call to the tables or files and shows me the message of the previous post
Instead of doing everything in code, why not create a connection manager in SSIS which uses your (tested) DSN?
Secondly, why are you using DataAdaptors? There is no need for any of this in SSIS ... in fact, by doing so, you are losing some of the benefits of using SSIS.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 7, 2016 at 1:07 pm
actually i need is to implement a SSIS to perform the massive upload files to an Oracle database. are 104 files in total and according to its contents must insert them into tables in the database;
and I should advance an ODBC for each file I would stay impossible in the production server environment. why should I create a totally dynamic process to make a single call to the folder and file to call each independently
January 7, 2016 at 1:16 pm
dramon14 (1/7/2016)
actually i need is to implement a SSIS to perform the massive upload files to an Oracle database. are 104 files in total and according to its contents must insert them into tables in the database;and I should advance an ODBC for each file I would stay impossible in the production server environment. why should I create a totally dynamic process to make a single call to the folder and file to call each independently
I don't understand this.
If your intention is to code everything dynamically, you may as well put SSIS to one side and write it natively in C#.
Otherwise, sounds like your packages (I would not do this in a single package) will need 104 data flow tasks, in total.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 7, 2016 at 1:53 pm
because the process must be automatic, you must run at 7am and be the data must be ready in the database for analysis. I also thought the process by creating an application but the user does not want any interaction. To view the information only ready for processing into their applications.
Additional the user reports that there is the possibility that the files can increases daily or can receiveb the normal number the files
January 7, 2016 at 2:40 pm
dramon14 (1/7/2016)
because the process must be automatic, you must run at 7am and be the data must be ready in the database for analysis. I also thought the process by creating an application but the user does not want any interaction. To view the information only ready for processing into their applications.Additional the user reports that there is the possibility that the files can increases daily or can receiveb the normal number the files
This answer does not explain the questions asked.
I feel the force weakening.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
January 8, 2016 at 6:43 am
Yes sir, that's my intention, to create fully dynamic process for reading files and perform the Load to be content with the corresponding tables in the database.
I thought the same about creating connection file for files in separate steps but the environment manager asked me to create a single process for issue of licenses execution of automated processes.
January 8, 2016 at 6:54 am
dramon14 (1/8/2016)
Yes sir, that's my intention, to create fully dynamic process for reading files and perform the Load to be content with the corresponding tables in the database.I thought the same about creating connection file for files in separate steps but the environment manager asked me to create a single process for issue of licenses execution of automated processes.
"Fully dynamic" and "SSIS" don't go well together.
SSIS is not the tool you are looking for.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 8, 2016 at 8:45 am
Phil Parkin (1/8/2016)
dramon14 (1/8/2016)
Yes sir, that's my intention, to create fully dynamic process for reading files and perform the Load to be content with the corresponding tables in the database.I thought the same about creating connection file for files in separate steps but the environment manager asked me to create a single process for issue of licenses execution of automated processes.
"Fully dynamic" and "SSIS" don't go well together.
SSIS is not the tool you are looking for.
I agree with Phil.
I could do fully dynamic with SSIS using mainly script tasks, but if I were to do that, then why bother with SSIS? I might as well go with a pure dot Net project.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
January 12, 2016 at 6:44 am
i know this project would come faster by .net . but in the company that I work, they develop in java to web application and .net ( SSIS ) for processes applications from automatic load mass . those are the constraints that I have for the implementation of the process.
Additional asked me to do this was so, beacuse do not want user intervention in the process of load the information.
January 12, 2016 at 6:54 am
yes sir, this is mi intention. is to code everything dynamically from a DTSX
Why not use a native C# application? What benefits do you think that SSIS is giving you?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply