It might be easier, after installing some/any zip package on the server, to simply invoke if from t-sql (using xp_cmdshell) or the command line.

Jeff -- I am continually amazed at the effort you put in to help us all out. Thanks very much!!

I was unable to get ownership chaining to do what I needed. I finally took the cowards way out and simply moved the tables from the "other" database to the...

Final resolution: Rather than trying to edit the column size definitions in the metadata, I had best results by just fixing the source table, and then deleting and recreating the...

I was also unable to get SSIS to refresh the definition of the source and/or destination tables after those table specifications were changed. Worse, I could find no way...

Jeff Moden (6/24/2008)

---

The major point has been missed... Andras explained it. You need a date column or an IDENTITY column to figure out what the last row actually is....

Kevin, I'm sorry, I got my threads confused and gave you information that was related to my other problem, not the Preview problem.

But I still avoid the preview option, since...

Thanks for testing.

My problem, is that the source table definitions have changed, and I am trying to get them to conform to the destination tables. (Longer story, the source...

Thanks.

The Access DB, and "Microsoft SQL Server Integration Services Designer

Version 9.00.3042.00" (is that BIDS?) are running on my desktop.

The destination database is on a server.

I have had a bit more...

I was getting worried when I got through 5 or 6 pages of this thread and hadn't seen Jeff Moden jumping in to point out that different types of row-by-row...

(Guesswork follows...)

Does "select * from balaji1" work without the insert statement? (Is balaji1 a table/view in the SQL Server database?) Might you need to further qualify the select statement source...

Hang in there Terry, sooner or later someone who, unlike me, knows what they are talking about will join in.

I'm surprised that the documentation for http://FTP.ReceiveFiles seems to expect...

OK, another wild guess. It looks like your "file names" is expected to be a string array. Might you have it as a simple string?

Wild guess (since you have not gotten any replies from those who know)-- with those symptoms, the first thing I would check is the FTP BYE command in my http://FTP...

Michael - thanks, good pointer. (I know hardly anything about BIDS, and understand even less, having used it just to create SSIS packages.) But now that (thanks to...