Grant thanks for the reply. Yes that's exactly what I did last night just did a standard restore from the mdf ldf files. I was a bit thrown by the...

If you are saying that the agent account under which this package is executing has sa permissions on the remote server, then the issue is defintely not with the login.

Remember...

Without doing a good bit more digging on the issue I'm harbouring a guess that you may have an issue with kerberos authentication on some of your servers.

You might want...

Hi,

We use package configurations and save the password on a config table on the sql server.

Works like a charm. You can't use expressions to set the password and the only...

Lots of good webinars on the Pragmatic Works website & http://www.bidn.com/

Watching videos I always find helps a lot when you are learning as you can actually see someone...

Try this code so you can do a string search with the package xml:

SELECT [name] AS SSISPackage

, CONVERT(XML, CONVERT(VARBINARY(MAX), packagedata)) AS PackageXML

FROM msdb.dbo.sysdtspackages90

WHERE CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), packagedata)) LIKE '%YourTableName%'

This will at...

Drew,

As my above post states the sysdtspackage90 (sql 2005 as its sysssispackages in sql server 2008) stores the package as an image. SSIS packages are all essentially xml so you...

Hi Ganga,

I suppose it depends how you are running your SSIS packages. You can use the set values within the sql agent job calling the package and configure variable values...

Hi Priya,

This is not possible from MSDB without an extremeply long winded method. You can convert the packagedata column from sysdtspackages90 back into it's xml and then read that xml...

I always find this link (especially the chart at the bottom) useful for matching up sql server data types to SSIS data types

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

G

Thanks for everybody's help.

I ended up using the RANK statement and attaching a Rank column and then joining the positive and negative values on the policykey, absolute value and rank.

This...

Yes thanks for the advice on posting. Just started a new job last week have been thrown in the deepend in a new industry working on helpdesk issues to get...

Some more detail:

Policy Key Premium

---------- ----------

123456 ...