Deleting the existing packages is not at all an option. Because they have several versions of the package which they would revert back if there are any issues with the...

answers:

1. Our SMTP server does not require authentication

2. Using Port 25 and it is open

3. SQL server added to the SMTP

It was working fine till recently. And what is strange...

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

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

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

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

We have to use Image datatype; thats the requirement. So if is there a way to load bytecode into image field by any means?

And what is the Style parameter you...

Thanks howard.

The downside is that I have very limited/nil front end tech knowledge. So to make my request clear: A folder has number of txt files. Package runs and loads...

Jeff,

yes, it was an revelation to me. I didnt knew abt this.

From MSDN:

"A SQL Server Compact Edition database is stored in a file with the .sdf extension"

http://msdn.microsoft.com/en-us/library/ms171986(v=SQL.90).aspx

Hi,

As far as I know, DB refresh indicates the restoring the Prod db backup onto a test server. Usually, the Test/Dev teams would require prod data to work on some...

My assumption is we can open .dtsx files (2005/2008) in text editor. Can we also open .dts (2000) files in text editor?

Actually, i have inherited a test server which has about 100+ dts. some of them have not yet been used and maybe still pointing to prod. Hence, I need to...

Thanks for the link.

As for DTS, so you are one of those lucky guys who started with SSIS?

1. 9.00.3077.00 .. i got this from the server.. so 3077 is the hotfix?

2. I want the server against which the dts/job runs..say,

Server-1 -- Prod

Server-2 -- Test

I have an...

Thanks Lutz, Gail

Gail,

Yes, I am aware of the end of support for SQL 2000. But from the MS site, and from the link Lutz gave, I gather that there...