balasach82 (5/15/2011)

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...

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.

Have you checked permissions?

Look at the following links for they might provide you with some insight to your problem:

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/e90c853b-6018-41b0-9dd1-abd2ac872f16/

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/fd5d19da-5cf5-45a9-bc77-7849a9565714

Check out the folowing links:

http://www.sql-server-helper.com/tips/date-formats.aspx

http://technet.microsoft.com/en-us/library/ms187819.aspx

Alternatives to a Linked Server are OPENROWSET and OPENDATASOURCE.

http://msdn.microsoft.com/en-us/library/ms190312.aspx

http://msdn.microsoft.com/en-us/library/ms179856.aspx

http://decipherinfosys.wordpress.com/2007/07/16/linked-servers-in-sql-server/

This is a SQL Server forum (Administering 2008).

What do you have so far?

You could start by reading the Microsoft Press Books for SQL Server 2008 and start Googling.

I'm not really clear on what you are trying to do and why you need 3 Servers?

Could you be a little more specific?

You can't reference a Local #Temp Table outside the current scope Stored Procedure, etc.

In SQL Server you can create Global Temp Table specify and you can reference it outside of...

Did you see the following?

Are you prepared for SQL Server performance problems?

Read Holger Schmeling's free "SQL Server Statistics" eBook to brush up on your statistics and query-optimization knowledge, and monitor...

That is correct the files go back to 2008.

The date of the files are not going to change when executed

The sysdbupg.sql performs a number of actions and you can search...

Have you tried checking the logs?

Try setting the recovery model of tempdb to simple so that the space can automatically be reclaimed.

Have you identified what part(s) is taking so much time?

Is the step to copy the file to your DR site part of the problem?

Are you compressing the files?

Check out the following example:

http://sqlserverpedia.com/blog/sql-server-bloggers/is-primary-your-default-filegroup/