hi,

The solution is in the constraint.

After that you assign a value to the variable you need

to check it.

edit the first constraint and change the following parameters :

1) Evaluation...

Hi,

You can change the parameter "ForceExecutionResult" to success

for the task inside the foreach container.

There is an excelent example at :

http://rafael-salas.blogspot.com/2008/03/ssis-and-dynamic-excel-destinations_01.html

Look at link :

http://www.sqlservercentral.com/Forums/Topic455318-148-1.aspx

Hi,

What you need is : Microsoft SQL Server 2005 Upgrade Advisor.

BufferTempStoragePath is the file system path used to temporarily cache buffer data.

As you say, sometimes it happen means the the problem is not permission.

I think that you have a problem...

Not only on identity column.

Switch just change the table name without considuration of the structure.

By the way, even in sql server 2008 there is not an alter table command for...

By the way,

I allready executed my example and you can trust me it work !!!

1. rbarryyoung ,

There is no need to have a partition table to execute a switch between 2 tables.

2. Gouthama Kolivad,

wrong, when you use...

If you know another solution then i will be happy to learn.

Hi,

True, you need to use "File System Task".

After adding the File System Task to your control data , choose edit.

steps :

1) Change operation to : Renaming file.

...

Hi,

First, you can't change the column to identity.

You must add a new column or to create a new table

with an identity column.

I choose to use the second choice.

CREATE TABLE TABLE1

(

COLUMN1...

Hi,

The space in the date value is not the problem

You just need to convert the date to smalldatetime.

example :

create table #tmp(

a varchar(20),

b char(1),

c varchar(3),

d smalldatetime)

insert into #tmp

values ('LocalSales','S','N.L',

...