Lynn, when I got into this company 5 months back , and it is and insurance brokerage doing well but small (30 employees), they had 2 IT personnel, I suggested...

Thanks all for you ehlp. I will procede trying your example. and by the way, this is the most explicit he has been on what the script needs to do....

Ok here was my solution that works well.

1. use the file system task in the Control flow tab right click the file system task and choose edit. It allowed me...

Clear thanks!

Thanks Greg. I am stuck between 2 rocks and a hard space.

I save in server storage , error,can't save.

So I tried micosfts next method for getting a package to run...

We had the same problem, to run sp from SSIS -OLE DB Source, we had the change #table to @table in the sp and it worked.

Also if someone could point me to the code that exports what is selected to excel 2000 including column headers I would be quite thrilled. Currently we use SSIS but...

Thanks for you answers. The say it is running slow. They are using an Access front end through citrix terminal server to ,select update, and insert. Of corse Access is...

would not be my approach but Boss says.....

Anyhow we have a couple funtions in an access.mdb that move pdf files then update sql tables.

the access.mdb has a DoCmd.Quit in the...

Thanks so much for the image info. I will look into using them too!

This will not help in this case but I have learned how to manual create a package...

Normally you can go to edit and see the info. but if you notice in the Properties box the ConnectionSource is another package (inner.dtsx or something like that). So you...

Super thanks!

Thanks so much, it works! I would like to know the syntax if the tables where on different servers? how would I bound those.

From

different Instances on same box:

Instance1Name.DBName.dbo.Table1.Col1 ??

AND

Instance2Name.DBName.dbo.Table2.Col2 ??

different...

NO. Thanks I will try your suggestion now.

CREATE TABLE [dbo].[Application](

[ApplicationID] [int] IDENTITY(1,1) NOT NULL,

[Complete] [bit] NOT NULL CONSTRAINT [DF_ApplicationNew_Complete] DEFAULT ((0)),

[TransactionType] [varchar](2) NOT NULL,

[StatusActive] [bit] NOT NULL CONSTRAINT...

DO I need a cursor?

Where Live.dbo.Application.CertificateNrClean = Test.dbo.Application.CertificateNrClean

Error says a column in the Where cannot be bound. hhmm

DO I need to put it into a variable when selecting from test...