May 15, 2011 at 7:37 am
Hi,
Is there any other way to Import PDF documents into DB2 table (BLOB) column? I tried with Import Column in SSIS, but the pdf could not be retrieved from the DB2 (maybe due to ASCII to EBCDIC conversion while loading from sql to db2).
May 15, 2011 at 9:23 am
This is a SQL Server forum (Administering 2008).
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 15, 2011 at 9:41 am
Yes accept that. But since we are using sql 2000/sql 2005 to do the import to DB2, I thought somebody would have already done something like this.
Also, I have found sqlservercentral to be the very active forum and had helped me many times in the past.:-) Anyway I would also post this in a DB2 forum.
May 15, 2011 at 9:52 am
Have you defined a Link Server or what?
Can you access Data from the SQL Server where the SSIS package resides?
Sounds like a permission issue.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 15, 2011 at 10:05 am
balasach82 (5/15/2011)
Hi,Is there any other way to Import PDF documents into DB2 table (BLOB) column? I tried with Import Column in SSIS, but the pdf could not be retrieved from the DB2 (maybe due to ASCII to EBCDIC conversion while loading from sql to db2).
What do you mean the pdf could not be retrieved?
What error did you get?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 15, 2011 at 10:08 am
I have setup a DSN connection to the DB2 server. We had access issues (something related to DDM). We fixed that and loaded the pdf. But the extraction was not successful.
The dev team informed that the extraction wasnt successful. I didnt get the specific details; will try to get the error msg.
Thanks
May 15, 2011 at 10:13 am
balasach82 (5/15/2011)
I have setup a DSN connection to the DB2 server. We had access issues (something related to DDM). We fixed that and loaded the pdf. But the extraction was not successful.
If you create a DSN then all that the means is that the Machine can connect directly to DB2.
You you access the data from the SQL Server Account that you are running the SSIS Package?
I'm assuming that you have a DB2 Data Provider in your SSIS package?
If not what do you have?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 15, 2011 at 10:21 am
balasach82 (5/15/2011)
The dev team informed that the extraction wasnt successful. I didnt get the specific details; will try to get the error msg.
Does this work in the Development environment?
Do you work in production?
Is this the first attempt to extract and load a pdf and do you have any other packages that performs the same thing.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 15, 2011 at 10:36 am
1. We are using SSIS 2005 - Connection Manager - OLD DB Provider (IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider)
2. this is in dev.
3. Yes, its our first attempt at loading pdf.
Let me know if you need further details.
May 15, 2011 at 10:43 am
What happens when you click on test connection, in the Connection Manager for the DB2 Data Provider?
Exclude the pdf, can you SELECT from any DB2 Table? Could you create a quick SSIS Package using the wizard?
Use DB2 as the Data Provider and use Excel as the destination. WHen you try to map the columns you should get a preview of the DB2 Data.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 15, 2011 at 10:54 am
Test connection succeeds.
Now, tested a select query with execute sql task,getting error:
SQL02024:TableName in USERNAME type *FILE not found......
Note: Even the Dev people who have admin access to DB2 and SQL box had got this error.. they fixed this and loaded. But I am not aware how they fixed it.
In earlier method, we used Import column task in ssis, to load pdf i.e,
OLEDB SOURCE --> IMPORT COLUMN --> OLEDB DESTINATION ...
When Mapping tab is selected, we got error that alter isnt allowed since source is an LOB
May 15, 2011 at 11:11 am
balasach82 (5/15/2011)
Test connection succeeds.Now, tested a select query with execute sql task,getting error:
SQL02024:TableName in USERNAME type *FILE not found......
Note: Even the Dev people who have admin access to DB2 and SQL box had got this error.. they fixed this and loaded. But I am not aware how they fixed it.
In earlier method, we used Import column task in ssis, to load pdf i.e,
OLEDB SOURCE --> IMPORT COLUMN --> OLEDB DESTINATION ...
When Mapping tab is selected, we got error that alter isn't allowed since source is an LOB
I never saw that error before and if you goggle on it you get no results. How about a screen shot?
Is the a DB2 Table?
Did you perform a SELECT * ?
Can you confirm that if you create a SELECT Statement that excludes that LOB the statement does not fail?
You have loaded the pdf into SQL Server I assume or wonder why you can't use a DB2 utility to load the pdf's directly into DB2?
Why are you going through SQL Server to load PDF files?
It would have been better if you had posted this in the SSIS forum. 😉
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 15, 2011 at 11:20 am
balasach82 (5/15/2011)
Hi,Is there any other way to Import PDF documents into DB2 table (BLOB) column? I tried with Import Column in SSIS, but the pdf could not be retrieved from the DB2 (maybe due to ASCII to EBCDIC conversion while loading from sql to db2).
What is the Datatype of the PDF stored in a BLOB Column on SQL Server?
What is the corresponding datatype in DB2?
Is the file stored on SQL Server as an ASCII or Binary Format?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply