Create induviual Package configuration for each Connection manager in a package . And make connection manager name same in all the package and choose the Same configuration file for the...

may be you can use this

Declare @mgrid int,@empid int

set @empid=234

declare @hir table ( empid int,mgrID int, title varchar(255))

select @mgrid= ManagerID from dbo.Employee where EmployeeID= @empid

while (@mgrid is...

What you mean dump a table from an object variable.?

Can you...

you can try assemblies ..but COM assemblies were deprecated in SQL Server 2008 Analysis Services (SSAS)

http://technet.microsoft.com/en-us/library/ms175398.aspx .

How xml data is stored in table.?

oledb source and destination to move data from database to another if its stored in table

My suggestion to you is create two package instead of single package trying to do everything in one package

two packages are

1) First package will identify the error data and...

HI Greg,

you can try a work around by putting a conditonal split just after the flat file soruce and checking for condtion like

FINDSTRING([ActionDate ],"|",1) <= 0 (you can...

hi,

if its not a highly transactional table try creating a clustered index on timestamp. unique index on the key coloumn.