Hi,

Sorry - here's the script:

declare @CurrentUser sysname

select @CurrentUser = user_name()

execute sys.sp_addextendedproperty 'MS_Description',

'Test Description',

'user', @CurrentUser, 'table', '[DWStage].[Sales]'

and here's the error message:

Object is invalid. Extended...

Hi, I ran into the same problem now. I tried using the ODBC Data source connection but I can't find the DB2 driver. does anyone know where to download the...

was able to figure it out through this http://www.databasejournal.com/features/mssql/article.php/3616526/MDX-Operators-The-IS-Operator.htm. thanks!

thought so.

I tried using tsql thru xp_findnextmsg and xp_readmail. With this, i can get the location of the attachment and have a script copy that file and save to a...

as for the temp table, yes it's a global temp table.

As for the runtime, i think there will be no changes in the package structure/components.

I will be looking forward for...

I have one SSIS package that have a parameter "clients" This package basically extracts data from a data source and dumps it into a temp table for every client every...

Hi,

I was able to use lookups and it worked fine.

I was also able to solve the problem I had with merge joins.

It seems that my data sources are not "pre-sorted"...

Hi,

thanks for the input.

However, I can't use sql inner join query since these 2 tables are located in 2 different servers that are not linked.

I'm also not allowed to create...

Hi,

I did everything stated in the instructions but I am getting this error:

An error has occurred during report processing.

Cannot create a connection to data source 'TEST'.

For more information about this...