Hi,

Add the execute DTS 200 package task first and access/add the DTS package from there. If you have migrated, then you can see the packages under SSMS, management legacy node...

Hi,

First make sure as everyone said, permission level.

Then try re-deploying your package to the server, where you want your job to run that package.

-V

Thanks for your suggestion Jim..

Thats how we did also..we keep transaction Db maintenance plan to keep backup for 3 days and we have non-transactional Db maintenance plan to keep backup...

I think I got it !!!

Search for folder and delete specific file option , folder S:\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DB1Archive , file extensio bak

and uncheck the traverse sub folder

Let me know,...

Hi,

I think this is the prblem with the deployment of your package. Redeploy your package to your server, but this time make sure check the box, rely on server storage...

Hi,

What I am saying is instead of using Excel destination, use falt file destination as dataflow destination and a Flat file connection manager (Not a interim task). At the faltfile...

Hi,

I had the same problem...We used flatfile destination connection string for excel, though the file is pointing to actual excel file and mapped the columns in the editor. If you...

soved it anyway..I unchecked keep the identity column checkbox...

Did you register the server first ?

SQL Server 2008 has better solution. Now we can declare table valued parameter.

http://technet.microsoft.com/en-us/library/bb510489(SQL.100).aspx

Hi,

You can use extended sp Exec Xp_RegRead to get the port number.

Declare @PortNumber VarChar(7)

Exec Xp_RegRead

@RootKey='HKEY_LOCAL_MACHINE',

@key='Software\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp',

@Value_Name='TcpPort',

@Value=@PortNumber OutPut

Print 'Port Number:'

Print @PortNumber

Makes sense..

Thank you,

V

You will then need to delcare where you are sending the email from:

HELO local.domain.name - dont worry too much about your local domain name although you really should use your...

Hi,

Thank you for the link.

I don't have much knowlwdge on windows side. My understading the link says : For example, if you are having problems sending over SMTP between two...