D is a local drive

Regards

Alexander

SSIS is more suitable for data transfer (like DML) and not to transfer object definitions (like DDL).

Have you already tried the Import/Export wizard from management studio (context menu of a...

Kinda basic:

Is your XXX.dtsx already existing in the bin directory?

Do you have file system write permission on the file and the directory?

First of all, SSIS is not a component that is supposed to have unser interaction, because it is a server technology, so I would not do this.

If you really want...

According to http://msdn.microsoft.com/en-us/library/ms143761.aspx the ssis differences between SE and EE are only a few tasks and transformations that have to do with term extraction, some fuzzy stuff and data mining.

No...

I am using server storage and I am not using a config file.

Unfortunately there is no other error message in the screen log.

I have saved a copy of the package to sql server using server storage protection level and executed the package from the ssis instance from within ssms.

The command line is:

/DTS...

Hi Kevin,

From your data source connect to a multicast transform. The first output is to be sorted by ntname the second by manager. Then join the two thread (probably left...

Now I found out that Report B accepts the parameters only as fully qualified MDX member names like "[Time].[Quarter].&[Q1 2007]" and that the first report passes only "Q1 2007". Of...

I had tried it before setting it to

=""

but then ssrs is autonumbering the columns starting with 1. But now I tried it again, this time with

=" "

(notice the blank),...

The component that inserts the two rows is the only component that is aware of the fact that these rows have been imported in the same transaction. So you have...

Have a lool at my suggestion above

Hi,

what about generating a uid inside the transaction:

declare @U uniqueidentifier;

create table #mytab1 (x int, y uniqueidentifier);

create table #mytab2 (x int, y uniqueidentifier);

begin transaction

set @U=newid();

insert into #mytab1(x,y)...

Looks like you need to join the table with itself. But from the example you give I cannot understand what your join condition should look like.

Please give more information which...