embedding a DTS package which contains a 'Copy SQL Server Objects Task'

Hi,

I am getting an error when doing the above.

I create a new SSIS package, drag in an Execute DTS 2000 Package Task, select and embed a DTS package which consists only one one task (as above), and then change the source & destination details (svr + user/pwd). Then when I go to the Copy tab, I get the following error when I hit Select Objects, to view the objects which the embedded DTS package should copy:

SQL-DMO error 21776: general error.

On further inspection, none of the objects selected for copy within the atomic/original DTS package, remain selected for copy within the embedded DTS package.

I have googled to search for an answer to this one, but to no avail. Any ideas would be greatly welcomed.

Thanks,

Tamim.

Off the top of my head I am not sure...but I wonder if there is more to this or perhaps what the real goal is?

I ask because if your only dealing with one transfer task from a dts package, then why not just create a new SSIS package using the new ssis transfer tasks? Prehaps you have 100s of said DTS packages, and you need to keep them going rather than rebuild all. However, we should always keep in mind that while the Execute DTS 2000 Package Task is nice for 'keeping things running' from the old version, over time you will want to rebuild any DTS pacakge as a 'native' SSIS 2005 pacakge allows you to do a lot more AND DTS is considered a deprecated technology, which does mean its fading form the picure. If you want you can read more about that here.

http://msdn2.microsoft.com/en-us/library/ms403408.aspx

Hope that helps.

|||

'...if your only dealing with one transfer task from a dts package, then why not just create a new SSIS package using the new ssis transfer tasks?...'

Sure. And that's exactly what I did, thus reducing the problem to being merely academic - but it's still there....

Thanks Craig,

Embed excel object in report

Is it possible to embed an excel worksheet in a report? I have a workbook which contains some data and this data needs to be part of the report. What are my options and can this be done by creating a custom report item.

Thanks for your advice.

dipi

You cannot directly embed an excel object into a report. You can however use ODBC to retrieve the data from the workbook as an RS dataset and then create a table from the data.

Ian

embed barcode in pdf

We export a report (pdf format) from Reporting Services that contains
barcodes. If someone tries to view the pdf on a computer that doesn't have
the barcode font loaded it doesn't show up. Is there a way to embed the
barcode image in the pdf?
Thanks,
TimPerhaps someone else will jump in but I am pretty sure there is no way to
embed the font in RS 2005.
RS 2008 will have barcode support (part of the Dundas controls that
Microsoft purchased and is including in RS 2008). This support will allow
you to get around this problem. Today your only choice is to have anyone
that needs to print barcodes to have the font on their machine.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tim Kelley" <tkelley@.company.com> wrote in message
news:u4W0JmwpIHA.4292@.TK2MSFTNGP04.phx.gbl...
> We export a report (pdf format) from Reporting Services that contains
> barcodes. If someone tries to view the pdf on a computer that doesn't
> have the barcode font loaded it doesn't show up. Is there a way to embed
> the barcode image in the pdf?
> Thanks,
> Tim
>

Editing Varchar field in Enterprise Manager

I am using SQL 2000. In a table (tblTestTable) I have a field VARHCAR(4000).
the field stores text taken from a text area in a web page so contains new line characters also length is around 2000 characters.

The problem is that I am unable to edit the text in this field through Enterprise Manager. The text remains as if it is readonly. All I can do is select entire text and cut or delete. :confused:
Is there reason for this occurance? How can it beovercome?Don't use EM?

It really wasn't made for that purpose, but I'll have a look.

Editing the Subject textbox on SSRS Email Standard Subscription

Hi

Does anyone know if it is possible to edit the subject text box of a Standard Email Subscription so that it contains report variables other than the default Globals and if so, how?

Basically I want to add a value field from the report I'm emailing into the subject line. I've already discovered that you cannot use the rest of the Global variables in the subject line other than the default @.ReportName and @.ExecutionTime.

The variable I want to add is in the report dataset.

Any help would be greatly appreciated.

Thanks

RW

Sorry, I don't have the link to the site I saw this on, but I did read that @.ReportName and @.ExecutionTime are the only 2 parameters available.